Runtime error when attempting to run report

C

Craig

Hello,

I have an Access Database designed in Access 2003 which I have distributed
with the runtime version of Access included with Visual Studio Tools for
Office 2005.

The database works well for the majority of users, but a small number of
users encounter a runtime error (causing the database to close) whenever they
try to run/preview any reports.

The form that they are using to run these reports has error handling, but
all I get is the dreaded "Access has encountered a runtime error and needs to
close," so I am not sure what the source/cause of the error could be. I'm
additionally mystified because I don't understand why some users get the
error and others don't. I am unable to replicate the error on my own PC.

My latest theory is that it may have something to do with the version of
Access runtime --- I think the trouble users are using Access 2000 runtime
whereas the ones who don't have problems have 2003?

My questions:

1. Are there 2000 and 2003 version of Microsoft Access Runtime?

2. If so, how do I confirm that the trouble user is on 2000 and not 2003?

3. If he is on 2000, how do I force his computer to use the 2003 version?
(I had thought I included the 2003 version with the installation package, but
he has MS Office 2000 on his computer and I think that somehow it may be
drawing 2000 runtime from that?)

Any help is greatly appreciated!

Thanks,

Craig
 
T

Tony Toews [MVP]

Craig said:
1. Are there 2000 and 2003 version of Microsoft Access Runtime?
Yes.

2. If so, how do I confirm that the trouble user is on 2000 and not 2003?
application.Version

3. If he is on 2000, how do I force his computer to use the 2003 version?
(I had thought I included the 2003 version with the installation package, but
he has MS Office 2000 on his computer and I think that somehow it may be
drawing 2000 runtime from that?)

That's more difficult. I'm not at all sure exactly what to suggest
here that would be usable by a user.

To be more specific you would somehow need to get the user, or some
software, to update the shortcut that points to your app. You'd have
to update the target field to include the full path to the A2003
runtime. This is made more difficult as this could be installed in
different folders, in which case you need to look up the path in the
registry, or the user may have a retail version of A2003.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 2003 and Runtime 7
Access 2000 runtime 4
Runtime 4
Problems with Access runtime 2
Access 2000 Runtime 4
Access 2007/Access Runtime 2003 2
MS Access 2000 runtime 2
runtime for 2003 5

Top