Hi all
I have a table in my database which i want to use so that i can amalgamate the data in multiple database (same structure) to this one table. i have links to all the relevant tables in the database and have append queries which take all the data from each of the tables and append them to my initial table. The problem i am having, is that my macro that runs the queries one by one seems to hang when it gets a certain number of queries in. i've managed to find out that it seems to trigger a key violation error. when the table is empty and i try running the query which triggers the error by itself, it works fine. i reallt am stumped as to whats causing this.
Hope this makes sense
Any help would be much appreciated.
cheers
I have a table in my database which i want to use so that i can amalgamate the data in multiple database (same structure) to this one table. i have links to all the relevant tables in the database and have append queries which take all the data from each of the tables and append them to my initial table. The problem i am having, is that my macro that runs the queries one by one seems to hang when it gets a certain number of queries in. i've managed to find out that it seems to trigger a key violation error. when the table is empty and i try running the query which triggers the error by itself, it works fine. i reallt am stumped as to whats causing this.
Hope this makes sense
Any help would be much appreciated.
cheers
