Windows Forum

Ask something
Discussion Locked

Old Access database

0 helpful
6 replies

by zlitocook

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
New job, all computers on 2000 or XP, with Office 2000. One user a (Director- Vice pres.) has an Access database 2.0 with company data (how much the directors make on profits) it can not be modified, changed or in any way have forms, fields, quries or the like be changed. There were three other people before me, two quit and the other was a consultant. None could upgrade the data base to Office 2000 Access but I think they did not wont to rock the boat. Or they just did not want to get the bosses mad. I have a copy of the data base and tried to convert it to 2000 but received errors, the data is still there but it is not the same as the old data base. I am not an Access guru so if you have tricks or links let me know.

6 replies

by hereinoz

A long shot, but can you export the tables to Excel or csv and then re-import them to Access 2000. This has worked for me before, but not with such an old version of Access.

Can you export the queries and forms as well??

Alan

by p.j.hutchison

I suggest creating the Forms and Queries and any VBA modules over from scratch (using same layout and names as old one). Then import the data from the old database into the new one.

by zlitocook

Iam a little closer I think. I can convert it to a point, then it errors out to a mapped drive. I suggested exporting fields and other things. She about had a cow:) She is sure it will distroy the data base, I think a trank dart will help me:) For her not me. She does not know I copied the data base so I am working undercover. The other people who tried must have been real goofs.

This discussion is closed to new replies.