Problem opening localy the backend

[emarti]

Dear all,



I have the following problem and I don’t know what I can do.

I have a database split into the backend in a shared folder in a server and frontends in several PCs.

The problem arises when I try to open a copy of the frontend directly in the server. When the frontend tries to access the backend (in the same machine) an error arises saying that the backend is lock (it is lock because other people are working in it from theirs PCs, multiple connexions are allowed obviously). If everyone closes their frontends, a different problem arises when traying to access a table.

I develop the database in office 2007. In the server I installed access runtime 2007. The back end is in *.accdb.
Thank you very much for your help.

[June7]

I also have a split 2007 database with distributed frontends. I have no problem opening frontend located on the server the same time as users opening copies on their PCs. However, I don't have access runtime, not even sure what that is.

[dblife]

I had something similar with the same setup on one of my databases but on A2000 where the FE's were on the users desktops.
Turned out to be one of the users had a really old version of Windows and it kept leaving lock files open on their desktop. They in turn would find a backup copy of the FE on a shared drive and locked that one open too.
We stopped them using that machine for this and it was fine after that.

[Rainlover]

Where is the FE on the server? Is it in a different folder to the BE.

If both FE and BE share the same Name and same folder you will have problems.

I may be on the wrong track but worth a mention.

[emarti]

Thank you very much for you answers.
The FE in the server is located in a diferent folder.
I linked the tables with some like \\server\folder\backend.accdb; it looks like when opening the database from the server it behaves diferently...

[June7]

Sorry, can't explain. I open FE on server in folder different from the BE and all works ok. I also use the UNC pathing for table links.

[boblarson]

Does the Access installation on the Server have the same updates/service packs for Office as does the other computers? Also, on which version of Windows Server is this located? What is the actual path being used?