Need to get database path

[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

 

[MikeB]

CurrentDb.Name returns the full pathname of the database.

 

[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.

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