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.

--
Regards,
Richard

Richard Krupa wrote:

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

Does SysCmd(acSysCmdRuntime) do what you want?

--
Marsh
MVP [MS Access]

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

"Marshall Barton" <(E-Mail Removed)> wrote in message
news(E-Mail Removed)...
> Richard Krupa wrote:
>
> >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.
>
> Does SysCmd(acSysCmdRuntime) do what you want?
>
> --
> Marsh
> MVP [MS Access]

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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:u6mib.176615$(E-Mail Removed)...
> > Could you not just take the right 3 characters of;
> > Application.CurrentDb.Name
> >
> >
> >
> > "Richard Krupa" <(E-Mail Removed)> wrote in message
> > news:%(E-Mail Removed)...
> > > 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
> > >
> > > "Marshall Barton" <(E-Mail Removed)> wrote in message
> > > news(E-Mail Removed)...
> > > > Richard Krupa wrote:
> > > >
> > > > >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.
> > > >
> > > > Does SysCmd(acSysCmdRuntime) do what you want?
> > > >
> > > > --
> > > > Marsh
> > > > MVP [MS Access]
> > >
> > >
> >
> >
>
>

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



"Richard Krupa" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> 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
>
> "Marshall Barton" <(E-Mail Removed)> wrote in message
> news(E-Mail Removed)...
> > Richard Krupa wrote:
> >
> > >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.
> >
> > Does SysCmd(acSysCmdRuntime) do what you want?
> >
> > --
> > Marsh
> > MVP [MS Access]
>
>

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" <(E-Mail Removed)> wrote in message
news:u6mib.176615$(E-Mail Removed)...
> Could you not just take the right 3 characters of;
> Application.CurrentDb.Name
>
>
>
> "Richard Krupa" <(E-Mail Removed)> wrote in message
> news:%(E-Mail Removed)...
> > 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
> >
> > "Marshall Barton" <(E-Mail Removed)> wrote in message
> > news(E-Mail Removed)...
> > > Richard Krupa wrote:
> > >
> > > >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.
> > >
> > > Does SysCmd(acSysCmdRuntime) do what you want?
> > >
> > > --
> > > Marsh
> > > MVP [MS Access]
> >
> >
>
>

cheers guys much appreciated

Regards,
Richard

"TC" <(E-Mail Removed)> wrote in message news:1066011190.582912@teuthos...
> 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" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > 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" <(E-Mail Removed)> wrote in message
> > news:u6mib.176615$(E-Mail Removed)...
> > > Could you not just take the right 3 characters of;
> > > Application.CurrentDb.Name
> > >
> > >
> > >
> > > "Richard Krupa" <(E-Mail Removed)> wrote in message
> > > news:%(E-Mail Removed)...
> > > > 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
> > > >
> > > > "Marshall Barton" <(E-Mail Removed)> wrote in message
> > > > news(E-Mail Removed)...
> > > > > Richard Krupa wrote:
> > > > >
> > > > > >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.
> > > > >
> > > > > Does SysCmd(acSysCmdRuntime) do what you want?
> > > > >
> > > > > --
> > > > > Marsh
> > > > > MVP [MS Access]
> > > >
> > > >
> > >
> > >
> >
> >
>
>