Network Sharing of Access 2002 Database

K

karenp

I just need plain simple steps as to the best method for sharing a 2002
Access database across my network with the ability for users to be in it at
the same time. (10-15 users - Query, Edit, add)

.....1) I have already created my database on my local machine and I have
place a copy in a network folder. Need permission for the folder but what
about this backend, front end stuff and/or jet engine???
 
F

Fred Boer

Dear Karen:

You need to split your database. This means that you will actually have two
database files: the "backend" file, which will contain only your tables, and
the "frontend" file, which will contain all the forms, reports, queries, and
so on.

The "backend" table will be place in a network folder available to all
users. Every user has to be give full permissions to this folder, that is to
say, full read, write, delete permissions.

A copy of the "frontend" table should be given to each user. The "frontend"
table will be "linked" to the "backend" table.

You can use the "Database Splitter" found at Tools>Database Utilities>
Database Splitter to help you with this task.



HTH
Fred Boer
 
K

karenp

Ok. I have tested this just fine. What if one of the users creates the
super report of his career and he wants to share. If I update the front-end,
it will wipe it out. I suppose there is no other way around me importing his
report etc and the producting the update for each machine.

Karen
 
F

Fred Boer

Dear karenp:

Yes. I think that is true, if the user creates something they wish to keep,
then you (or they) would have to take steps to save it from being wiped out
by the new front end. The user (or you) could create a blank database and
export his own reports, etc. Then, when the new front end is installed, he
could import them into the front end.

However, I don't know of any way around this... Perhaps someone else does?

BTW, when you get to that point, you will want to automate the distribution
of the front end to make your life easier. There are different ways to do
this. Tony Toews's AutoFE updater is an excellent (and free!) tool for this
task. Post back if you need help! http://www.granite.ab.ca/access/autofe.htm

Fred
 
Top