Linking / De-Linking Tables

[sgjmail]

Dear All MS Access-GURUS,

I have developed a system which caters to the inventory mngt
I have used MS Access 2003 to develope this system.
for e.g. my ms access system file is say XYZ.mdb

To make the XYZ.mdb multiuser, I have splitted master database (XYZ.mdb) and created back-end database on another computer say CT-01. System has successfully splitted master database XYZ.mdb and created back-end on CT-01

The master database which is splitted (XYZ.mdb) kept on CT-02, CT-03 and linked with back-end database with linked table manager. System is running very smoothly....no problem at alll.

Now, My question is suppose I want to use XYZ.mdb in its original phase, i.e. un-splitted form and use it on standalone machine, can I do it ?

I will re-pharse my question, can I merge splitted database in to its original state i.e. un-splitted ?

waiting for the reply...

b rgds
sunil joshi
+91-022-23895866
+91-022-67967415
09930580082

[Megalog]

Now, My question is suppose I want to use XYZ.mdb in its original phase, i.e. un-splitted form and use it on standalone machine, can I do it ?

I will re-pharse my question, can I merge splitted database in to its original state i.e. un-splitted ?

There isnt any 'merge' function, as far as I know. But you can simply go into the Front End MDB, delete all the table Links, and then Import all the tables from the backend. They'd have the same names as the links, so it should all work fine after that as a standalone db.

[mshmyob]

Megalog is correct there is no 'Merge' function built into Access.

I would suggest that you always keep your Access databases split into a FE/BE even on stand alone systems. The FE/BE configuration works better than a combined system. Combined tables/interface in Access has a tendency to get corrupted quite easily.

cheers,