splitting database/securing it

[Guest]

Hello everyone,

I am constructing a database at home using Access 2003. This database will
be used at work by multiple people. I have split my database, saving the BE
to a CD from which I will install the data onto the network server at work.
And the FE will be installed on each pc. I am not a developer, the arena of
servers is unfamiliar territory. I'm assuming that downloading the BE into
the server, is just knowing which drive the network server is on. Am I
correct?

Are there any problems that might arise, which I should be aware of? Also
this database will be secured, I know Access has a secured feature to it.
But can it be applied when there are multiple users in this case?

Chantel.

 

[Guest]

1 Use the full path [\\server\directory\shortcut] instead of mapped drive
[N:\directory\shortcut] to the shortcut calling the database file and the
associated workgroup file.
2 For the server directory give Create permission along with Read but not
Delete.
3 Use User and Group Accounts along with User and Group Permissions and
not the User-Level Security Wizard.
4 Create a new Workgroup file, join it and ensure you are a member of
Admins. Remove Admins membership from Admin and Change Logon Password for
Admin and yourself. Remove Admins membership and all permissions from Users.
5 Login as yourself and create the new database; for distribution use
another Workgroup file with the same Personal IDs.
6 All PCs must have the same Reference Libraries loaded. As for selected
Available References the lesser the better.
There are several other issues you may come across: I have listed the main
ones.