Need to get database path

K

Kevin Seitz

How can I get the database path through visual basic and have it show up in
a form? Mostly, I just need the code that accesses the path.

Thanks in advance
-Kevin
 
J

Jim Allensworth

How can I get the database path through visual basic and have it show up in
a form? Mostly, I just need the code that accesses the path.
Click to expand...
This should do what you want. Just substitute one of your linked
tables for "tblCustomers"

Right([CurrentDb].[TableDefs]("tblCustomers").[Connect],Len([CurrentDb].[TableDefs]("tblCustomers").[Connect])-10)

Set a textbox's control source to = it.

- Jim
 
Top