M
Margaret Bartley
I have a table with 1.7 million records, and I want to add an autokey PK
field to it. I can't just add the field in design view, and save it,
because I get an error message, "Not enough space on temporary disk".
There's a pretty easy work-around. I just copy the table structure, add the
autokey PK field, and then append the original table to the new table.
But I'm wondering if any of you wizzes can point me to some web sites with
pointers and hints about working with very large databases. I'd like to
understand what kind of changes I would want to make to either my computer
settings, or the Access setup. I've occassionally in the past had problems
with not enough record locks, and I'm not really sure what I would do if
that came up. There have been other problems, also, that tell me I'd better
become more conversant with the needs of very large tables and queries.
I'm working with Access 97, Access 2000, and Access 20003.
Thank you,
Margaret
field to it. I can't just add the field in design view, and save it,
because I get an error message, "Not enough space on temporary disk".
There's a pretty easy work-around. I just copy the table structure, add the
autokey PK field, and then append the original table to the new table.
But I'm wondering if any of you wizzes can point me to some web sites with
pointers and hints about working with very large databases. I'd like to
understand what kind of changes I would want to make to either my computer
settings, or the Access setup. I've occassionally in the past had problems
with not enough record locks, and I'm not really sure what I would do if
that came up. There have been other problems, also, that tell me I'd better
become more conversant with the needs of very large tables and queries.
I'm working with Access 97, Access 2000, and Access 20003.
Thank you,
Margaret