Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access VBA
Password Reminder
Register
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Display Modes
  #1 (permalink)  
Old September 5th, 2003, 09:30 AM
Authorized User
 
Join Date: Sep 2003
Location: Rebecq, Brabant-Wallon, Belgium.
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
Reply With Quote
  #2 (permalink)  
Old September 7th, 2003, 04:12 AM
Friend of Wrox
 
Join Date: Jun 2003
Location: Melbourne, Vic, Australia.
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
Reply With Quote
  #3 (permalink)  
Old September 7th, 2003, 07:07 AM
Authorized User
 
Join Date: Sep 2003
Location: Rebecq, Brabant-Wallon, Belgium.
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
Reply With Quote
  #4 (permalink)  
Old September 8th, 2003, 11:44 PM
Registered User
 
Join Date: Sep 2003
Location: Lisboa, Lisboa, Portugal.
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

Reply With Quote
  #5 (permalink)  
Old September 9th, 2003, 12:43 AM
Friend of Wrox
 
Join Date: Jul 2003
Location: Houston, Texas, USA.
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
Reply With Quote
  #6 (permalink)  
Old September 9th, 2003, 02:47 AM
Authorized User
 
Join Date: Sep 2003
Location: Rebecq, Brabant-Wallon, Belgium.
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
Reply With Quote
  #7 (permalink)  
Old September 9th, 2003, 09:21 AM
Friend of Wrox
 
Join Date: Jul 2003
Location: Houston, Texas, USA.
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
Reply With Quote
  #8 (permalink)  
Old September 9th, 2003, 11:05 AM
Authorized User
 
Join Date: Sep 2003
Location: Rebecq, Brabant-Wallon, Belgium.
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
Reply With Quote
  #9 (permalink)  
Old September 9th, 2003, 11:20 AM
Friend of Wrox
 
Join Date: Jul 2003
Location: Houston, Texas, USA.
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
Reply With Quote
  #10 (permalink)  
Old September 9th, 2003, 11:34 AM
Authorized User
 
Join Date: Sep 2003
Location: Rebecq, Brabant-Wallon, Belgium.
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
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
.net on Windows 98 sh.rajkumar C# 2005 1 October 23rd, 2006 04:53 AM
HELP - Access 2000 Runtime w Windows XP Compiled.. chasidim Access 2 April 3rd, 2006 12:06 PM
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 10:19 AM
Windows 98 OCX control issues vs Windows XP benoyraj VB How-To 0 May 5th, 2004 09:10 AM



All times are GMT -4. The time now is 03:28 PM.


Powered by vBulletin® Version 3.7.0
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.