Checking if MDB or MDE on startup
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.
You may need to include an error trap for the case where that property does
not exist (ie. in an MDB).
> oh dur! Thanks Ruskin i was looking for a complicated solution and was not
> even looking for the obvious simple answer
> > Could you not just take the right 3 characters of;
> > Application.CurrentDb.Name
> > > no, that just tells me if its the runtime version of access running.
> > 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
> > > clients) or the mdb (which is what we use to develop) running
> > > Regards,
> > > Richard
> > > > >Does anyone know of a way i can check that the access file in use
> > > mde
> > > > >or mdb? i have some code that i wanted executed for example disbale
> > > > >shift bypass only on the mde. (obviously dont want to lock myself
> > of
> > > the
> > > > >mdb!) At present i'm using a hidden flag to set if i want to
> > some
> > > of
> > > > >these options.
> > > > Does SysCmd(acSysCmdRuntime) do what you want?
> > > > --
> > > > Marsh
> > > > MVP [MS Access]