Database Property MDB vs MDE

  • Thread starter Thread starter Tony_VBACoder
  • Start date Start date
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.
 
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
 
Back
Top