relinking tables in access 2k via code?

[SirPoonga]

http://www.mvps.org/access/tables/tbl0009.htm

I get the error User-defined type not defined on line
Function fIsRemoteTable(dbRemote As DATABASE, strTbl As String) As
Boolean

What is DATABASE?

 

[SirPoonga]

figured that out, had to reference DAO.

Now, where is
ahtAddFilterItem()

 

[Immanuel Sibero]

Did you copy all the following:

http://www.mvps.org/access/api/api0001.htm

to your vba module?


Immanuel Sibero

 

[SirPoonga]

Doh, didn;t see that note there. Yep, work now

 

[Immanuel Sibero]

Have fun!

Immanuel Sibero

 

[SirPoonga]

I did have to modify the code. I have a couple of smaller database (if
1/3gig is considered smaller) where the tables are links to a main
table. This way only portions of the db can be updated in a more
timely fashion. Example is one DB is for Bill of Materials info, one
is for Master parts list info, one is for Vendors, etc...

I added in code that asked if the tables are in databases of the same
name in the same folder as the main database. Then modified the code
to assume same name DB in the currentproject path.