Solved

Compiled State of Access 97 application

Posted on 1997-11-11
3
253 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
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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

Suggested Solutions

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

830 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