Database Distribution

I have created a database which works well and now it is ready for user input
I have read in various forums that you need to split the database in 2 FE and
BE which I have done I have also read that you need to make a copy to put on
each users desktop.

Here lies the problem: I have almost 200 user does that mean I will have to
make about 200 copies and go to each desktop to install the copy. is there an
easier way of distibuting the database or do I make one copy and get each
user to copy it onto their desktop.

The second question is on workgroups what are they? how do they work and
will I need to create one for my users.

Sorry for the queries I have been creating databasess for my own use but
this is the first time I have had to distribute to a large group.

Any help will be highly appreciated and welcome sorry if this has been asked
somewhere in the groups but I have not found any posts that answer this in a
simple way

Hi Linda

The way I handle this type of setup is to have a central dummy launcher.

Set up a database with an autoexec macro to run some code. My code runs in
the following order:-

1. Check to see if the database already exists on the local machine
2. If the database already exists on the local machine, check the version of
that against the central copy. If it doesn't match, download a copy
3. If the database does not exist locally, copy from the central location to
the local machine.
4. When copy is complete or no copy needed, open the main database
5. Close the dummy launcher

Your network setup and security policies will determine where the local copy
goes. If the users have roaming profiles with a personal network share, I
would recommend downloading the copy to there. If this is not possible, you
will have to put onto the local machine. If you are not to sure how to do any
of this, I can post some code examples if required.

With regards to workgroups, this is used for Access security. Only you will
know if this is required depending on the data your database will hold. In
all honesty, I would prefer to go with SQL server security over Access
security. Not for any technical reason, only that I can "delegate" the admin
of this to our DBA teams.

As I’m unsure as to your level of experience, it's worth pointing out that
you will need an SQL server to handle 200 users.

Jay

--
Message posted via http://www.accessmonster.com