Import data - error message about disk space?

G

Guest

My database is updated daily and one table is very large so when I import my
data to this table, I am now getting an Access error message ' Your computer
is out of disk space. You wont be able to undo this paste append ' . Why
this message and what can I do about it ( is it ram upgrade time ? ) Ive got
20 gigs on the hard drive still open so its not that.

Thanks in advance
 
D

Douglas J. Steele

How large is your MDB file? Access 2000 and newer have a limit of 2 Gb
(previous versions were 1 Gb)
 
G

Guest

The mdb file size is 76 megs, how many rows can one add to a table, is there
an upper limit? thanks
 
D

Douglas J. Steele

No limit in terms of number of rows. The only limit is that the MDB cannot
exceed 2 Gb.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top