Hi, I am getting error "Overflow" when I am dealing with rowcount of 604655! What is the best way to handle such a big rowcount? Is there a way out I can accomplish it with Visual Basic and MS Access itself? Please suggest!
What is maximum number of rows MS Access can handle with visual basic 6?
Row count of 604655 seems to be large for a casual software. If you are developing something serious I suggest you read this.
http://databases.aspfaq.com/database/wha...
About cause of error, I hope you are following all standard conventions as assigning global/local variables... use OPTION EXPLICIT... don't go using global variables in functions and subroutines... I feel you should check all memory variables, if they are properly handled or not... and you are not trying to assign complete database data to variables...
pink flowers
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment