General discussion

Locked

Server Runing Access Databse

By StealthWiFi ·
Hello-
I am currently the network admin for a small company with about 10 physical users and 4 VPN remote users. My company recently purchased a custom written database for handeling insurance information and reports for a partner company, I don't know much about Access but I have been put in charge of making sure the 10 users can run the databse for entering info and 2 of the remote VPN users (from the partner company) need acces to view the data, one of the problums that this being a custom databse we can not allow the partner company to be able to obtain any source code or info that will allow them to reproduce this databse. I would like to run the databse on Windows server 2003 and just set up permisions to allow user to view and edit what they need to,I am also very concerend wit hsecurity, that being my mane school of thought, any sugestions on going about this?
Thank You all very much!

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by pierrejamme In reply to Server Runing Access Data ...

Personal Opinion? Access is not for a server database you were sold a crock. You need something more thnone user can access at a time. Sounds like you physicians are tight.
sorry, you asked.

Collapse -

by StealthWiFi In reply to

Poster rated this answer.

Collapse -

by curlergirl In reply to Server Runing Access Data ...

The only way to control permissions on an Access database is by using the security settings within Access itself. Other than that, basic NTFS permissions are all you have. Within Access, you can set permissions on a database by using the Workgroup Administrator to set up a workgroup; then you add users to the workgroup and set their permissions. The users then have to join the workgroup and log in each time they open the Access database. This is easiest if you are using Access 2003, but the functionality is also in Access 2000 and 2002, just not quite as sophisticated. Look into the help file for the version you're using and you should be able to find basic setup instructions there.

The only issue will be, since this is a 3rd party database, you may have to get a special administrator level password from the folks who wrote the program in order to gain access to the Workgroup Administrator and security settings.

Hope this helps!

Collapse -

by StealthWiFi In reply to

Poster rated this answer.

Collapse -

by StealthWiFi In reply to Server Runing Access Data ...

This question was closed by the author

Back to Networks Forum
5 total posts (Page 1 of 1)  

Related Discussions

Related Forums