split database and queries

[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?

 

[John Vinson]

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?

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.