2000 - 97 Access Error

[wiffyboy]

The database was created in Access 2000

I converted it to 97, using the build in "Convert to prior version" function.

I burnt it to disc, took it to college, then copy and pasted it onto the hard drive of a Windows 2000 Machines running Office 97. It opened up no problems.

The fmnuMainMenu form opened, to allow me to use the database. When I try to open any query, form, table it brings up the following popup message,

"Copy of "; already open, unable to open"

Or something like that, what the hell is wrong with it???

I'll be greatful for any help

 

[DES]

Have you checked

to see if the copy you pulled off of the cd was Read Only?

 

[wiffyboy]

Done that

 

[sambo]

You could create a new, blank .mdb file and import all of your forms/tables/queries/reports.

How about Compacting and Repairing??

 

[wiffyboy]

Compacting

I wondered about that, is it safe?

 

[sambo]

Everything is safe if you've always got a backup copy. How big is your .mdb file?
You should be backing up your working version quite frequently as you develop.

 

[wiffyboy]

I'll have a go, cheers