C
chemexchange
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
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