microsoft jet database engine cannot open the file

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I work for a large company and I am trying to run a ms access application
(Access 2000) that connects to a database (created in Access 97) on a local
drive of a pc out in the plant. I have a drive mapping to the pc but I get
the following error:
microsoft jet database engine cannot open the file (followed by the drive
mapping). My colleague has no trouble accessing the same database and we
have identical rights on the network. Do you think it could be a sharing
violation on the microsoft table itself.
 
I am not about sharing violation of the Table but the error message sounds
that more likely, it is still permission problem... There are many factors
than just simply identical rights. For example, the actual file can have
different permissions for you and you collegue. The share name may also
have different permissions for you and your collegue.

Note that you need Read / Write / Create and Delete for files in the
directory where the Back-End MDB resides as well as Read / Write of the file
it self.

I would suggest getting your network people to check your actual permissions
for the share name, directory and file to the database.
 
Back
Top