Create an Access Database File

  • Thread starter Thread starter The Genie
  • Start date Start date
T

The Genie

Can anyone please tell me how I can create an Access Database in a specific
directory (not memory), presumably by using oledb.

Regards

Ian
 
* "The Genie said:
Can anyone please tell me how I can create an Access Database in a specific
directory (not memory), presumably by using oledb.
Click to expand...

This cannot be done with OLEDB, you will have to use ADOX.
 
Hi Genie,

set a reference to COM adox ext 2.x for dll and security
\\\
Dim catNewDB As New ADOX.Catalog
catNewDB.Create("Provider=Microsoft.Jet.OLEDB.4.0;" & "Data
Source=C:\db1.mdb")
///

I hope this helps a little bit?

Cor
 
Cor,
Thanks for the help.

Regards

Ian

Cor said:
Hi Genie,

set a reference to COM adox ext 2.x for dll and security
\\\
Dim catNewDB As New ADOX.Catalog
catNewDB.Create("Provider=Microsoft.Jet.OLEDB.4.0;" & "Data
Source=C:\db1.mdb")
///

I hope this helps a little bit?

Cor
Click to expand...
 
Back
Top