Field Level Permission in Access: Help troubleshooting "Error 3163"

Hi,

I have created a 2002 access database for which I want to lock
specific fields depending on the user. The database contains text,
memo,yes/no, number, date/time and autonumber fields. There are
curently 42 fields and 234 records in the database; the size of the
database is about 1meg. It appears to function seamlessly without
enforcement of field level permission.

I am using the macros provided by Allen Browne (in FieldLevel2000) to
enforce field level permission. I have added the four columns as
suggested in the accompanying help document. When I use the form
frmAttribUser to load my Data table, only 26 fields out of 42 are
loaded and I get the following error:

"Error 3163: The field is too small to accept the amount of data you
attempted to add. Try to inserting or pasting less data"

My text fields are less than 255 characters in length (the max size
shown in design mode is 255). I have just learned that there is a 4k
total size requirement for all fields. I am not sure how to check
quickly this in my data or how to increase (if this is possible).
Granted, I am able to control those 26 fields that are loaded even
with the error. However the 4 fields that were added ("EnteredOn",
"Enteredby", "UpdatedOn", "UpdatedBy") remain blank when I check the
my data table.

Any hint on how to best troubleshoot these issues would be
appreciated.

Thanks

Re: Field Level Permission in Access: Help troubleshooting "Error

On Apr 6, 11:38=A0am, FJ wrote:
> Hi,
>
> I have created a 2002 access database for which I want to lock
> specific fields depending on the user. The database contains text,
> memo,yes/no, number, date/time and autonumber fields. There are
> curently 42 fields and 234 records in the database; the size of the
> database is about 1meg. It appears to function seamlessly without
> enforcement of field level permission.
>
> I am using the macros provided by Allen Browne (in FieldLevel2000) to
> enforce field level permission. I have added the four columns as
> suggested in the accompanying help document. When I use the form
> frmAttribUser to load my Data table, only 26 fields out of 42 are
> loaded and I get the following error:
>
> "Error 3163: The field is too small to accept the amount of data you
> attempted to add. Try to inserting or pasting less data"
>
> My text fields are less than 255 characters in length (the max size
> shown in design mode is 255). I have just learned that there is a 4k
> total size requirement for all fields. I am not sure how to check
> quickly this in my data or how to increase (if this is possible).
> Granted, I am able to control those 26 fields that are loaded even
> with the error. However the 4 fields that were added ("EnteredOn",
> "Enteredby", "UpdatedOn", "UpdatedBy") remain blank when I check the
> my data table.
>
> Any hint on how to best troubleshoot these issues would be
> appreciated.
>
> Thanks

I was able to get pass the error 3163. Now I am getting the following
one after I modified my data:
"Error 2465: ... can't find the field 'UdtapedOn' referred to in your
expression"

I did add the field "UpdatedOn" to my table.

Any hint would be appreciated.

Thanks