Tech Support banner

Status
Not open for further replies.
1 - 2 of 2 Posts

·
Registered
Joined
·
1 Posts
Discussion Starter #1
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. :4-dontkno
 

·
Registered
Joined
·
4,890 Posts
Did you try to repair/convert the mdb file first? Make a copy of it, open Access 2k3, run the conversion.
 
1 - 2 of 2 Posts
Status
Not open for further replies.
Top