using 2003 to open a '97 db

[Rich]

I have users with 2003 and Im trying to give the ability to open or use '97 data base. Ive tried 2 things
1: just open db. this works but as soon as they try and do some form operation an error comes up 'operation not supported on replicable databases that have not been converted to the current version'
2. create a 2003 db with linked tables pointing at the '97 database. The result of this is that the linked tables have the first three fields missing and are replaced with fields named s_GUID, s_Lineage, ect

Shouldnt this be easy?

 

[alfie]

I know I saw some very good user instructions on this
website for converting Access 97 to Access 2002 but I
just can't find them. Anyone come upon them?

-----Original Message-----
I have users with 2003 and Im trying to give the ability

to open or use '97 data base. Ive tried 2 things:

1: just open db. this works but as soon as they try

and do some form operation an error comes up 'operation
not supported on replicable databases that have not been
converted to the current version'.

2. create a 2003 db with linked tables pointing at

the '97 database. The result of this is that the linked
tables have the first three fields missing and are
replaced with fields named s_GUID, s_Lineage, ect.

 

[Tony Toews]

I have users with 2003 and Im trying to give the ability to open or use '97 data base. Ive tried 2 things:
1: just open db. this works but as soon as they try and do some form operation an error comes up 'operation not supported on replicable databases that have not been converted to the current version'.
2. create a 2003 db with linked tables pointing at the '97 database. The result of this is that the linked tables have the first three fields missing and are replaced with fields named s_GUID, s_Lineage, ect.

This sounds very much like the A97 MDB has been replicated. I'd ask
in the replication newsgroup for better advice.

In the meantime you can try downloading WZRPRG97.EXE, replication to
regular db wizard from MS. http://support.microsoft.com/?kbid=168398
Once you unreplicate the 97 version then import into a new database to
ensure it's clean.

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