one database, several access interfaces

[mikeder]

Hi,

I have a simple question I think. Is it possible to have one MS Access database stored on the server and allow multiple MS Access front ends on different computers accessing that data?

How does one go about doing this so that multiple people can access the same database on different computers?

Thanks

 

[mission2java_78]

Back end sits on some central storage area (shared).
Front end distributed to each client. Back end links back to front end.

Jon

 

[mikeder]

yes but...

thanks for the reply. It makes a lot of sense but i don't know how to separate my current db into front end back end.

Currently my DB has many objects (Tables, Queries, Forms etc...) how do i chop it up so that only data is on the back end and the forms and switchboard are on the front end?

 

[mission2java_78]

Re: yes but...

Create a new mdb. Right click on the db window. Select Import tables. Select your old .mdb that has both tables and forms...make sure you select the tables tab. Select the tables from your db. Click ok.

Once that is complete you have tables in one mdb and your other mdb. Go back to your other mdb...delete the tables. Right click on the db window. Select link tables. Select all your tables from that new mdb you had made. You will notice your tables now have arrows next to them so they are linked.

MAKE SURE YOU BACKUP BEFORE ALL OF THIS.

Jon

 

[Autoeng]

There is a splitter wizard. All of your tables (data) goes to the backend and all of your forms / queries / ect stay in the front end.

Autoeng

 

[mission2java_78]

Why would anyone need a splitter wizard?

 

[Autoeng]

So you don't have to create the backend db, import the tables and establish the links manually.

Autoeng

 

[mission2java_78]

Ya but creating the back end is so simple...its almost harder to use the splitter.

Jon

 

[Autoeng]

I never said it was easier just that it existed.

Autoeng

 

[jetson]

Actually, the splitter wizard is much easier. It's one click, then choose the location for the backend.

 

[mission2java_78]

*shrug* dont be lazy ...splitting a db is simple.

Jon

 

[jetson]

sorry!

if you're naturally lazy, you just can't help yourself!