How to create a runtime Access 97 database

How to create a runtime Access 97 database. ?

Thanks in advance.
LVL 15
Who is Participating?
nico5038Connect With a Mentor Commented:
It should be possible, although you'll have to test your application extensively as I've ran already in trouble with A2000 .mdb's that ran OK under W98/W2000 but asked for parameters when closing a form under Windows XP (

Personally I don't like using the runtime version especially because the need for double testing and when an error arises you have an extra place to debug :-(

When you need a "license free" application it's better to use VB as frontend and Access as a backend database.
For accessing the data in Access you're able to use MDAC, not requiring an Access license.

You'll need the Developer edition of Office 97, but that's no longer sold by Microsoft.
So my best advise is to look in places like Ebay to get one.

rockiroadsConnect With a Mentor Commented:
what version Access do you currently have now, is it 97?

things to watch out for

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to and use offer code ‘EXPERTS’ to get 10% off your first purchase.

dork666Connect With a Mentor Commented:
you can solve the associations problem by giiving your app a different extension.
Arthur_WoodConnect With a Mentor Commented:
You do NOT create a Runtime database.  Access uses as its Datafile, either files with the MDB extension, or files with the MDE extenstion.  The difference being that files with the MDE extension have all of the VBA code, used internally, compiled, and all design 'artifacts' have been removed, so that the design of forms, reports and Code modules cannot be viewed, or changed.

What you may be refering to is answered by nico5038, and that is to make use of the Access Runtime engine, a version of the Access PROGRAM (the program that reads and executes the code and desing in the MDB/MDE) that DOES NOT require a license for the Full version of Access to be present.  The Runtime engine is only available as part of the Office Developers Edition.  The Access 97 Office developers' edition, as nico5038 explained, is no longer being sold either by Microsoft, or by any retail outlets, though, as nico also suggested, there MIGHT be copies available through eBay.  An Access 97 MDE file CANNOT be read by a newer version of the Access Runtime engine.

namasi_navaretnamAuthor Commented:
If i create access 97 runtime using developer version, will I be able to run this runtime version under winodws xp?

I agree with nico's assessment, though that does require that you be able to write code in Visual Basic.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.