Too much cell data causes coruption

[Lyza]

There's a live version of the database posted on the Intranet for end-users
to enter data over a 3-month period. When the database is ready to be
re-posted after data entry, the database is compacted and a macro ran on it
to turn it into the end-user version.

It seems that when pages become too full (during compact process), instead
of breaking a page the document in the database itself will not open. Also,
those portions of the database do not open when posted on the Intranet.
Need to know if there is a setting or data entry field quota on the amount
of data that can be entered on each page of a MS Access DB.

 

[Arvin Meyer]

Each row in an Access database can hold 2K of data. If there is a memo
field, it can hold 64K when entered through the GUI interface, or up to 2 GB
(the maximum size of the database) if entered programatically. Multiple
records can be entered in a single 2K data page, if they total 2K or less. I
have never seen the compaction process cause corruption, but trying to enter
more than 2K of data into a row, certainly will.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access