Help Rookie User Please Read And Give Any Advice Possible

[Guest]

I am trying to help a friend upgrade. We are switching everything to a Brand
New computer he has just purchased. Here's the problem: Currently he is
working in Windows 98 and with Microsoft Access 97. I only have 2003. As I
am sure we are all aware it is not a straight switch over to win xp. I am
receiving ton's of problems. Can anyone help me Transfer My current Access
File/Database to the upgraded version withour wrecking everything that has
been created.

 

[Douglas J. Steele]

I'm having a hard time figuring out what sort of problems you're
encountering.

Presumably the new computer has WinXP, SP2 on it. What version of Access
have you installed on it? Assuming you copied the old MDB file onto the new
machine, what happens when you try and open it? Assuming you didn't load
Access 97 on the new machine, what happens when you try and convert it?

 

[Guest]

Ok Here is what I have tried so far. I have tried taking the file of computer
# 1 and switching it over to access 2003. I get a bunch of conversion errors
as well when I try and do anything in the program it tells me that I have an
invalid path.

I have installed access 97 on the new computer and was able to transfer the
file but I still receive invalid path errors.

Would this have anything to do with the fact we are just switching his
internet over and he currently does not have any internet???

 

[Douglas J. Steele]

You need to be more explicit about the errors. Simply saying "a bunch of
conversion errors" doesn't give enough information for anyone to suggest
possible solutions.

When it complains about an invalid path, does it have any more information
to identify what it's looking for, and at what path it's looking for it?

No, I don't think not having internet should matter.

 

[Guest]

Hi Thanks for the quick replies.

This is what it states:

There were compiliation errors during conversion (From Access 97 to 2003) or
enabling this database
This Might Be Due to Old Syntaxthat is no longer supported

Then it allows you to open it Then it States:

Your XXXXXXXX database or project contains a missing or broken reference to
the file dao2535.tbl version 3.5 Check the code and recopmile it

I am wondering If I simply update the 97 version to 2003 on the orig machine
if it will simply convert the code However I am not willing to lose this file
trying so.

 

[Douglas J. Steele]

dao2535.tbl was only intended to be used in Access 97 with applications that
were converted from earlier versions of Access. It provided backwards
compatibility for commands that had been deprecated by Access 97. Go back to
the original machine, open the application, open any code module, select
Tools | References from the menu bar, uncheck the reference to the Microsoft
DAO 2.5/3.5 Compabilitiy Library, scroll through the list of available
references until you find the reference to the Microsoft DAO 3.51 Object
Library, select it, then close the dialog. Select Debug | Compile And Save
All Modules from the menu bar. That will start to identify all of the code
you need to correct to new syntax.

Once your application compiles cleanly in Access 97 on the old machine, take
it to the new machine.

(Do all this on a copy of the application, btw, just in case!)