Database has reached maximum size/Out of Memory??

[Guest]

I went to change one of my forms today to edit the design a little and it
gave me the error message;

Database has reached maximum size/Out of Memory

Is there any way to fix this or am I at my limit? I can still add
information to my tables but I cannot change any of my forms and save them??
Any would would be greatly appreciated!

 

[Arvin Meyer [MVP]]

Unless your database is a single user local file, your database should be
split into a front-end on 1 or more workstations, and a back-end residing on
the server. You should also compact your back-end regularly. Compacting the
front-end will also repair some corruptions.

A form has a maximum of 755 controls allowed during its lifetime, that
includes controls and their labels, lines ... everything. If you've use that
up, the only remedy is to create a new form and copy & paste everything from
the old form into it. Then, once the new form is working properly, delete
the old one.

 

[Guest]

Thank you, I am going to try and create another form and copy everything
over, see if that works. But I am interested to know more about compacting
the back end. The database is on a server drive that the users have acces to
from various computers. I'm not all that familiar with front/back end
terminology but am interested in knowing how I can compact this database
without limiting it's operations or data

 

[Arvin Meyer [MVP]]

The users must be out of the database to compact it, as compacting actually
closes the database creates a new one, rewrites all the data, checks the
integrity, then deletes the old database and renames the new one. Most
admins do this after hours when users are out. There is also a utility,
Total Visual Agent, which can do this on a scheduled basis:

http://www.fmsinc.com/Products/Agent/index.html
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[Guest]

Thanks, that was very helpful and informative. It fixed the problem!

On another nbote if that's ok.

I have a form with a sub-form. The subform is sorted by "ServiceDate" In
datasheet view the sorting works great, but when viewed as a sub-form it is
all out of wak. I have looked over all the setting and can't figure this one
out. I have many other subforms and they all work great. Any suggestions on
where to look to fix the sorting? I just need the "ServiceDate" to be sorted
decending.

 

[John W. Vinson]

I went to change one of my forms today to edit the design a little and it
gave me the error message;

Database has reached maximum size/Out of Memory

Is there any way to fix this or am I at my limit? I can still add
information to my tables but I cannot change any of my forms and save them??
Any would would be greatly appreciated!

Check in Windows Explorer: how big is this database? The limit is 2 GByte; any
bigger and you'll get this error.

As Arvin says, compacting should be a quick partial solution; splitting the
database is *essential* for a multiuser app, or you *will* get this kind of
bloating. See
http://www.granite.ab.ca/access/splitapp.htm
for the rationale and instructions for splitting.

John W. Vinson [MVP]

 

[John W. Vinson]

I have a form with a sub-form. The subform is sorted by "ServiceDate" In
datasheet view the sorting works great, but when viewed as a sub-form it is
all out of wak. I have looked over all the setting and can't figure this one
out. I have many other subforms and they all work great. Any suggestions on
where to look to fix the sorting? I just need the "ServiceDate" to be sorted
decending.

What is the Subform's Recordsource? I'd suggest making it a query sorted
appropriately; if the Subform has a sort order defined, remove it and just use
the query for sorting.

John W. Vinson [MVP]

 

[Arvin Meyer [MVP]]

Go into the design view of the subform and open the property sheet. Look at
the Order By property on the Data tab. If there is anything in the property,
delete it and see if that doesn't fix your problem.

If there is nothing there, build a query and sort it the way you want. Then
replace the recordsource property on the Data tab with the query.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com