Solved

Compiled State of Access 97 application

Posted on 1997-11-11
3
260 Views
Last Modified: 2012-08-13
Hi,

I am writing an Access 97 application. I need to distribute this application to some customers who will not have Access 97 installed. So they will use the runtime version of access (Developer's Edition). My Access application is made up of 4 mdb files and 1 mde file. Before creating the setup disks,
I Compile and Save All Modules. Access indicates then that the compile state on my machine is OK, meaning all is properly compiled.

When I install my application on other systems, the compile state is sometimes "compiled" and sometimes "uncompiled". I verified that all the references that I point to are OK and they are. I used the RefLibPath registry keyto make sure that Access finds the mde file no matter where it gets installed on the user's system.

Thanks for your help,
Ralph.
0
Comment
Question by:rakhras
[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
3 Comments
 
LVL 1

Expert Comment

by:arimsoft
ID: 1959308
You use is OCX in application?
You supre that you add all OCX in setup Wizard?
0
 

Author Comment

by:rakhras
ID: 1959309
yes, i use some OCXs in the application and they
are included in the setup wizard. any other ideas?
0
 
LVL 9

Accepted Solution

by:
perove earned 50 total points
ID: 1959310
Ralph,
I had the same problem and what I did for a solution was to import the whole progarm MDB into a new "clean" MDB. Then compile and save this mdb and NOT TOUCING in again.
Then make a MDE of this file. NOt the MDB you have been developing on. I also included a Runcmd CompileAndSaveAllModules on startup/logoff of the application, this also helps and right now the state of the MDE is always compiled.
I dont know it this is a bug or if this is how MS intend that the Access sholuld be used but it did the trick for me anyway.

Tia,
Per Ove
Bergen,Norway

0

Featured Post

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

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

Suggested Solutions

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…
It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

740 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