D
Dimitris
Hello, I have a very large database with 1,7 million records and about 100
fields. My problem is that I have a field with numbers but that field is a
text field and I cannot filter that field to find specific numbers. For
example I can't find the numbers > 7000.
I need to make that field a numeric field. I can't just change it in design
view cause I get the message there isn't enough memory or disk space. So I
am thinking of updating that table. I created the same table in another file
with no records but with that field as a numeric field. Now I need to update
table1 (with all the data) to table2 (the other db with no data). Will that
work? How can I do it? I don't know much about updating files.
Is there another solution?
Thank you
Dimitris
I have Access XP, and the db is 1,209,112 kb
fields. My problem is that I have a field with numbers but that field is a
text field and I cannot filter that field to find specific numbers. For
example I can't find the numbers > 7000.
I need to make that field a numeric field. I can't just change it in design
view cause I get the message there isn't enough memory or disk space. So I
am thinking of updating that table. I created the same table in another file
with no records but with that field as a numeric field. Now I need to update
table1 (with all the data) to table2 (the other db with no data). Will that
work? How can I do it? I don't know much about updating files.
Is there another solution?
Thank you
Dimitris
I have Access XP, and the db is 1,209,112 kb