Database Property MDB vs MDE

T

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

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
 
Top