im managing a fuel management system which is used to manage fuel at alocal company and it uses acccess 2003,of late it has been failing to produce reports siting an overflow problem ,how can i rectify this problem.
-
-
You've have to realize that you've given us almost no information here, with the exception of the error you've encountered, which makes troubleshooting , expecially long distance, as it were, problematical! But here's a guess:
Overflow problems are usually associated with trying to stuff 10 # of potatoes in a 5 # bag. I'm going to guess, from the general description of your app, that you're doing some sort of running calculations in your reports. You probably have one or more numerical fields defined as Integers, which means their values are limited to 32,768. I suspect a running total has exceeded this limit. If this is the cause of your problem, the solution is to go into Design View for the underlying table(s) and change the Field Size of these fields to Long Integer, which has a limit of 2,147,483,647.
There are other things that can cause this error, but from your brief description I'm guessing it's something of this nature.
Linq ;0)> -
Check for Char fields too. I know they're rarely sensible to use, but I have come across them. These are much smaller even than Integers and overflow after 127.Comment
Comment