Access Format

[Jimbo]

Is there a way to make an access db only open in say access 2002 and
up?

['69 Camaro]

Hi.

Is there a way to make an access db only open in say access 2002 and
up?

Yes. Create an MDB file in Access 2002 database format, and then create an
MDE file from it in Access 2002. Only Access 2002, 2003 and 2007 will be
able to open the database file. Earlier versions of Access will get an
error, "Unrecognized database format," when trying to open the file.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.

[Tom van Stiphout]

On Wed, 12 Sep 2007 22:06:04 GMT, "'69 Camaro"
<Fo**************************@Spameater.orgZERO_SP AMwrote:

Another way is to check the version of Access (better: Jet):
if dbengine.version <= 10 then
msgbox "No way!
end
end if

-Tom.

>Hi.

>Is there a way to make an access db only open in say access 2002 and
up?

Yes. Create an MDB file in Access 2002 database format, and then create an
MDE file from it in Access 2002. Only Access 2002, 2003 and 2007 will be
able to open the database file. Earlier versions of Access will get an
error, "Unrecognized database format," when trying to open the file.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.