Access DB reached count limit 32XXX "Overflow" error

Hi - A client is using a MS access DB for quotes and whatnot..  there is an embedded integer that has a the above limit.  I am looking for a way to use the same front end - but create a new DB that would reset these counts - or a simple change that will stop the error happening.
Committo CommittoAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

aikimarkCommented:
Is the limit in a table/field definition or VBA code?
Committo CommittoAuthor Commented:
The limit I'm referring to is at this link.
http://www.databasezone.com/techdocs/acclimit.html

"Number of objects in a database    |      32,768"

Using Access 2007 if that makes any difference.
aikimarkCommented:
Are you saying that you have more than 32000 objects in the database?!?  Are you sure?

I didn't think you would get an "Overflow" error such a situation.

Are there a lot of temporary objects?  If so, we can work towards clean-up code.
Active Protection takes the fight to cryptojacking

While there were several headline-grabbing ransomware attacks during in 2017, another big threat started appearing at the same time that didn’t get the same coverage – illicit cryptomining.

Gustav BrockCIOCommented:
It is more likely to signal a simple overflow in a variable or table field declared as Integer.

Change that/those field(s)/variable(s) to data type Long.

/gustav

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Helen FeddemaCommented:
I agree with Gustav.  It would also be a good idea to do a Compact & Repair, to remove any redundant temporary objects.
PatHartmanCommented:
there is an embedded integer that has a the above limit.
Change the data type to Long Integer if you don't need any decimal positions.  Otherwise, define it as Double.

You should not have to change the FE but if the BE is not Jet/ACE, you will have to refresh the link.  Jet/ACE tables automatically refresh.
PatHartmanCommented:
I answered the question.  Integers have a limit of 32xxx so the data type needs to be changed.
PatHartmanCommented:
Sorry Gus, I didn't read back far enough.  Please cancel my award and give it to yourself.
Gustav BrockCIOCommented:
Well, it might be so, but who knows?

/gustav
Committo CommittoAuthor Commented:
The person that manages the DB ended up creating a new back end DB using the same front end..  This reset the numbers and stopped the issue
Gustav BrockCIOCommented:
Reset? Sounds like the cause wasn't removed, and the issue will show its face at some time again.

/gustav
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.