Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to find name of mdb file? 1

Status
Not open for further replies.
hstijnen

hstijnen

Programmer
Nov 13, 2002
172
NL
Hi,

How can I find in VBA for Access the name of the .mdb file I'm working in?

Thanks

Henk
 
Sort by date Sort by votes
Or use currentproject.name (no need to strip of the path)

Roy-Vidar
 
Upvote 0 Downvote
This may also be helpful in other cases to find the back end name:

dim strPathAndFile
strPathAndFile = CurrentDb.TableDefs(mLinkedTableName).Connect
strPathAndFile = Mid(strPathAndFile, 11)

where mLinkedTableName is the name of a linked table
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

renigar
  • Locked
  • Question
Code to write file path to field always writes to 1st record 1
Replies
5
Views
244
dhookom
dhookom
Moss100
  • Locked
  • Question
Find error in currency feild 2
Replies
8
Views
515
Andrzejek
Andrzejek
M
  • Question
display a calendar with appointments in body of html email with access vba
Replies
1
Views
378
SoftwareRT
SoftwareRT
btamsgn
  • Locked
  • Question
How to edit column chitoi into TableA
Replies
0
Views
85
btamsgn
btamsgn
Moss100
  • Locked
  • Question
Remove everything including the comma from the last comma of a string. 1
Replies
10
Views
339
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top