How to split access 2003 database - the whole nine yards

[Guest]

Hi,

I'm a systems/network admin that has very little experience with Access. I
have mulitple users that need to access an Access database at the same time.
While searching I came across "splitting the database". After researching
the topic, it sounded exactly like what I wanted. So, I printed out a couple
of articles from Microsoft and from a couple of fourums I found and figured I
had enough info to get the job done.

I connected to the database from my home computer to a network share at work
via a VPN. That is I opened up Access 2003 and open the database (let's call
it test). I make a backup of the original database (only about 4MB) and
proceed to split the database. Everything worked perfectly! The database
wizard asked for the original database and then made the backend,
test_be.mdb. Both are in the same shared network folder (lets call the
folder "database"). Now I have two files in the network shared database
folder. These files are test.mdb and test_be.mdb. Now I know the
test_be.mdb is the new backend to the database, but that is where I'm stuck.
What do you do next? How/where is the front end that every article keeps
talking about? I need someone to explain to me the "whole nine yards" of
splitting a database and getting the end users setup to access the split
database.

I found a couple of articles that referenced access developers toolkit to
make the frontend, but what is that and where do you get it. Or do I even
need that. I have a total of about 10 users spread across two cities that
need to access the test database. All of the end users have a copy of Access
2003 SP2 installed on their machines.

Thanks

Complete Access Newbie

 

[David F Cox]

The back end contains the data. The front end contains the means of
interacting with the data. The bit you open and use is the "front end".
You can just copy that to the other users and they will be able to interact
with the data in just the same way as you can, provided that they all see
the link path the same way.

If they do not link correctly to the back-end then someone will have to
invoke the linked table manager in their front ends and link to the
back-end..

 

[Guest]

Sorry for the mulitple posts. Browser window kept saying their was an error
submitting the post so I tried three more times before finally getting one to
post. But unknown to me, all of them made it.