Access error

[Guest]

Hi
I'm curently getting an error for a single user who is trying to access a
shared database running under access as part of office 2003.

I've seen other people reporting the same error "could not find the object
MSysDb" and the suggestion is to run the compact/repair within Tools.

I'm unwilling to follow this procedure as a number of other users are able
to use the database with no problems.

I'm sorry if this is a silly query but I'm network support not databases!

Many thanks for any suggestions.
Stephen Burns

 

[Arvin Meyer [MVP]]

Running Compact and Repair is a regular maintenance procedure. Depending
upon the size of the database and the number of users, it should be done on
the back-end (the data running on the server) at least weekly. More often
for large databases or more than 20 users. The fornt-end (the application
code which must run from the workstation) should just be discarded and
replaced when to get this happening unless there are local temp tables in
use. You can repair front-ends, but it is faster just to delete and replace
them. Front-ends normally need more frequent compaction as the back-end
grows larger. That is good practice because it decompiles queries allowing
new query plans to be created as the data requires them.