Nero
Shop smart, shop S-Mart
- Local time
- Today, 23:02
- Joined
- Jan 8, 2002
- Messages
- 217
Hi,
I am currently working an a database that was originally developed by someone else. It is a bit of a complicated process but I'll explain the best I can.
Data is exported to an export folder from a third party program once a day.In the database there is a macro constantly running waiting for the data to be exported to the folder. Once the data is found the data is then used in an append query and the data in the export folder is killed.
The append query then puts the data into a table. The table is the used by various select queries to produce reports.
The problem is the data that is originally exported is fine.The data when it sits in the export folder is also fine.Once the data is put into the table from the append query the data is wrong.
I'm assuming that the problem is with the append query I cannot see what data is in the append query because until the export folders appear there is no data to see, but as soon as the query see's the export folders it runs and puts the data in the table. What I need to do is halt the append query whilst it is running.
Is this possible and if so how do I do it?
Sorry it is a bit long winded.
Thanks in advance.
I am currently working an a database that was originally developed by someone else. It is a bit of a complicated process but I'll explain the best I can.
Data is exported to an export folder from a third party program once a day.In the database there is a macro constantly running waiting for the data to be exported to the folder. Once the data is found the data is then used in an append query and the data in the export folder is killed.
The append query then puts the data into a table. The table is the used by various select queries to produce reports.
The problem is the data that is originally exported is fine.The data when it sits in the export folder is also fine.Once the data is put into the table from the append query the data is wrong.
I'm assuming that the problem is with the append query I cannot see what data is in the append query because until the export folders appear there is no data to see, but as soon as the query see's the export folders it runs and puts the data in the table. What I need to do is halt the append query whilst it is running.
Is this possible and if so how do I do it?
Sorry it is a bit long winded.
Thanks in advance.
