By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,841 Members | 1,761 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,841 IT Pros & Developers. It's quick & easy.

Trying to share database - HELP!

P: n/a
I'm trying to share my Access Database with a co-worker, however, they
won't be able to delete. Anyway, the database has been put on a shared
server where the co-worker can see it, but can't open it because of the
following error message:

"The Microsoft Jet database engine cannot open the
file'J:/job_orders-new.mdb'. It is already opened exclusively by
another user, or you need permission to view its data"

I've given that person permission from my computer, but I still can't
get them to view. Also, I've closed the database on my end, so it's
not open, but still no luck.

What is the correct procedure to get this done? Any help is greatly
appreciated.

Barbara

Nov 20 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Hi Barbara,
Sometimes the lock file - the ldb file access creates does not get
updated or removed. Manually deleting that will often help. If you
both need to be in the database at once, you might have better luck
splitting the database and putting a front end on yours and your
coworker's systems and a backend on the server. If memory serves, in
your menu under Tools, Database utilities, there is a splitter wizard
that I think may help.
Good luck
P

bm****@yahoo.com wrote:
I'm trying to share my Access Database with a co-worker, however, they
won't be able to delete. Anyway, the database has been put on a shared
server where the co-worker can see it, but can't open it because of the
following error message:

"The Microsoft Jet database engine cannot open the
file'J:/job_orders-new.mdb'. It is already opened exclusively by
another user, or you need permission to view its data"

I've given that person permission from my computer, but I still can't
get them to view. Also, I've closed the database on my end, so it's
not open, but still no luck.

What is the correct procedure to get this done? Any help is greatly
appreciated.

Barbara
Nov 21 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.