Splitting a database

[Bee]

Hi,

I have been searching for more info on this and found out quite a lot about it; however, I am still wondering how to connect the front ends that will be in different machines to the back end that resides on server.

I know that when you split a database, the wizard asks where to save the first front end. But how about if you have many?

Any help will be very much appreciated.

B

 

[genghis82]

if you save the front end on the server as well. then you can copy and paste it on to the required desktops. The linked tables in your front end should point to the tables in the backend so this shouldn't be a problem.

Alternatively you can put a copy of the database on each terminal and then delete all the tables and go to [file] [get external data] [link tables] and select the db and the tables of interest.

HTH

 

[Bee]

if you save the front end on the server as well. then you can copy and paste it on to the required desktops. The linked tables in your front end should point to the tables in the backend so this shouldn't be a problem.

Alternatively you can put a copy of the database on each terminal and then delete all the tables and go to [file] [get external data] [link tables] and select the db and the tables of interest.

HTH

Great, thank you very much.

 

[Bee]

if you save the front end on the server as well. then you can copy and paste it on to the required desktops. The linked tables in your front end should point to the tables in the backend so this shouldn't be a problem.

Alternatively you can put a copy of the database on each terminal and then delete all the tables and go to [file] [get external data] [link tables] and select the db and the tables of interest.

HTH

Great, thank you very much.