Can tables become read-only when an Access db may be reaching it'.

[Guest]

We have a very large database of about 3.5 million records. When we run vb
code that creates a recordset which should include about 1,000,000 records we
get error message 3027 - object is read-only. This is the same code we use
in about 50 other databases and have never seen this error before. What is
different about this db is its size. Any thoughts?

 

[Joseph Meehan]

We have a very large database of about 3.5 million records. When we run
vb
code that creates a recordset which should include about 1,000,000 records
we get error message 3027 - object is read-only. This is the same code we
use in about 50 other databases and have never seen this error before.
What is different about this db is its size. Any thoughts?

First Access has a size limit of 1 or 2 gig total size with no limit on
the number of records.

That said 3.5 million records is a lot for access and you may want to
consider moving to an SQL server with an Access front end.

Sorry I don't know if that specific problem is related to size. I
understand that very large files tend to get squirrelly in a number of
different ways.