Recent content by zach

what if you added a column to source db's like a GUID, and then just merge to the destination db with that, using your guid as a primary key hope that helps

well I am still not sure how to set my db variable to open a database I used a data grid view to loop thru table schema and get my table name that way.

same problem I am getting the same error when i try to access the MSysObjects table. I am using a 97 DB that I have converted to 07 but both versions give me the same error. Any Ideas???

yes i see Doc's reply is very helpful but how would i actually open the .mdb file so that i can set my variable db(datatype is database) to the database so that i can get the table names

ok i have been looking at looping thru the MSysObjects system table to get my table names that end in "Data" but i am getting the error: Records cannot be read, no read permissions on MSysObjects. this is a 97 access DB opening with 07, i have enabled all the content and converted to an .accdb...

You read correctly Yes, finally somebody understands what i am trying to do. I will be pulling only about 10 columns(if the column has data) and inserting them into one very large SQL server 2005 table. I am pretty sure my coding will work once i get the actual looping to take place. I am...

Hello all, i am new so please bear with me. My question is: I have this access 97 database that opens with office 07 and I am TRYING to open the database and loop through it pulling data from columns in all tables that end with the word "Data". I am lost so your help is greatly appreciated!!