D
David Walker
I'm trying to read in some data from a set of dBase files into an Access
database. I can read the files in, but more than 75% of the time I attempt
to do so Access gives me an error (an illegal operation - this is often
followed up by an illegal operation in the kernel too, so something very odd
hapenning).
Anyway, all the files are dBase IV, maximum size of around 5MB so nothing
big here. I've tried both linking and importing - neither works. When I
try to link manually, I get the prompt for the index, give it the *.mdx
file, but for most of the tables I only get one record returned. I did see
in Access help file that it is to do with the indexes, but that is the only
index there is so don't really know what to do with that.
When I import the files, when it works it always gives me all the records,
but that is when I tend to get the illegal operations as above. I thought
it may be something to do with timing - i'm doing this programatically
everytime I update the data, and when I import all 4 one after the other the
error comes almost without exception - if I put in a 5 or 10 second delay
between each table, I seem to get less errors - but obviously I don't want
to porgram in minutes of delays into the program, and even with very very
long delays the errors do still sometimes happen.
I'm using Access 97.
Any ideas would be greatly appreciated!
David
database. I can read the files in, but more than 75% of the time I attempt
to do so Access gives me an error (an illegal operation - this is often
followed up by an illegal operation in the kernel too, so something very odd
hapenning).
Anyway, all the files are dBase IV, maximum size of around 5MB so nothing
big here. I've tried both linking and importing - neither works. When I
try to link manually, I get the prompt for the index, give it the *.mdx
file, but for most of the tables I only get one record returned. I did see
in Access help file that it is to do with the indexes, but that is the only
index there is so don't really know what to do with that.
When I import the files, when it works it always gives me all the records,
but that is when I tend to get the illegal operations as above. I thought
it may be something to do with timing - i'm doing this programatically
everytime I update the data, and when I import all 4 one after the other the
error comes almost without exception - if I put in a 5 or 10 second delay
between each table, I seem to get less errors - but obviously I don't want
to porgram in minutes of delays into the program, and even with very very
long delays the errors do still sometimes happen.
I'm using Access 97.
Any ideas would be greatly appreciated!
David