OLEDBConnection

[David A. Osborn]

Is there a way to make the OLEDBConnection to my Access file relative to the
path of the executable of the file? I work on the program on a lot of
different computers and I am tired of having to copy things around so that
the Access file is in the right path.

[David A. Osborn]

As a follow up, is there then a safe way to change what ever I need to
change so that my data adapter, dataset and data bindings don't get
completely screwed up.
"David A. Osborn" <do********@hot mail.com> wrote in message
news:EbNGe.2002 64$_o.72720@att bi_s71...

Is there a way to make the OLEDBConnection to my Access file relative to
the path of the executable of the file? I work on the program on a lot of
different computers and I am tired of having to copy things around so that
the Access file is in the right path.

[Chris]

David A. Osborn wrote:

Is there a way to make the OLEDBConnection to my Access file relative to the
path of the executable of the file? I work on the program on a lot of
different computers and I am tired of having to copy things around so that
the Access file is in the right path.

For standard security

oConn.Open "Provider=Micro soft.Jet.OLEDB. 4.0;" & _
"Data Source=c:\somep ath\myDb.mdb;"

If using a Workgroup (System Database)

oConn.Open "Provider=Micro soft.Jet.OLEDB. 4.0;" & _
"Data Source=" & Application.Sta rtup & "\somepath\mydb .mdb;"
& _
"Jet OLEDB:System Database=MySyst em.mdw", _
"myUsername ", "myPassword "

Note, remember to convert both the MDB and the MDW to the 4.0
database format when using the 4.0 OLE DB Provider.
If MDB has a database password

oConn.Open "Provider=Micro soft.Jet.OLEDB. 4.0;" & _
"Data Source=" & Application.Sta rtup & "\somepath\mydb .mdb;"
& _
"Jet OLEDB:Database Password=MyDbPa ssword", _
"myUsername ", "myPassword "
If want to open up the MDB exclusively

oConn.Mode = adModeShareExcl usive
oConn.Open "Provider=Micro soft.Jet.OLEDB. 4.0;" & _
"Data Source=" & Application.Sta rtup & "\somepath\mydb .mdb;"

[Dennis]

I was confused by your comment;
"Note, remember to convert both the MDB and the MDW to the 4.0
database format when using the 4.0 OLE DB Provider"
I use an Access Database (.mdb extension) but was not aware of the mdw
extension nor the nead to convert to anything. I also use the 4.0 OLE DB
Provider and haven't had to convert anything.

Could you explain a bit more...thanks for you comments.
--
Dennis in Houston
"Chris" wrote:

David A. Osborn wrote:

Is there a way to make the OLEDBConnection to my Access file relative to the
path of the executable of the file? I work on the program on a lot of
different computers and I am tired of having to copy things around so that
the Access file is in the right path.

For standard security

oConn.Open "Provider=Micro soft.Jet.OLEDB. 4.0;" & _
"Data Source=c:\somep ath\myDb.mdb;"

If using a Workgroup (System Database)

oConn.Open "Provider=Micro soft.Jet.OLEDB. 4.0;" & _
"Data Source=" & Application.Sta rtup & "\somepath\mydb .mdb;"
& _
"Jet OLEDB:System Database=MySyst em.mdw", _
"myUsername ", "myPassword "

Note, remember to convert both the MDB and the MDW to the 4.0
database format when using the 4.0 OLE DB Provider.
If MDB has a database password

oConn.Open "Provider=Micro soft.Jet.OLEDB. 4.0;" & _
"Data Source=" & Application.Sta rtup & "\somepath\mydb .mdb;"
& _
"Jet OLEDB:Database Password=MyDbPa ssword", _
"myUsername ", "myPassword "
If want to open up the MDB exclusively

oConn.Mode = adModeShareExcl usive
oConn.Open "Provider=Micro soft.Jet.OLEDB. 4.0;" & _
"Data Source=" & Application.Sta rtup & "\somepath\mydb .mdb;"

[Cor Ligthert [MVP]]

David,

Probably you use a dragged connection.

Than just set the connection in by instance the form load of your program,
however before the open of the connection.

Don't delete the dragged connection from the designer part, because that can
give you all kind of trouble.

Connection1 = New Connection(And than the connection string you want)

That string you can save in an XML or Ini or whatever file.

I hope this helps,

Cor

[Paul Clement]

On Sat, 30 Jul 2005 15:40:20 GMT, "David A. Osborn" <do********@hot mail.com> wrote:

¤ Is there a way to make the OLEDBConnection to my Access file relative to the
¤ path of the executable of the file? I work on the program on a lot of
¤ different computers and I am tired of having to copy things around so that
¤ the Access file is in the right path.
¤
¤

There are a few ways to fetch the application path one of which is Application.Sta rtupPath.
Paul
~~~~
Microsoft MVP (Visual Basic)