VBA and Access97

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

I'm working with Access 97.
In a form, I have a listbox based on a query which calls a function I have
created.
This function calls VBA functions like "Mid", "Instr" or "Len".
When I open this form on my computer where Access is installed every thing
is ok.

If I open this form on a computer with only Access runtime, list is empty
and my function is not called. It seems that the query is not running at
all.
If a delete the call to this function in my query, everything is ok.

Could you help me please.
Chris
 
You need to check your "references". One the development computer, open the
MDB, and then view some VBA code (any will do), then select Tools/References.
Note down all the references that have a check next to them. These are the
dlls, ocx's etc. that are needed for the MDB to run correctly. Now,
unfortunately, to transfer these files and references to a runtime version
computer (one that does not have full Access) you need to include them with
the distribution files for the application.
 
This usually means you version of JET is miss-matched.

You need to install on your developer pc:

office sr2b update
jet35sp3.exe update

The above also needs to be installed on the target pc also.
 
Thanks Albert,

I have tried this, but I get to problem :

1) I'm unable to install Office sr2b on target pc. Update doesn't work. (Sp1
doesn't work too)
2) I have a custom workgroup file and with this install, I'm unable to join
to it. He says to me that he successfully join my custom workgroup but it
doesn't.

Could you help me more ?
chris
 
I have already checked all of my references and all of them are added with
my distribution files.
 
Thanks Albert,

I have tried this, but I get to problem :

1) I'm unable to install Office sr2b on target pc. Update doesn't work.
(Sp1
doesn't work too)
Click to expand...

Hum, that is a problem. I assume you have both sr1, sr2b, and the
jet35sp3.exe installed on your development pc..right? (you *really* need to
do this!!). Further, there is a also a sp (service pack) for the runtime
system..and you need to have installed that also. I would de-compile your
application, and re-compile..and re-build the install AFTER doing the above
patches.

Also, you could just try installing jset35sp.exe on the target pc..as that
OFTEN fixes the broken ref problem (this has worked many times for me).

2) I have a custom workgroup file and with this install, I'm unable to
join
Click to expand...
to it. He says to me that he successfully join my custom workgroup but it
doesn't.
Click to expand...

You need to supply a short cut that specifies the workgroup file...
 
Back
Top