Solved

How to create a runtime Access 97 database

Posted on 2004-04-08
7
3,487 Views
Last Modified: 2007-12-19
How to create a runtime Access 97 database. ?

Thanks in advance.
0
Comment
Question by:namasi_navaretnam
7 Comments
 
LVL 54

Expert Comment

by:nico5038
Comment Utility
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.

Nic;o)
0
 
LVL 65

Assisted Solution

by:rockiroads
rockiroads earned 50 total points
Comment Utility
what version Access do you currently have now, is it 97?

things to watch out for

http://www.granite.ab.ca/access/runtime.htm

0
 

Assisted Solution

by:dork666
dork666 earned 25 total points
Comment Utility
you can solve the associations problem by giiving your app a different extension.
0
What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

 
LVL 44

Assisted Solution

by:Arthur_Wood
Arthur_Wood earned 175 total points
Comment Utility
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.

AW
0
 
LVL 15

Author Comment

by:namasi_navaretnam
Comment Utility
If i create access 97 runtime using developer version, will I be able to run this runtime version under winodws xp?

Thanks.
0
 
LVL 54

Accepted Solution

by:
nico5038 earned 250 total points
Comment Utility
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 (http://www.experts-exchange.com/Databases/MS_Access/Q_20662877.html)

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.

Nic;o)
0
 
LVL 44

Expert Comment

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

AW
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now