We have an Access97 based DB that is accessed over a network using 5 Windows 98 PCs. The PCs use NetBEUI to connect.
Recently the Programs that connect to the DB have slowed down (generally on DB access)
We have compacted the DB, but it is still about 150Mb. (It was 200oddMb)
Is there a rough guidance that specifies how large a DB should be?
Would changing the network protocol affect the speed? If so, Which would be better?
Many thanks for suggestions.