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

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

 

[Arvin Meyer [MVP]]

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.

 

[Hittokiri]

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.

 

[Marisol y Javier]

chaoooooooooooooo

 

[Arvin Meyer [MVP]]

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.

Easy enough. Write a query like:

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