Database Property MDB vs MDE

[Tony_VBACoder]

With Access 2002/VBA, how can I determine if my database
is an MDB or MDE? I need to have an IF-THEN statement in
my initialization routine depending on whether my database
is in an MDE or MDB format.

 

[Chris Nebinger]

The first thing I thought of was to check the last letter
of the database name:


If UCASE(Right(currentdb.name,1)) = "E" then
'.mde
Else
'.mdb
End if


Chris Nebinger

 

[Tony_VBACoder]

I found this great article on the MS KB:

http://support.microsoft.com/?kbid=304251