469,927 Members | 1,780 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,927 developers. It's quick & easy.

I just inherited an Access Database but I cannot access any data

A little about me... Iíve build a few Access dbases but I consider myself a novice. I have never inherited someone elseís Dbase. The dbase is not password protected, but I cannot access all of the components. Some tables & some queries, yes, but not all. When I access the dbase from someone elseís computer ( logged on as that person), I have compete control.

When I try to access the dbase as myself, this is the error I get
' The Microsoft jet database engine cannot open the file "......mdb". It is opened exclusively by another user, or you need permission to view its data.

Today is Saturday, no one else is here to use the dbase, so I must need permission. Has anyone ever had this problem? Please advise. Thank you in advance.
Sep 12 '09 #1
3 1540
32,232 Expert Mod 16PB
This sounds like the file is already locked by another user (Look for the .LDB file). If not that, then your network account may not have read/write access to the file.
Sep 12 '09 #2
8,800 Expert 8TB
Are all PCs using the same Workgroup Information File (*.mdw)?
Sep 12 '09 #3
3,532 Expert 2GB
Since we're obviously talking about a database with multiple users, the first thing I wondered was whether or not this is split into front end and back end, with the back end (with data) on the shared network drive and a copy of the front end on each user's PC? Trying to access a single, non-split database, located on a network, from multiple machines, can lead to all kinds of hinky behavior, including things you've mentioned here.

Welcome to Bytes!

Linq ;0)>
Sep 12 '09 #4

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by SLE | last post: by
1 post views Thread by bettina | last post: by
3 posts views Thread by Russell Read [MSFT] | last post: by
3 posts views Thread by Paul Michaud | last post: by
4 posts views Thread by Mihai | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.