Checking if MDB or MDE on startup

  • Thread starter Thread starter Richard Krupa
  • Start date Start date
R

Richard Krupa

Hey guys,

Does anyone know of a way i can check that the access file in use is an mde
or mdb? i have some code that i wanted executed for example disbale the
shift bypass only on the mde. (obviously dont want to lock myself out of the
mdb!) At present i'm using a hidden flag to set if i want to disable some of
these options.
 
Richard said:
Does anyone know of a way i can check that the access file in use is an mde
or mdb? i have some code that i wanted executed for example disbale the
shift bypass only on the mde. (obviously dont want to lock myself out of the
mdb!) At present i'm using a hidden flag to set if i want to disable some of
these options.
Click to expand...

Does SysCmd(acSysCmdRuntime) do what you want?
 
no, that just tells me if its the runtime version of access running. alot of
the sites have the full version of access installed because they use access
for other things. I need to test if its the mde (which is what we give to
clients) or the mdb (which is what we use to develop) running

Regards,
Richard
 
But that won't work if someone renames their MDE to MDB!

The correct andser is:

If currentdb.properties![MDE] = "T" then
' it is an MDE file.
endif

You may need to include an error trap for the case where that property does
not exist (ie. in an MDB).

HTH,
TC
 
Could you not just take the right 3 characters of;
Application.CurrentDb.Name



Richard Krupa said:
no, that just tells me if its the runtime version of access running. alot of
the sites have the full version of access installed because they use access
for other things. I need to test if its the mde (which is what we give to
clients) or the mdb (which is what we use to develop) running

Regards,
Richard

of
the
Click to expand...
some
Click to expand...
 
oh dur! Thanks Ruskin i was looking for a complicated solution and was not
even looking for the obvious simple answer

Regards,
Richard

Ruskin Hardie said:
Could you not just take the right 3 characters of;
Application.CurrentDb.Name



Richard Krupa said:
no, that just tells me if its the runtime version of access running.
Click to expand...
alot
Click to expand...
 
cheers guys :) much appreciated

Regards,
Richard

TC said:
But that won't work if someone renames their MDE to MDB!

The correct andser is:

If currentdb.properties![MDE] = "T" then
' it is an MDE file.
endif

You may need to include an error trap for the case where that property does
not exist (ie. in an MDB).

HTH,
TC


Richard Krupa said:
oh dur! Thanks Ruskin i was looking for a complicated solution and was not
even looking for the obvious simple answer

Regards,
Richard

give
to is disbale
the
Click to expand...
Click to expand...
 
Back
Top