View Full Version : Linking Back end to Front end once Database is split


a_20120
04-09-2007, 11:31 PM
The back end of the databse resides on a server while the front ends are on the client pc`s.

1. What code do I use to ensure the Front end sees the back end and where do I put the code?

2. Also maybe the client users change the path of the Front End Db, What code do I use to ensure the Front end sees the back end and where do I put the code??

Oldsoftboss
04-10-2007, 12:59 AM
Have you ever used the search function?

http://www.access-programmers.co.uk/forums/showthread.php?t=64270

a_20120
04-10-2007, 01:49 AM
Thanks for replying
Yes, I did but could not fine the thread help me, I will try urs...thanks anyway

Could u plz tell me how backup just the tables not all the objects?

Oldsoftboss
04-10-2007, 12:51 PM
Could u plz tell me how backup just the tables not all the objects?

Once you have split the Db, the back end will only contain the tables, and that is what you will need to back up.

If your pc crashes, you should have a copy of the front end somewhere (even an older version) that can be used.

a_20120
04-15-2007, 02:01 AM
Thnx Mr. OldSoftBoss
I used the link that u mentioned in above and it works well after trying