TableDef.Connect 'type' issue

W

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.
 
D

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)
 
Top