Can not share the back end data base under Multi user enviorment

[htadis]

Good day !

I have a Access data base (2007) which i splitted and store the back end database in a file server where all users have full control and the individual copies of front end put in the users computers. Unfortunately when one user is using the programme, others can not use. Following error msg appears. Both back end and front end are running under shared mode ( not exclusive ).

"Could not use xxxxxx_Be.accdb; file already in use."

Could you kindly advise a solution for this.

thanks.

 

[MarkK]

Can you elaborate on this: "Unfortunately when one user is using the programme"

How does your user run the program? How does that user's FE connect to the BE? What is the exact operation that yields the error? Are you opening a recordset, for instance?

 

[htadis]

Markk,

thanks for yr reply.

How does your user run the program?
They simply run the FE Access file.

How does that user's FE connect to the BE?
Linked through the Local network.

What is the exact operation that yields the error?
If one user is open a data entry form, other users can not log-in or open any data entry form.

Are you opening a recordset.
yes, in some cases.

 

[shadow9449]

I've encountered this annoying problem. It SEEMS to happen more in Access 2010 than other versions. One thing I've tried that sometimes helps is to set the target of the desktop shortcut that points to the FE to the location of Access rather than directly to the FE.

So, it might look something like this:

Start in: "C:\Program Files (x86)\Microsoft Office\OFFICE14\MSACCESS.EXE" C:\MyFE.mdb

Rather than C:\MyFE

I haven't been able to solve it for all users with this problem and I wish someone would have a solution that works consistently.

SHADOW

 

[htadis]

I think i found the solution. Do not know whtr this is the exact solution for this, but it works with my requirements.

it is required to give full rights to the BE file as well as the folder which contains the BE file. in the folder you must set both Share and security rights in full for all the users, then it is allowed to share the file simultaneously.

thought to mentioned here assuming that it will help for some one else.

thanks !

 

[MarkK]

Thanks for posting back with your solution!