Help with database sharing

[k]

Hello all, you have been an invaluable source of help for me in creating my
database, it is simple db for small office of five. I have it on 2003
server. How can I become db administrator and allow others in office to work
in it at the same time without changing much of underlying format. We have
not utilized the exchange aspect of server since it interferred with remote
access, anyway is there a way to simply do this without reinventing the
wheel. HELP and THANKS.

 

[Golfinray]

You need to split the database into a Frontend and Backend (FE and BE.) It is
relatively easy to do if you follow the instructions. Joan Wild has good
instructions at www.jmwild.com or google Albert Kallal. He has a good set on
his web site (which I do not remeber the www.)

 

[k]

Thank you so much, I sure hope it isn't an experience like creating it was.
I had to create it from various sources of unrelated database tables, split
it into comprehensable tables, and it was a headache, so I just don't want to
go there with another headache. But you gave me hope, BE and FE, I will try
and see what I can do at the jmwild.com site. THANKS FOR SOME HOPE

 

[k]

Hi again, now will the BE FE help with letting say two people work on
database at same time? right now only one person can work in db at a time?

 

[Golfinray]

Yes, everyone can work at the same time. The BE will be on your server
(remember all users MUST have read/write/edit/delete priveledges for that
file AND the folder it resides in.) Load the FE on each users machine and you
are off and running! There is even a program out there by Tony Toews that
allows you to easily update the FE for all users. Your BE will contain all
your tables, so that users don't see those and can't mess with them. Your FE
contains your queries, forms, and reports for the users to use. Good luck! BE
SURE AND MAKE A BACKUP COPY FIRST!!!!!

 

[k]

You are the BEST. Okay so it IS POSITIVE, AND JUST MAYBE I WILL BE ABLE TO
FIGURE IT OUT without too much more hair pulling. As it is now all five have
access program on laptops and go to server network files to get into "my"
database. I guess I am confused about loading the FE on all the machines,
since they have access program already. Okay, first I should read the jm wild
instructions before I drive you nuts. That should let me know how to
accomplish this. You are terrific, it is a small db and I have a copy on my
desktop, but you wouldn't believe how much grief it caused me. THANKS SO
MUCH for giving me some hope.