Linked tables with no associated tables in backend

's Computer Specifications

I have cases where the front end show a table as linked, but there is no
associated table in the backend. (evidently, i removed the table from
backend but did not remove it from the frontend.). Is there a routine that
checks for such cases?

's Computer Specifications

Try opening the front end.

"jsccorps" wrote:

> I have cases where the front end show a table as linked, but there is no
> associated table in the backend. (evidently, i removed the table from
> backend but did not remove it from the frontend.). Is there a routine that
> checks for such cases?

's Computer Specifications

air code

dim db as dao.database
dim tdf as dao.tabledef

set db = codedb.
for each tdf in db.tabldefs.
if tdf.connect <> "" then
tdf.RefreshLink
endif
next tdf

(david)

"KARL DEWEY" <(E-Mail Removed)> wrote in message
news:664F8C65-3D90-4CCC-9CBB-(E-Mail Removed)...
> Try opening the front end.
>
> "jsccorps" wrote:
>
> > I have cases where the front end show a table as linked, but there is no
> > associated table in the backend. (evidently, i removed the table from
> > backend but did not remove it from the frontend.). Is there a routine
that
> > checks for such cases?

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Re: How To Duplicate Table From 1 Backend Database To Another Backend Database	John W. Vinson	Microsoft Access VBA Modules	0	30th Jun 2009 06:01 PM
Manipulating backend linked tables	John	Microsoft Access	2	4th Apr 2009 11:08 PM
Simple task works when MS SQL Server is the backend but not when MySQL is the backend.	Ted	Microsoft ASP .NET	1	22nd Feb 2007 09:33 PM
Access backend vs mysql backend	=?Utf-8?B?RGFu?=	Microsoft Access	0	1st Jun 2005 12:46 AM
Copying table in Backend to another Backend	=?Utf-8?B?cmRoMWE=?=	Microsoft Access Form Coding	3	16th Dec 2004 06:25 PM