limit size problem

[fetin]

Hello all,

I have question about my database access 2016 32bit version... Sometimes when I close backend application, then show up warning pop up about a 2gb limit or low disk space. I read about the access specifications, but I don´t understand where is problem in my db. I got statisic with vba code and detail is in attachment. Can someone please advise me? thanx

frontend size: 13MB (only tables)


backend size: 35MB (everything else)

[CJ_London]

your db is small - so what about the 'or disk space'? how much free space is there on your disk?

[fetin]

your db is small - so what about the 'or disk space'? how much free space is there on your disk?

hello, with disk space is not problem over 60GB free... you re right, it´s a small db so idk where is problem :/

[isladogs]

Good to see my Database Statistics utility in use in your screenshot!

[CJ_London]

no suggestions other than perhaps your db has some corruption. have you tried compact/repair?

[fetin]

Good to see my Database Statistics utility in use in your screenshot!

if this code for db statistics is your works, then many thanks for this... mr. google found it very easy and he's the biggest thief

[fetin]

no suggestions other than perhaps your db has some corruption. have you tried compact/repair?

compact/repair did not solve the problem, analysis without problem.

2Gb limit is only for size of file or
is there some other access restriction how many buttons, text field or another objects on formulars for example can have your db?

[isladogs]

if this code for db statistics is your works, then many thanks for this... mr. google found it very easy and he's the biggest thief

Yes its mine. See http://www.mendipdatasystems.co.uk/d...ics/4594424201
At some point, I will go back and tweak it a bit to fix things I never got around to doing at the time.

If those stats are for your 35 MB BE database, it should only contain tables. Forms, queries, reports, macros and modules should all be in the FE.

There are all kinds of limits in Access databases. See https://support.office.com/en-us/art...8-98c1025bb47c

[fetin]

Yes its mine. See http://www.mendipdatasystems.co.uk/d...ics/4594424201
At some point, I will go back and tweak it a bit to fix things I never got around to doing at the time.

If those stats are for your 35 MB BE database, it should only contain tables. Forms, queries, reports, macros and modules should all be in the FE.

There are all kinds of limits in Access databases. See https://support.office.com/en-us/art...8-98c1025bb47c

This statistics is from backend db, frontend is small db with a few tables.. I know about this restriction but for example Microsoft: "Total number of objects in a database = 32,768" is some way how to get detailed statistics for my db with this info or something else which says that it is beyond the limit?

[isladogs]

This statistics is from backend db, frontend is small db with a few tables.. I know about this restriction but for example Microsoft: "Total number of objects in a database = 32,768" is some way how to get detailed statistics for my db with this info or something else which says that it is beyond the limit?

Not quite sure what you meant but there's nothing here that suggests you'd reached any of the limits.
However my point was that the BE should only contain tables

[fetin]

Not quite sure what you meant but there's nothing here that suggests you'd reached any of the limits.
However my point was that the BE should only contain tables

yes you´re right, I wrote it wrong, of course it should be the other way around... statistics is from frontend not backend

[isladogs]

Glad we've cleared that up. Unfortunately it doesn't tell us what the problem is....