I have an mde that accesses a back end mdb. Using VBA...how can I determine
the network drive letter of that back end database?

"PieterLinden via AccessMonster.com" <u49887@uwe> wrote in message
news:a8a63debe2090@uwe...
> ambushsinger wrote:
>>I have an mde that accesses a back end mdb. Using VBA...how can I
>>determine
>>the network drive letter of that back end database?
>
> depends on how it's mapped.... you should be able to take just the
> leftmost
> character of the Connect property of an attached tabledef
>
> Left$(DBEngine(0)(0).Tabledefs("tdfAttached").Connect,1)

It won't be the 1st character of the Connect property, because for an Access
back-end that will begin with ";DATABASE=". Use

Mid$(DBEngine(0)(0).Tabledefs("tdfAttached").Connect, 11, 1)

--
Dirk Goldgar, MS Access MVP
Access tips: www.datagnostics.com/tips.html

(please reply to the newsgroup)