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 derfloh 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
Joined
Nov 13, 2002
Messages
172
Location
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
currentdb.name

Have fun! :o)

Alex Middleton
 
Upvote 0 Downvote
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

Knicks
  • Question Question
Nested Column (Excel, CSV) : How to extract just the metadata or column names within a column of data
Replies
2
Views
156
Andrzejek
Andrzejek
hermanlaksko
  • Locked
  • Question Question
Convert PDF file to text
Replies
6
Views
924
hermanlaksko
hermanlaksko
Moss100
  • Locked
  • Question Question
Find unique rent amount and date this was first charged
Replies
4
Views
1K
dhookom
dhookom
renigar
  • Locked
  • Question Question
Code to write file path to field always writes to 1st record
Replies
5
Views
1K
dhookom
dhookom
breezett93
  • Locked
  • Question Question
Converting from 32bit to 64 bit. After converting, database takes significantly longer to open
Replies
14
Views
3K
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top