Error 3045 on an MDE file

Error 3045 on an MDE file - HELP

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Willow - 21 Dec 2006 12:58 GMT

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

Reply to this Message

Douglas J. Steele - 21 Dec 2006 13:42 GMT

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)

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

> Hi
>
[quoted text clipped - 21 lines]
>
> Willow

Reply to this Message

Willow - 21 Dec 2006 16:29 GMT

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.

Reply to this Message

Douglas J. Steele - 22 Dec 2006 20:49 GMT

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.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

> 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.

Reply to this Message

Douglas J. Steele - 22 Dec 2006 20:49 GMT

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.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

Reply to this Message