G
Guest
I have a problem when I export data based on a query set
up in Access 97.
Here are the details:-
Access 97 Runtime to run the .MDB File
Source files, Query File and Destination file
(another .MDB file) or all located on the same location
(dedicated server - recenly moved over to).
When I export data using date criteria of say one month
(10,000 records), it exports no problem.
When I set it to a full year (150,000) records here is
what happens:
The export progress bar (bottom left) after a short time
fills completely (100%), as I monitor the file size it
increase by around 10Mb, then another 10Mb then nothing.
I have left this to run over night and no more progress is
made.
Any suggestions as to what may cause this/are there any
file size limitations on the Access 97 runtime version?
up in Access 97.
Here are the details:-
Access 97 Runtime to run the .MDB File
Source files, Query File and Destination file
(another .MDB file) or all located on the same location
(dedicated server - recenly moved over to).
When I export data using date criteria of say one month
(10,000 records), it exports no problem.
When I set it to a full year (150,000) records here is
what happens:
The export progress bar (bottom left) after a short time
fills completely (100%), as I monitor the file size it
increase by around 10Mb, then another 10Mb then nothing.
I have left this to run over night and no more progress is
made.
Any suggestions as to what may cause this/are there any
file size limitations on the Access 97 runtime version?