Access VBADiscuss 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 .
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 ?
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.
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?
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.
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.