Database Splitting 3

[skin76]

This is my first try at splitting up my database. My question is once I split it how do I relink the two? What I have done thus far I made two copies I renamed one back-end and I put the tables in that one, the other I named front-end and I left the queries-forms-report ect. in that one--now I'm stumped from this point on relinking.

Also do I put the back-end on the server and put the front-end on each work station or can the front-end be on the server as well and let them access the front-end from a shortcut from the server on their desktop(that's how they are accessing the database now and would like to keep them doing it that way.

Thanks in advance

 

[BNPMike]

I'm not sure there's much point in splitting your database if you then put both bits on the same server. It may only slow your application a very small amount, but why do it at all?

I would counsel you that a lot of Access tuning stuff hails from a previous era - often mid-to-late 90s. Workstations, networks, drives and servers are many, many times faster nowadays so the balance has probably changed.

 

[Ed2020]

Splitting the database allows you to work on the development copy of the frontend and then just release the frontend and relink the tables from the live backend. It saves transferring data from the live environment to the new version when implementing changes.

Mike's right to say that the benefits decrease if you put the frontend and the backend on the server. My preferred method is to place the backend on the server and give each user a copy of the frontend on their local drive. This means you have to implement a version control system to ensure users are always using the latest version of the frontend, but it decreases network traffic as all forms/reports/code etc. are pulled from the local drive.

Ed Metcalfe.

Please do not feed the trolls.....

 

[KenReay]

Hi

To answer your question about linking the tables...

Open the Front End, choose File\Get External Data\Link from the menu, navigate to the backend and follow the instructions.

You may want to consider having code which checks for broken links on start up and automatically initiates a relink dialog

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[Ed2020]

Ah yes, sorry - I'd forgotten to actually answer the question.

Ed.

Please do not feed the trolls.....

 

[skin76]

Could you please advise me on the code I would use to check for broken links on start up and initates a relink dialog

 

[PHV]

Take a look here:

http://www.peterssoftware.com/tlk.htm

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244