TableDef.Connect 'type' issue

[wannabe geek]

Can anyone tell me the correct syntax for the TableDef.Connect property? I
want to connect to an external Access DB. ";Database=<path>" does not work. I
get an Error# 3078 saying:
The Microsoft Office Access database engine cannot find the input table or
query 'type'. Make sure it exists and that its name is spelled correctly.
However, putting something before the first ; creates Error# 3170 saying:
Could not find installable ISAM.

 

[Alex Dybenko]

Hi,
have a look at this code to relink tables:
http://www.mvps.org/access/tables/tbl0009.htm

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

 

[wannabe geek]

Hi,
have a look at this code to relink tables:
http://www.mvps.org/access/tables/tbl0009.htm

That is my (slightly modified) existing code. It does not work.

 

[Douglas J. Steele]

That is my (slightly modified) existing code. It does not work.

Let's see your modifications to the code...

 

[david]

That is my (slightly modified) existing code. It does not work.


Very old code now. From memory, yes, that is a problem
when the Dev Ashish code is used with modern versions of Access.

From memory, use "MS Access;Database" instead of ";Database",


(david)