split database and queries

  • Thread starter Thread starter RJ
  • Start date Start date
R

RJ

I have split a database for multi user access. However
now none of my queries work as they state that the table
that they are accessing are not marked for reading. I
have checked the tables and they are marked with all
privileges so I am not sure why I am getting this error on
all of my queries? Any Ideas?
 
I have split a database for multi user access. However
now none of my queries work as they state that the table
that they are accessing are not marked for reading. I
have checked the tables and they are marked with all
privileges so I am not sure why I am getting this error on
all of my queries? Any Ideas?
Click to expand...

Doublecheck that the backend database is in a folder to which you have
full update, delete, and rename permission; Access needs to create and
delete a .ldb file in order to open the database so it's not read
only.
 
Back
Top