users cant access tables etc in DB

[Guest]

Users on our system cannot access the tables in the DB, but admin can. users
have full program permissions and registry permissions relating to Access.

When an attempt to access the table is made a msg box appears that says
"selected collating sequence not supported by operating system", and on a
second attempt the error "reserved error (-1104)" appears and reappears on
each attempt after.

I have searched the internet for this error and most people say it is
corruption, but it cant be because i can access it with admin privilages.

Any help would be appreciated, i have been working on this problem for about
3 days now with no sucess

 

[Gijs Beukenoot]

From Bennet :

Users on our system cannot access the tables in the DB, but admin can. users
have full program permissions and registry permissions relating to Access.

When an attempt to access the table is made a msg box appears that says
"selected collating sequence not supported by operating system", and on a
second attempt the error "reserved error (-1104)" appears and reappears on
each attempt after.

I have searched the internet for this error and most people say it is
corruption, but it cant be because i can access it with admin privilages.

Any help would be appreciated, i have been working on this problem for about
3 days now with no sucess

Is that "Users on our system cannot access the tables in the DB, but
admin can" happening on the same machine or are they different
machines?

According to the MS-KB (202150) it could have something to do with
• You are trying to open a database or an object in a database that was
created in another language edition of Microsoft Access.
• You are trying to open a database that was created or compacted while
the New Database Sort Order was set to a value other than General.

 

[Guest]

From Bennet :

Is that "Users on our system cannot access the tables in the DB, but
admin can" happening on the same machine or are they different
machines?

According to the MS-KB (202150) it could have something to do with
• You are trying to open a database or an object in a database that was
created in another language edition of Microsoft Access.
• You are trying to open a database that was created or compacted while
the New Database Sort Order was set to a value other than General.


It is on the same computer, and when i make the user part of the admin group i can access it, but then when i take it out of the admin group i cant, and it happens on all Access Databases, even ones created while in the user account, i can create the DB, make a table, then when i exit access and open it again in the same user and within 30 seconds i cannot open the table and i get the above mentioned errors.

 

[Gijs Beukenoot]

From Bennet :

It is on the same computer, and when i make the user part of the admin group
i can access it, but then when i take it out of the admin group i cant, and
it happens on all Access Databases, even ones created while in the user
account, i can create the DB, make a table, then when i exit access and open
it again in the same user and within 30 seconds i cannot open the table and
i get the above mentioned errors.

I would check the (and perhaps create a new) system-database (where the
user-info resides).
You can use Tools -> Security -> Workgroup administrator menu command
in MS Access to create new system database or to select which system
database you would like to use by default. Note that there is no such
menu command in older Access versions; use the standalone wrkgadm.exe
utility to do this.