Limit to the amount of records?

R

Raul

Is there a limit to the amount of records I can put in a database? I'm at 648
and it won't let me add more. Can any Help?
 
K

KARL DEWEY

It can't be the record limit.
What are the error messages? From where are you inputting the new record?
What is your table structure?
Post the field names, datatype, and sample data.
 
L

Larry Linson

Raul said:
Is there a limit to the amount of records I
can put in a database? I'm at 648
and it won't let me add more. Can any Help?

There is no such limit in Microsoft Access and the default Jet database
engine. So now, we can try to assist you in debugging, but we'll need more,
and detailed, information. Just remember, you are there, can look at your
database and see what you have, but we are remote and are depending on what
you post here to try to assist.

Could you clarify what you have and what you are doing?

You _are_ using Microsoft Access and the default Jet database, aren't you?
If so, what version of Access?

What error message, copied and pasted here, or quoted _exactly_, are you
getting?

One table, and just adding data records? Or multiple tables, and the total
number of data records you are adding is 648? How many fields in the
table(s)? Do you have validation properties specified in the Table
definiton or on the Forms that might be violated by something you've done
with the 649th record?

Larry Linson
Microsoft Access MVP
 
J

John W. Vinson

Is there a limit to the amount of records I can put in a database? I'm at 648
and it won't let me add more. Can any Help?

I've seen databases with 20,000,000 records in the largest table; your
database is limited to 2 billion bytes. I sort of doubt you're anywhere close!

What's the nature of the table? What are you putting into it? What error
message are you getting?

John W. Vinson [MVP]
 
T

Todos Menos [MSFT]

Larry

Jet is NOT the default engine, asshole

stop spreading mis-information, kid
 
T

Tony Toews [MVP]

Todos Menos said:
Larry

Jet is NOT the default engine, ***hole

stop spreading mis-information, kid



Note that this person is really A a r o n K e m p f and that he is not an employee
of Microsoft.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 
Top