In the process of moving an access database (created in Office2K) from an old Netware server to a 2008 windows server. I'm noticing that the database takes almost 30 seconds to open. Once open it seems OK. The database uses linked tables and I re-linked them thinking that was the problem but it had no effect. Any suggestions?
Access database slow to open on 2008 Server
1 reply to this topic
Posted 26 October 2011 - 03:40 AM
Likely it is the structure of the original DB. I am not sure if it is possible, but you either update the file version on the DB or migrate the DB data into an updated access DB. The issue is probably related to determining where all of the structures are in the older format. I have heard that 'compressing' the DB might help too, but that would also require a file version update.
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users