Access database on Server 2003 (rights issue)

J

Jay

I have an access database located on a 2003 Server. I am using a
connectionstring to connect to the database using ADO. Access is denied by
the clients if the clients do not have administrative right to the server.
How do I get around this problem. I want the users to login without
administrative right.

Thank You for any help with this.
 
6

'69 Camaro

Hi, Jay.
How do I get around this problem. I want the users to login without
administrative right.
Click to expand...

Give each Access database user "Full Control" Windows security permissions
on the directory where the database file is located.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
 
J

Jay

Or I can put them in a group and give the group full permission on the
folder. Correct?
 
Top