How do I unlink linked tables in Access 2007 to save as a backup?

's Computer Specifications

's Computer Specifications

On Mon, 13 Apr 2009 06:43:01 -0700, buffis
<(E-Mail Removed)> wrote:

There is no need to unlink before making a backup.

But if you must, you can manually delete the linked tables from the
FE, or write some VBA code to do the same (loop over Tabledefs
collection, check if attached table, delete).

-Tom.
Microsoft Access MVP

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Access 2007 Linked Tables	kellya	General Software	0	13th May 2010 05:41 PM
Linked tables Access 2007	Marsh	Microsoft Access External Data	9	18th Nov 2009 05:30 PM
Access 2007 and Linked Tables	Peter	Microsoft Access	0	26th Oct 2009 08:22 PM
See Linked Tables in Access 2007	cbjames	Microsoft Access	2	16th Aug 2009 02:04 PM
Code to delete/unlink Linked tables	LisaB	Microsoft Access VBA Modules	2	9th Sep 2004 09:41 PM