Preveting users to access from others versions of access

[Rodolfo Fontes]

Hi group,

I use a database on Access 2000, is there anyway to prevent users from
opening it from Access 2002 or above versions?
With that i wanna prevent the error message: "this database has been opened
on a above version of access....."

is there anyway to do that?

Thanks,
Rodolfo Fontes

 

[John Vinson]

Hi group,

I use a database on Access 2000, is there anyway to prevent users from
opening it from Access 2002 or above versions?
With that i wanna prevent the error message: "this database has been opened
on a above version of access....."

is there anyway to do that?

Thanks,
Rodolfo Fontes

Access 2002 and 2003 can use A2000 format without converting it; in
fact, that's the default format. So unless a user *intentionally* uses
Tools... Convert to "upgrade" the database this should not be an
issue!

There's no way to prevent this in a .mdb file; however, you may want
to create a .mde file (which has no design mode and cannot, AFAIK, be
converted) and distribute it to users.

If you have not already done so, you should also strongly consider
using the Database Splitter to split the database into a backend (in
2000 format, on a server) which the users will link to but never open
directly. Each user would have their own copy of the frontend, and can
convert it to 2003 or whatever, without interfering with anyone else's
copy.

John W. Vinson[MVP]