Error 3045 on an MDE file - HELP

W

Willow

Hi

I hope you can help me with this it is driving me nuts.

I've created a database which I needed to give multiple people access
to but didn't want them messing so I created an MDE file. I ensured
that the MDB file was set to shared, not compacting and set to run
users not owners permissions before I converted.

However, if one of the users goes into the database, it does not create
and LDB file and if anyone else tries to get it, the error message:

Could not use <name>; file already in use. (Error 3045)

appears. Some of the tables in the MDE files were linking to and MDB
file, however, I have removed the links and it is still happening.

All of the help sites and articles refer to what to do if you get this
message when using a b/e - f/e MDB but I can't find anything about
getting this error with an MDE. Its the fact that the LDB file is not
being created that is really confusing.

Please help!!!!!

Willow
 
D

Douglas J. Steele

Does that user have the appropriate permissions on the folder where the MDE
file exists? He/she needs to have Read, Write and eXecute on the folder,
even if they only require Read access to the data. (Having Delete permission
on the folder is a good idea as well. Otherwise, the LDB file will stick
around after they leave the database)
 
W

Willow

Not on the folder, I will need to get ICT to change this.

However, there is no LDB file to stick around, when the file already in
use message comes up, there is no LDB file in existence. It doesn't
appear to be creating one for some reason.
 
D

Douglas J. Steele

If they don't have the correct permissions on the folder, then Access
wouldn't have been able to create the LDB file. Somehow it knows that, and
pops up the message.
 
D

Douglas J. Steele

If they don't have the correct permissions on the folder, then Access
wouldn't have been able to create the LDB file. Somehow it knows that, and
pops up the message.
 
Top