Jump to content

Access database slow to open on 2008 Server

Recommended Posts

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?


Link to post
Share on other sites

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.

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...