Creating user privileges for read/write permission in the Access 2

  • Thread starter Thread starter Hittokiri
  • Start date Start date
H

Hittokiri

Hi, I'm creating a database that tracks grants for an organization. I've
created forms where user can edit and view the grants. However, there are
only two specific users that has the read/write permissions and all other
users have read only permission. How do I acheive this in Access 2007 without
splitting the database? The database is going to be on a shared server.

Another question. How do I access the data from another access database
that's on the same directory on the server? I'm trying to access a personnel
information that's on another database that has required info from a form on
the current new database i'm working with. This might actually server the
purpose of what i'm trying to acheive in my first question. Thanks in advance.
 
Multiple users MUST use a split database. Not doing so may cause irreparable
corruption. Secondly, you can only build user-level security with an MDB
file type. The only other method of creating a read only group is to do than
on your network and set permissions to one group to read-only on the
database file, and the other group gets read/write. It is especially
important to split the file if you do this as the read/write users will
invariably corrupt the file if they hang their machine during a write.
 
Thanks for the post. I guess I'll have to go with that.

I still haven't figured out how to access data from a table in another
database in the same directory. Any help will be appriciated. Thanks.
 
Hittokiri said:
I still haven't figured out how to access data from a table in another
database in the same directory. Any help will be appriciated. Thanks.
Click to expand...

Easy enough. Write a query like:

SELECT *
FROM [C:\DataFolder\Data.mdb].tblYourTable;
 
Back
Top