HELP......Runtime Problems

[Guest]

I hope I can explain this so it is easy to understand.

1. I developed an Access 2000 application using a Front End and Back End
database.

2. I followed all the steps required to secure the application.

3. I complied both databases (FE & BE) to make .mde files

4. I have a runtime version of Access of 2000 that I will use with the
deployment the application.

5. I tested the deployment of the application, but ran into problems that I
will describe below.

6. I deployed the test application as follows:

- Copied the application databases to the test computer that does not have
MS Access installed on it.

- Installed the Access 2000 Runtime.

7. Here is the problem that I encountered.

- When I tried opening any form or report that has a record source that
contains an expression, I receive an error that states that the function is
not available for the expression.

Am I doing something wrong?
Is there a fix to this problem?
Does anyone have any suggestions?

Thanks in advance!

Dwight

 

[Guest]

Hi Dwight,

Try placing your expression in a new public function, in a module. Then call
your function from the query.

On #3 below, there is no real benefit to converting a BE database into a
..mde file.

Tom
___________________________________________

:

I hope I can explain this so it is easy to understand.

1. I developed an Access 2000 application using a Front End and Back End
database.

2. I followed all the steps required to secure the application.

3. I complied both databases (FE & BE) to make .mde files

4. I have a runtime version of Access of 2000 that I will use with the
deployment the application.

5. I tested the deployment of the application, but ran into problems that I
will describe below.

6. I deployed the test application as follows:

- Copied the application databases to the test computer that does not have
MS Access installed on it.

- Installed the Access 2000 Runtime.

7. Here is the problem that I encountered.

- When I tried opening any form or report that has a record source that
contains an expression, I receive an error that states that the function is
not available for the expression.

Am I doing something wrong?
Is there a fix to this problem?
Does anyone have any suggestions?

Thanks in advance!

Dwight

 

[Guest]

Thanks! I will try it but I have not written a function of this nature or I
am not completly understanding.

Here is an example of my expression:
Signed: [Header]![Rank] & " " & [Header]![FullName] & "/"

How would I write a function for that?

Dwight

 

[Guest]

Hi Dwight,

Your expression is just a simple concatenation. I just tested your
expression in Access 2002, by using the /runtime command line switch, and it
works fine on my system. You might try the same test on your development
machine.

Have you checked to make sure that you don't have a bunch of unnecessary
references? Perhaps you are having a problem with one or more missing
references on the PC's that you are attempting to install the runtime.

Tom
______________________________________

:

Thanks! I will try it but I have not written a function of this nature or I
am not completly understanding.

Here is an example of my expression:
Signed: [Header]![Rank] & " " & [Header]![FullName] & "/"

How would I write a function for that?

Dwight

 

[Guest]

Tom,
I had tested it by using the /runtime as well and it worked.
I first thought was that I had missing references. Do you know of an easy
way to tell if I have any unneccessary references.

I have a total of 7 references:
-Visual Basic for Applications
-Microsoft 9.0 Object Library
-Microsoft ActiveX Data Object2.1 Library
-Microsoft DAO 3.6 Object Library
-Microsoft ADO Ext 2.8 for DLL and Security
-Microsoft Internet Controls
-OLE Automation

I do have an OLE Web Browser ActiveX control on one of the forms.

Thanks for the time and information you have been providing!

Dwight

 

[Guest]

Hi Dwight,

The easiest method that I know of is to simply uncheck any references that
you suspect might not be required, click on OK to dismiss the references
dialog, and then attempt to re-compile your database in the VBE editor (Debug

Compile DatabaseName). If the code compiles without the checked reference,

then you don't need it. If it chokes, then go back in to the references
dialog and add it back to the list of checked references.

Tom
_______________________________________

:

Tom,
I had tested it by using the /runtime as well and it worked.
I first thought was that I had missing references. Do you know of an easy
way to tell if I have any unneccessary references.

I have a total of 7 references:
-Visual Basic for Applications
-Microsoft 9.0 Object Library
-Microsoft ActiveX Data Object2.1 Library
-Microsoft DAO 3.6 Object Library
-Microsoft ADO Ext 2.8 for DLL and Security
-Microsoft Internet Controls
-OLE Automation

I do have an OLE Web Browser ActiveX control on one of the forms.

Thanks for the time and information you have been providing!

Dwight

 

[Guest]

Thanks!
I was able to get rid of 3 references. I hope this works.

Dwight

 

[Douglas J. Steele]

For each of the references remaining, determine what version of the
referenced file you have on the machine where the application works. Make
sure that the same version of each of the files exists in the same location
on each of the other machines.

See http://www.accessmvp.com/djsteele/AccessReferenceErrors.html for more
information