Version changes

B

Bill

I have an access db that has worked fine for years. Now, I've upgraded
(again) to XP & I'm getting a "Database or Object is Read-Only" message. I
think it's an easy fix, but at my age, I can't remember what I did when I
went from Access97 to 2000, & Win98 to NT. Thanks, -Bill.
 
M

Martin

It's a pain in the neck but, unlike Excel/Word etc, Access 97 files in
practice have to be converted to the new format. You can leave them in the
old format and read/write data but the moment anything has to be made or
changed design-wise (and I mean anything, even a quick query), you need to
convert. This can be done via Tools, Database Utilities. Access 2003 works
fine with both 2002/2003 format and 2000 format files. Watch out though:
some VBA commands and ActiveX controls (like those little calendar tools) go
wrong in the new format and may need some tweaking.
 
B

Bill

Martin, thanks for the reply, but the database has already been converted.
The box is running XP 5.1.26 & Access 2000. The database opens OK, but the
import doesn't work. I think it's an Object thats read only- maybe a table.
When I converted before (97 - 2000) I had to re-register something but I
don't remember what. Also I had to put ADO ahead of DAO in the list
somewhere - or some such thing. I hope this helps you help me. Sorry about
being so vague, but the greymatter just can't cope with these "every 3-4
year" events. ;-)
 
Top