network users can't connect to backend tables

  • Thread starter Thread starter scarlet kat
  • Start date Start date
S

scarlet kat

I have created and Access 2007 app. I split the db and put the backend on a
Windows 2000 Server. I have set permissions on the db_be.ACCDB file and the
directory that it is in to include full control by everyone and the user
account that we all use. There is no problem reading and writing to this
directory, but when the front end tries to connect to the back end I get the
error
"The microsoft office access database engine cannot open or write to
\\server\directory\db_be.accdb. it is already opened exclusively by another
user, or you need permission to view and write its data."

I no locks on the tables, and no passwords on the db, and no one else is
using the db.....
Not sure what else to try. All the forums for this error message relate to
..net connections.
 
To clarify, this is problem occurs when the user is running the app frontend
with Access Runtime, as all of my users will need to do. When the user has
access 2007 and can go into Linked Table Manager to refresh the connections,
they can get to the tables. Can this all be done in code for the Access
runtime users?
 
Back
Top