OVERFLOW problem in Table Analyzer

[Guest]

I was trying to create data relationships with Table Analyzer Wizard.
Whenever I rename the table(in pane 5), I get an error message "Overflow".
Does anybody know what that means and how to correct
it?
Thanks a million!

Mindy

 

[Arvin Meyer [MVP]]

An overflow error generally occurs when you are putting too large a value in
a field whose datatype can't handle it. Like trying to put a long integer
into an integer field.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[dbahooker]

ACCESS MDB IS FOR SISSYS AND BABIES

use SQL Server; the 'index tuning wizard' or 'database tuning advisor'
put 'analyze table' to shame