Can't convert to 'Prior Access Version' need help 1

[TheStriker]

I am trying to convert my database from Access2000 to Access97 and I keep getting an error that says 'Can't create file'. I also tried to make an MDE file and that was also unsucessful. Can anyone please help me troubleshoot this. Thanks in advice

The Striker

 

[jryan224]

The Striker,
To my knowledge you cannot go backwards from Access 2000 to Access 97 gracefully.

I had the same problem between the Access version before 97, once converted to 97, I could not go backward.

The problem was my client opening in a newer version of Access than I was developing in. I now keep a couple extra copies of my version and ensure the client is doing daily backups so the separate data.mdb can be restored with only a day's loss of data.

Here is the way I ended up recovering my application.
I have not tried this with 97 and 2000 but it worked with the older version and Access 97.

Open a new blank Access 97 mdb and use File/Import external data to individually get the tables, queries, reports, modules, and macros from the Access 2000 version.

If your application is separated into a program.mdb and data.mdb with data tables linked from the data.mdb to the program.mdb you will have to create both as described above. In the data.mdb you will have to re-create your relationships. Then in the program.mdb re-link your data tables to the program.mdb.

Of course you will have to manually edit the startup information.

Hope this helps,
Jdemmer

 

[Tootle]

The only way i know of is to open the database in 2000 click tools, Database Utilities, Convert Database, To Prior Access Database Version. call the file acc97file and save then it should open in 97.

Hope that helps

Andy

 

[Junior1544]

I would suggest going into a module and tring to compile it... I have a feeling that since it wont let you even make a MDE file, that it can't compile...

--James
junior1544@jmjpc.net
Life is change. To deny change is to deny life.

 

[Tootle]

Sorry never saw that yep if you cant make an mde then most probably need to compile.

Thanks James

Andy

 

[TheStriker]

junior1544,

That's exactly what it was. It turned out that I forgot to compile all of my modules and cross-reference the object libraries to work in the prior version. I was also able to create an MDE file. Thank you very much.

tootle,

I followed that method and reached an error that said 'Can't create file'...then I got another message saying something to the effect of can't reference ODBC object library. This tipped me off to the fact that a compilation was in order before continuing to convert. Thanks anyway though.

jdemmer,

Since your approach had much, much more overhead, I thought I might try that as a last resort. I am so glad that it didn't come to that. Now I know what I can do if nothing else works...Thanks alot.