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

Advertisements

D

Douglas J. Steele

wannabe geek said:
That is my (slightly modified) existing code. It does not work.
Let's see your modifications to the code...
 
Ad

Advertisements

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top