back end db error

[spinkung]

Hi All,

I have created an app which has fe/be mdbs. When i open the fe on a users pc they get an error message saying....

The microsoft jet database engine cannot open the file 'O:\blah...blah\MyDB_be.mdb'. It is already opened exclusively by another user, or you need permission to view its data.

No else is using the db so i'm assuming it must be a permissions issue??

Can anyone help? Thanks, Spin.

 

[MStef]

Open DB window. Click on Tools, Options, Advanced,
In "Default open mode" select SHARED.
In "Default record locking" select NO LOCKS.
Make it in Be and in Fe.

 

[spinkung]

thanks for the reply.

I have checked the db's and both fe/be were set as below?

 

[MSAccessRookie]

Hi All,

I have created an app which has fe/be mdbs. When i open the fe on a users pc they get an error message saying....

The microsoft jet database engine cannot open the file 'O:\blah...blah\MyDB_be.mdb'. It is already opened exclusively by another user, or you need permission to view its data.

No else is using the db so i'm assuming it must be a permissions issue??

Can anyone help? Thanks, Spin.

Does every user have an individual copy of the Front End, or do one or more of them have links from their Desktops to a Front End that is located on one of your servers? Verify that none of the users is using a link to a common program and change it to a complete copy if they are, because if even one user has been set up with a link, then the condition that you are experiencing is a possible outcome.