I've run a networked Access97 app for years with no problems. But it has slowed down dramatically after a recent migration from Novell NetWare version 5.0 to Windows Server 2003 with Active Directory Services. I'd appreciate any suggestions for speeding it up (without having to move to a different version of Access, SQL Server, etc.)
The Access97 app is split into front end (queries, forms, reports, macros & modules) and back end (data-containing tables) portions. The back end is on the server. Each user has a copy of the front end on the user's local PC. Before the migration, the local PCs ran a version of Win2KPro created by upgrading each local PC from Win98 to Win2KPro. As part of the migration, a clean install of Win2KPro was placed on each local PC.
Regards, Blake
The Access97 app is split into front end (queries, forms, reports, macros & modules) and back end (data-containing tables) portions. The back end is on the server. Each user has a copy of the front end on the user's local PC. Before the migration, the local PCs ran a version of Win2KPro created by upgrading each local PC from Win98 to Win2KPro. As part of the migration, a clean install of Win2KPro was placed on each local PC.
Regards, Blake
