Split Database Access 2007

[Jim Dudley]

I split my application pre-maturaly. I find now there are still several
changes and adjustments to tables and forms. Is there a simple way to
un-split an application?

Thank you

 

[John W. Vinson]

I split my application pre-maturaly. I find now there are still several
changes and adjustments to tables and forms. Is there a simple way to
un-split an application?

Thank you

You can reimport the tables. Open the frontend, and delete all the links in
the Tables window. Then use "External Data" to import the tables from the
backend.

 

[Douglas J. Steele]

There's no reason to unsplit it just to make changes.

Open the backend and make the table changes.

Open the frontend, refresh the links and make your form changes.

 

[De Jager]

I split my application pre-maturaly. I find now there are still several
changes and adjustments to tables and forms. Is there a simple way to
un-split an application?

Thank you

 

[Armen Stein]

Open the frontend, refresh the links and make your form changes.

And if you want a more automated approach to relinking tables, you're
welcome to use our free J Street Access Relinker on our J Street
Downloads page: http://ow.ly/M56Q

It handles multiple Access back-end databases, ignores ODBC linked
tables, and can automatically and silently relink to back-end
databases in the same folder as the application (handy for work
databases or single-user scenarios). There's a ReadMe table with
instructions.

Armen Stein
Microsoft Access MVP
www.JStreetTech.com