Run-time error '2105':

[PaleRider]

Hi,

I started getting this error after I deleted all records from my main table.
I have two accounts, "Full Permissions" and "guest". The "guest" account
only has open and read permissions set. The error only happens when I log in
as "guest". No error appears at all if I log in as a member of "Full
Permissions".

If I add at least one record to my Main table then I don't get the error
message when logging in as "guest". Makes no sense.

PR

 

[Jeanette Cunningham]

Hi PaleRider,
that error can happen when there is code that sets focus to a control and if
the form has no records, the focus can't be set under some conditions.

For example I had this error yesterday with one particular form. In my case,
the form was opening ready to take a new record, I had data entry set to
yes, but allow additions set to no and I got the error whenever I opened to
add a new record. In my case, the solution was to set allow additions to yes
and the error was solved.

So have a closer look at your form and its data properties on the data tab
of the form's property dialog.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[PaleRider]

Jeanette,

Didn't think about the control properties of the form as a possible culprit.
I'll take a look at what's going on in that area. Thank you for offering
another possible place to explore.

KP