MS Access for windows95 v. 7.0 problems running with XP profession

[Ron]

MS Access for windows95 v. 7.0 problems running with XP professional

I get an "Out of memory" error message when opening my Access for windows95
v. 7.0 running in MS Windows XP Professional.

I have my entire business based on a database application designed in the
above Access version. I have since updated my MS Office to version 2002
proffessional and im using word and excel from this version, but I was unable
to convert my win 95 access files to the newer 2002 version. So I was forced
to continue using the older Access 7.0 to manage my business since i did not
have the 6month to spend on designing my database from scratch for a newer
Office version. After switching to Windows XP professional some access
functions dropped off and the opening of the program turned very slow.
However the program worked still. Now I today accepted one of the usual
automatic Windows xp updates. After this my old Access stopped workin. When i
open the program i get a "Out of memory" error message. and cant open the
program.

I sincerely hope someone can advice me on how to get my old access v. 7.0
working with my XP. Also would love to have any advice on how to successfully
convert the old Win 95 access version to Office 2002 access version.

Please help!

Regards

Ron

 

[Jerry Whittle]

That version of Access was a total mess. It was a bad attempt to move the 16
bit Access 2 (a very good product) to a 32 bit environment. I still shiver at
the memory of all my code vanishing never to be seen again but still working.
(Later I found out about the decompiling/recompiling trick, but I digress.)

If memory serves, you can convert A95 to the A97 file format if you have
Access 97. Then from A97 you can convert it up to A2K or the A02/A03 file
format. There are some 'gotchas' where code may need changing. MS use to have
a couple of documents on what to watch for during these conversions.

The first problem is finding someone with Access 97 still loaded on a
computer.

 

[Tony Toews [MVP]]

I have my entire business based on a database application designed in the
above Access version. I have since updated my MS Office to version 2002
proffessional and im using word and excel from this version, but I was unable
to convert my win 95 access files to the newer 2002 version.

Why weren't you able to convert the app? That shouldn't be that much
trouble. There are a few references that need to be removed and thus
some code to be touched up but nothing serious. I just had to convert
an app from A97 to A2003 to run some reports on a ten year old
database. <smile>

Convert the database to A2002 format. Keep the old database around
just in case.

Do you have any references besides the basic three or four? Copy the
following code to a module in a subroutine and run it.

Dim ref As Reference

For Each ref In Access.References
Debug.Print ref.Name & " " & ref.FullPath & " " & ref.Major &
"." & ref.Minor
Next ref

And tell us what those references are.

The Access 2002 default references when the MDB is created in Access
2002 format are:
Visual Basic for Applications
Microsoft Access 10.0 Object Library
OLE Automation
Microsoft ActiveX Data Objects 2.5 Library.

One of your superfluous references will likely be a 2.5/3.5
compatibility layer or some such. Remove it.

Another extra useless reference would be ADO which should be removed..
Add the Microsoft DAO 3.6 Object Library reference as it will likely
be missing.

Then compile the project and lets see what happens.

You might see things like rs.<field name> where rs is the name of a
recordset object. Replace the . with a ! (exclamation mark)

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/