Problem with MS Access

Woodchip Steve · 09-24-2005, 12:04 PM

I have been cataloging my magazine collection, and when it got too big for 3X5's I thought I would put in on Access. On Access from Office 2000 I had a problem and loaded Office 2003. For some reason it did not recognize the DB for 2000. It came up like an Exel form. I ran the analyzer and it said it wanted to split some columns up, so I said yes. I have over 700 records in this DB, and don't want to lose them. when the analyzer split them up I went through the process of renaming existing tables that were linked. So after all that, when I tried to run the query it came back " Data type mismatch in criteria expression", ran the analyzer again and it said I should change the cell format to number instead of text because it wanted a long integer. Luckily I saved a copy to another file, and it wiped out the table info. I have no idea how to fix this, because as you know I don't work with office much. Any help will be appreciated.

Chevy · 10-01-2005, 05:05 PM

Did you try to repair/convert the mdb file first? Make a copy of it, open Access 2k3, run the conversion.

09-24-2005, 12:04 PM	#1 (permalink)
Woodchip Steve Registered User Join Date: Sep 2005 Posts: 1 OS: MS XP Home	Problem with MS Access I have been cataloging my magazine collection, and when it got too big for 3X5's I thought I would put in on Access. On Access from Office 2000 I had a problem and loaded Office 2003. For some reason it did not recognize the DB for 2000. It came up like an Exel form. I ran the analyzer and it said it wanted to split some columns up, so I said yes. I have over 700 records in this DB, and don't want to lose them. when the analyzer split them up I went through the process of renaming existing tables that were linked. So after all that, when I tried to run the query it came back " Data type mismatch in criteria expression", ran the analyzer again and it said I should change the cell format to number instead of text because it wanted a long integer. Luckily I saved a copy to another file, and it wiped out the table info. I have no idea how to fix this, because as you know I don't work with office much. Any help will be appreciated.

10-01-2005, 05:05 PM	#2 (permalink)
Chevy Retired Join Date: Jul 2003 Location: Notlob Posts: 5,452 OS: Vista Ultimate My System	Did you try to repair/convert the mdb file first? Make a copy of it, open Access 2k3, run the conversion.