Solved

How to create a runtime Access 97 database

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

Thanks in advance.
0
Comment
Question by:namasi_navaretnam
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
7 Comments
 
LVL 54

Expert Comment

by:nico5038
ID: 10787466
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
ID: 10787497
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
ID: 10788005
you can solve the associations problem by giiving your app a different extension.
0
Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

 
LVL 44

Assisted Solution

by:Arthur_Wood
Arthur_Wood earned 175 total points
ID: 10788895
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
ID: 10789486
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
ID: 10789759
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
ID: 10790297
I agree with nico's assessment, though that does require that you be able to write code in Visual Basic.

AW
0

Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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…
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
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…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

735 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