Trying to convert access 97 db to access 2003 db

[brett1234]

Hello all.

I have a client with an Access 97 database and they have recently upgraded to Access 2003.

When I try to convert the database using the "Convert database" tool in Access 2003 it comes up with an error saying "There is no field named 'BaseRowLineage' in table 'MSysTombstone'"

The table MSysTombstone doesn't even seem to exist in the database when I look.

I have searched all over the net and this forum and can't seem to find an answer.

I am new to this so please forgive me if it something simple.

Any suggestions would be greatly appreciated.

Thanks for you time.

 

[ghudson]

Any table that prefixes with MSys is a system table but that name is not consistant with a true system table name. Does the converted db not work?

Try importing the Access 97 db objects into a new Access 97 db. Then convert it to an Access 2003 file format.

 

[brett1234]

The Access 97 database file will open in Access 2003 but it says Access 97 file format in brackets beside it.

I get the error when it tries to convert it using the convert database tool.

I dont actually have a copy of Access 97

Any other ideas?

Thanks.

 

[brett1234]

In my search I have found what looks to be a solution

http://www.mcse.ms/archive147-2004-5-627048.html

It says it is a problem with replicated databases.

I cant seem to figure out what a replicated database is.

It suggest to unreplicate my database. If I do so will I the database lose any functionality?

Help!

Thanks again!

 

[ghudson]

Try creating a new Access 2003 db [file format Access 2002/2003]. Then import all of the db objects from the Access 97 db into the new Access 2003 db. The import process will let you know which object(s) it can not import but it will let you continue with the import process for the rest of the db objects.

 

[brett1234]

I am still having trouble with this. I found an article that points to an Access add-in that will unreplicate the database for you. ( http://www.mcse.ms/archive147-2004-5-627048.html ) After you do this the upgrade to 2003 is supposed to work... Well, I downloaded the add-in and ran it but it is telling me that my database is not the design master. I have no idea about replication so I dont know where I would find the "design master". And besides I only have the 1 database file. I am at a complete loss of what to do.

Thanks again.

Brett

 

[brett1234]

Alright, I imported everything from the 97 db into a blank database in access 2003 like you suggested. It didn't come up saying it couldnt import anything. After I imported the 97 database it said it was in access 2000 format. I then converted successfully to access 2002 - 2003 format. I think everything should be fine seeing how when I imported no errors came up.

I cant believe it was that simple after all of the trouble i went through.

Kind of makes me mad!

Anyway, thanks so much for your help.

I am also wondering if you know of anything else i might have to do to avoid any kind of problems, or should it be fine?

 

[brett1234]

hmm, i'm haivng some problems already, any form with a subform/subreports in it will come up with an error when i try and open it saying for example: "the form name "sfrmBldg" is missplelled or refers to a form that doesn't exist" The name sfrmBldg appears to be a custom subreport they made with access 97. I wonder where that stuff is stored? Doesn't seem like it imported into Access 2003 correctly!

Any ideas?

 

[RuralGuy]

PMFJI but here's a link you may find useful. Converting from Access 97