Need to get database path

  • Thread starter Thread starter Kevin Seitz
  • Start date Start date
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
 
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
 
Back
Top