Table Permission

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I have a situation that when more than two users use the same table in
Access 97, then nobody can open that table again unless one of the users
close the table.

I want to know if there a place or a file that I can set to avoid this
problem.

Thanks,

Carlos Rivera
 
What do you mean by "opening the table"? typically, users should not work
in a table. Tables are data holders, not user interfaces. The users should
be working in forms, reports, and sometimes queries.

That being said, can the users not open that TABLE, or can they not open the
entire FILE? Or are they given a READ-ONLY warning? What is happening to
cause you to think that the table can't be opened again?

If it were me, I'd check the Windows permissions on the file and make sure
all your users have full permissions. My guess is that someone does not
have access to write or delete from the folder where the database lives.
Because they need to be able to manage the ldb file created by the first
database user, they are running into trouble.

Unless you give us specific error messages and details, I don't know if you
will get a better guess.
 
Back
Top