Sharing Access Databases

[Vince]

I have recently been tasked to explore building a simple
database from information stored in Excel. The potential
problem is shared access to this database. Is record
level locking the way I should go if I want to allow
mulitple users to browse the data but not necessarily
modify it at the same time?

 

[Alexis]

-----Original Message-----
I have recently been tasked to explore building a simple
database from information stored in Excel. The potential
problem is shared access to this database. Is record
level locking the way I should go if I want to allow
mulitple users to browse the data but not necessarily
modify it at the same time?
.

No,
Sounds like you need to make it a secure database and
assign users with specific permissions on different user
groups.
Here you go check below to find out how:
http://support.microsoft.com/default.aspx?scid=/support%
2faccess%2fcontent%2fsecfaq.asp#_Toc493299660

 

[Alexis]

-----Original Message-----
I have recently been tasked to explore building a simple
database from information stored in Excel. The potential
problem is shared access to this database. Is record
level locking the way I should go if I want to allow
mulitple users to browse the data but not necessarily
modify it at the same time?
.

No,
Sounds like you need to make it a secure database and
assign users with specific permissions on different user
groups.
Here you go check below to find out how:
http://support.microsoft.com/default.aspx?scid=/support%
2faccess%2fcontent%2fsecfaq.asp#_Toc493299660

 

[Vince]

----- Alexis wrote: -----

-----Original Message-----
I have recently been tasked to explore building a simple
database from information stored in Excel. The potential
problem is shared access to this database. Is record
level locking the way I should go if I want to allow
mulitple users to browse the data but not necessarily
modify it at the same time?
.

No,
Sounds like you need to make it a secure database and
assign users with specific permissions on different user
groups.
Here you go check below to find out how:
http://support.microsoft.com/default.aspx?scid=/support%
2faccess%2fcontent%2fsecfaq.asp#_Toc493299660

Thank you. I appreciate you taking the time to answer and a possible source of information for me to explore.

Vince.