Recordset Error

[Guest]

I have an intermitant problem I keep recieving the follow error message and
the database locks up. It has no error ID code.
" Cannot access the recordset. You might be at the end of the recordset"
Can anyone help
Thanks

 

[John Vinson]

I have an intermitant problem I keep recieving the follow error message and
the database locks up. It has no error ID code.
" Cannot access the recordset. You might be at the end of the recordset"
Can anyone help

Not without seeing the code, no. I presume that the error is arising
because you're... at the end of the recordset.

John W. Vinson[MVP]

 

[Guest]

Hi John thanks for replying
I'm new to Access, I understood the amount of records able to be inputted is
vurtual limitless?? The database I have set up is basically a single form of
customer names and addressess with a subform containing their purchases how
can or is the recordset limited??

 

[John Vinson]

Hi John thanks for replying
I'm new to Access, I understood the amount of records able to be inputted is
vurtual limitless?? The database I have set up is basically a single form of
customer names and addressess with a subform containing their purchases how
can or is the recordset limited??

I really don't understand your question.

Access does not put any limitation on the number of records in a
database (you're limited to 2 GBytes, tens of millions of records
basically, in any single .mdb file, but there is no explicit record
count limit).

There is an error in your Form, or in your code, causing this error
message. It is not a builtin Access limitation.

Try backing up your database and then selecting Tools... Database
Utilities... Compact and Repair Database. It's possible that you have
a corrupt Form. Is this database shared with other users, or
standalone?
John W. Vinson[MVP]

 

[Guest]

The database is stand alone
--
Don

I really don't understand your question.

Access does not put any limitation on the number of records in a
database (you're limited to 2 GBytes, tens of millions of records
basically, in any single .mdb file, but there is no explicit record
count limit).

There is an error in your Form, or in your code, causing this error
message. It is not a builtin Access limitation.

Try backing up your database and then selecting Tools... Database
Utilities... Compact and Repair Database. It's possible that you have
a corrupt Form. Is this database shared with other users, or
standalone?
John W. Vinson[MVP]