Re: Access97: Not all tables copied
Posted by: Rod Tatham
Date: May 10, 2005 08:56AM

Thanks to chriss83!

Making sure that the first column was numeric (although the type of the Access field didn't seem to matter), enabled me to migrate all my tables. I simply found any table where the first field contained alpha (or other non-numeric) characters in any data in that column, and inserted a new Autonumber field as the first field in that table instead. That did the trick and solved the problem.

This related to Access 2000.

All the best,

Edited 1 time(s). Last edit at 05/10/2005 09:01AM by Rod Tatham.

Options: ReplyQuote

Written By
April 22, 2005 08:26AM
April 22, 2005 11:12AM
April 26, 2005 04:01PM
April 26, 2005 04:03PM
April 29, 2005 10:36AM
Re: Access97: Not all tables copied
May 10, 2005 08:56AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.