size of memo field

We have a memo field for each record and what I would
like to know if there is a limit to the date we can enter
both for the individuel record and also the total
batabase. We have suddenly got an error on the database
and am wondering itf it is as a result on the memo data
we have on the system?

Memo field: 65,535 characters when entering data through the user interface,
1 gigabyte of character storage when entering data programmatically.
Database: 2 gigabytes assuming Access 2000 or later. See 'specifications' in
the help file for details. What error are you getting?

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.


"Frank" wrote in message
...
We have a memo field for each record and what I would
like to know if there is a limit to the date we can enter
both for the individuel record and also the total
batabase. We have suddenly got an error on the database
and am wondering itf it is as a result on the memo data
we have on the system?

G'Day Frank,

The limit for each Memo field is 65,536 characters.

You can store LONG formatted Text/Documents/
Spreadsheets/Images/databases etc etc in OLE
object fields.

You don't say what the error was.
--
Regards,
Pat Garard
Australia

______________________________________

G'Day Frank,

The limit for each Memo field is 65,536 characters.

You can store LONG formatted Text/Documents/
Spreadsheets/Images/databases etc etc in OLE
object fields.

You don't say what the error was.
--
Regards,
Pat Garard
Australia

______________________________________

Frank wrote:
We have a memo field for each record and what I would
like to know if there is a limit to the date we can enter
both for the individuel record and also the total
batabase. We have suddenly got an error on the database
and am wondering itf it is as a result on the memo data
we have on the system?

Access, at least the older versions can have problems with corrupted
memo fields. After getting several of them I removed all my memo fields.
Fixing them are really difficult since the error does not show on the record
with the problem.

--
Joseph E. Meehan

26 + 6 = 1 It's Irish Math

Frank wrote:
We have a memo field for each record and what I would
like to know if there is a limit to the date we can enter
both for the individuel record and also the total
batabase. We have suddenly got an error on the database
and am wondering itf it is as a result on the memo data
we have on the system?

Access, at least the older versions can have problems with corrupted
memo fields. After getting several of them I removed all my memo fields.
Fixing them are really difficult since the error does not show on the record
with the problem.

--
Joseph E. Meehan

26 + 6 = 1 It's Irish Math

Corrupted memo fields are a problem much older than
Access (you got the same kind of problem in an office
filing system, and at some time or other in every
database system ever written had similar problems).

However, there are no known specific problems with
Access if you have a current version back to A97 SR2.

"Joseph Meehan" wrote in message
...
Frank wrote:
We have a memo field for each record and what I would
like to know if there is a limit to the date we can enter
both for the individuel record and also the total
batabase. We have suddenly got an error on the database
and am wondering itf it is as a result on the memo data
we have on the system?

Access, at least the older versions can have problems with corrupted
memo fields. After getting several of them I removed all my memo fields.
Fixing them are really difficult since the error does not show on the
record
with the problem.

--
Joseph E. Meehan

26 + 6 = 1 It's Irish Math

Corrupted memo fields are a problem much older than
Access (you got the same kind of problem in an office
filing system, and at some time or other in every
database system ever written had similar problems).

However, there are no known specific problems with
Access if you have a current version back to A97 SR2.

"Joseph Meehan" wrote in message
...
Frank wrote:
We have a memo field for each record and what I would
like to know if there is a limit to the date we can enter
both for the individuel record and also the total
batabase. We have suddenly got an error on the database
and am wondering itf it is as a result on the memo data
we have on the system?

Access, at least the older versions can have problems with corrupted
memo fields. After getting several of them I removed all my memo fields.
Fixing them are really difficult since the error does not show on the
record
with the problem.

--
Joseph E. Meehan

26 + 6 = 1 It's Irish Math