Access 2003

[ShadowRider]

I've been tasked in resolving a problem. We can not always open a database
that was created using Access 2000. We have three users that have the same
rights but one can not open the database, it locks up Access. All three are
using Access 2003.
I can open it on my PC logged in as the user who can't at his PC, at another
PC logged in as him I can not open the DB. Are there some settings I am
missing?

 

[Jerry Whittle]

1. All users of the database must have at least read, write, and modify
privileges to the folder holding the database file. Not just the database
..mdb file, but the entire folder.

2. Open the database and go to Tools, Options, and Advanced Tab. Set the
Default Open mode to Shared and the Default Record Locking to Edited Record.
(While you are in the Options area, go over to the General tab and turn off
Compact on Close and Name AutoCorrect. Trust me on this.)

 

[Dale Fye]

Jerry,

Why turn off "Compact on Close"? I normally turn this on in the front-end
database I provide my users, although I have gotten to the point where I
generally put temp tables in an external mdb and link them to the front-end,
so there is very little growth of the FE during any particular use.

 

[Jerry Whittle]

Hi Dale,

Twice I've been burnt buy Compact on Close that messed up databases. Also
I'm of the opinion that a properly disigned database should require
compacting infrequently like once a month. Databases often grow just enough
to have some "wiggle room" for sorting and grouping. Compact them and they
just grow back to the 'working' size.

Also I often have a fresh version of the FE copied to the user machines on
startup so that compacting isn't required.

 

[Dale Fye]

I generally only push them a new FE if the version number of the application
has changed, but will keep that in mind.