Search results

Everything is trusted. And even if I try just a straight append query to the other database I still get the error. I even have tried just updating a couple of fields and if any of the fields have a space in them it gives an error that it can't find the field even with the square brackets...

Here is the SQL: INSERT INTO Individuals ( Company_Id, [Contact Number], [Mr/Ms], Initial, [First], [Last], Title, [Email address], [Area Code], [Bus Phone], Ext, [Main Contact] IN 'C:\EF Database\EF Main Dbase.mdb' SELECT Individuals.Company_Id, Individuals.[Contact Number]...

The SQL and code Here is the SQL: INSERT INTO Individuals ( Company_Id, [Contact Number], [Mr/Ms], Initial, [First], [Last], Title, [Email address], [Area Code], [Bus Phone], Ext, [Main Contact] IN 'C:\EF Database\EF Main Dbase.mdb' SELECT Individuals.Company_Id, Individuals.[Contact...

I have a database that dumps data to another database with an append query which is activated by a button on a form. This works fine in Access 2003 but when we load it in Access 2007 and run it it somes up with the error Reserved error (-1524); there is no message for this error. Any...