Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access VBA
|
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old September 5th, 2003, 08:30 AM
Authorized User
 
Join Date: Sep 2003
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Default Access and windows 98 versus XP

I've wrote an application which runs successfully under Windows 98 and i got a lot of troubles under XP, such as the instruction at this adress can is trying to write something at an adress where the memory could not be "written". This causes the application to stop.

Sorry, it seems to be a protection exception, but why it runs under 98. Can some one help me with this problem ?


Bassam Sater
__________________
Bassam
 
Old September 7th, 2003, 03:12 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 308
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Got an example of where the code fails?

I am a loud man with a very large hat. This means I am in charge
 
Old September 7th, 2003, 06:07 AM
Authorized User
 
Join Date: Sep 2003
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hello Steven,

Yes of course, it goes over a form with a subform and some code behind them. How can i send it ?

The whole zipped application is about 430KB.

Thanks a lot,
Bassam


Bassam Sater
 
Old September 8th, 2003, 10:44 PM
Registered User
 
Join Date: Sep 2003
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Bassam:

One of the main issues, when targeting different OS, is to handle this kind of problems. First of all all references that you to ADO, DAO, MDAC's calls etc. that works in Win 98 will not work in other OS. if You want to overcome this kind of situations you may do several things:
1. Install your app. with the runtime of access
2. Develop the application in the latest Access verssion and convert it to the different verssions of your targets. Note that this can be a painfull procedure.
3. Install your application in the target and make the modifactions.

Good Luck

Estuardo

 
Old September 8th, 2003, 11:43 PM
Friend of Wrox
 
Join Date: Jul 2003
Posts: 174
Thanks: 0
Thanked 0 Times in 0 Posts
Default

 
Quote:
quote:works in Win 98 will not work in other OS


Hogwash! It has more to do with the version of Office/Access that is installed rather than the OS, particularly if its an M$ OS.

Bassam - you said you used to run it under 98 but can't with XP. What version of Access was it before? Did you convert to a newer version? If so, which one? Are you running multiple versions of Access on your workstation?

Regards,

Beth M
 
Old September 9th, 2003, 01:47 AM
Authorized User
 
Join Date: Sep 2003
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hello,

Sorry, I forgot to give this detail.
The application was made under Access 2000 and I try to use it under
Access 2000 with Windows XP.

AT home, it works under ACCESS 2002, but it still the 2000 Format.
Thanks,
Basssm

Bassam Sater
 
Old September 9th, 2003, 08:21 AM
Friend of Wrox
 
Join Date: Jul 2003
Posts: 174
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Check the references by opening the VB Editor and going to Tools > References. See if there are any listed as Missing: If so, this is probably your culprit. After highlighting the 'missing' reference, browse out to find the correct file associated with the reference. Click OK and save changes.

Regards,

Beth M
 
Old September 9th, 2003, 10:05 AM
Authorized User
 
Join Date: Sep 2003
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hello Beth,

This was already done, it doesn't help.

I can send you the piece of code or the zipped application if you have time .

Thanks,
Bassam

Bassam Sater
 
Old September 9th, 2003, 10:20 AM
Friend of Wrox
 
Join Date: Jul 2003
Posts: 174
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
quote:I can send you the piece of code or the zipped application if you have time.
Can you copy & paste the function where you are running into the issues, and note where your code quits to the forum?

It is better to post to the forum as many people will be looking at it versus only 1 other. :)

Regards,

Beth M
 
Old September 9th, 2003, 10:34 AM
Authorized User
 
Join Date: Sep 2003
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hello Estuardo,

This is the way that i did, the strange thing about it that not only
the whole application is slower than before, but that some buttons
don't react any more on click for example.

Still seraching,
Bassam

Bassam Sater





Similar Threads
Thread Thread Starter Forum Replies Last Post
.net on Windows 98 sh.rajkumar C# 2005 1 October 23rd, 2006 03:53 AM
HELP - Access 2000 Runtime w Windows XP Compiled.. chasidim Access 2 April 3rd, 2006 11:06 AM
VB Source code in 98 vs. XP amitmohod Beginning VB 6 2 December 8th, 2005 07:42 PM
Windows XP ( +access 2003) problem? belete Access 1 October 11th, 2004 09:19 AM
Windows 98 OCX control issues vs Windows XP benoyraj VB How-To 0 May 5th, 2004 08:10 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.