Security newbie

[Guest]

I need to secure a departmental database with a few different groups of
users. The database is split. The backend is in a network folder and each
user will get a copy of the front end.

My startup up form uses VBA a connection string to connect to the front end
database.
How do I secure both the front and back end ? Do I need a password in the
connection string? Are there any concise articles about securing a split
database?
I tried to password protect the backend, but got a invalid password message
when I opened the front end.

 

[Stuart Jack via AccessMonster.com]

Hi Joe

Here are a couple of links to articles that may help.

Article ID # 305542
http://support.microsoft.com/kb/305542/en-us

Search for the document below in the Knowledge base, I tried the link and it
seems out of date but I know the document still exists, it is pretty good and
worth finding.

Frequently Asked Questions About Microsoft Access Security for Microsoft
Access versions 2.0 Through 2000 (
http://support.microsoft.com/?scid=http://support.microsoft.com/support/access/content/secfaq.asp
)

Also a search for splitting FE & BE of a database will pull up info which
would be useful.

Good luck

Regards

Stuart