M
Maury Markowitz
Not having much luck today, it seems...
In my quest to find an efficient way to import data from various sources to
our sql server, I'm currently trying to experiment with an mdb full of the
links and then opening them in code in my main adp program. However, I keep
getting...
Run-time error '3343'" Unrecognized database format...
And this happens no matter what mdb I try to open...
Dim db As DAO.Database
'Set db = OpenDatabase("L:\Reconciliation.mdb", False, True)
'Set db = OpenDatabase("L:\Sandbox")
etc. All of these db's open fine in access. Soooo, can I use DAO in code in
an adp? I seem to recall having done this before.
Maury
In my quest to find an efficient way to import data from various sources to
our sql server, I'm currently trying to experiment with an mdb full of the
links and then opening them in code in my main adp program. However, I keep
getting...
Run-time error '3343'" Unrecognized database format...
And this happens no matter what mdb I try to open...
Dim db As DAO.Database
'Set db = OpenDatabase("L:\Reconciliation.mdb", False, True)
'Set db = OpenDatabase("L:\Sandbox")
etc. All of these db's open fine in access. Soooo, can I use DAO in code in
an adp? I seem to recall having done this before.
Maury