connecting an Access .MDB and a .MDW file to VB

[michelle]

Dear VB users,

Is it possible to connect an Access .MDB and a .MDW file to VB? Can someone give me source how to do this?
There is no Access (run time available).

Nice regards,

Michelle.

[Ecniv]

Its been posted about several times.

DAO
You need to set the SystemDB properties BEFORE opening workspace(s)/database(s) on it

ADO
Normal connection string, but extra information as to which mdw to use and th edefault user name and password.


Have a search (top right) for the other posts.

Vince

[Ecniv]

from the able consulting link below
oConn.Open "Driver={Microsoft Access Driver (*.mdb)};" & _
"Dbq=c:\somepath\mydb.mdb;" & _
"SystemDB=c:\somepath\mydb.mdw;", _
"myUsername", "myPassword"

Vince

[WiseGuy]

I'm not a real expert, but I always like to respond to someone from the same country

You don't need acces installed to get an Acces DB running but it's a lot easier if it is installed.

Here's a program that comes from an other forum and it should be capable of connecting to an acces DB without having Acces installed.

Maybe this 'll help you get started


Mazzels,


WiseGuy

[vaibhav12]

I think no need of access to be installed.