View Single Post
  #6  
Old February 8th, 2005, 09:10 PM
Sergey Poberezovskiy
external usenet poster
 
Posts: n/a
Default

Ed,

You have opened database correctly, but forgot to
initialize your ADOX.Catalog object - hence the error.

HTH
-----Original Message-----
From VB .Net, using either DAO or ADOX (or whatever else

is available), how
can I obtain a reference to a database file created in

Access? For example,
I tried the following:

Dim AccessApp As New

Microsoft.Office.Interop.Access.Application
AccessApp.OpenCurrentDatabase("C:\Documents and

Settings\...\filename.mdb")
Dim cat As ADOX.Catalog
cat.ActiveConnection = AccessApp.CurrentProject.Connection

The last statement gives me a "Object reference not set

to an instance of an
object" error.
--
Ed
.