Recreating a table

I am using VB to add multiple records to a Table, Table6, when I post the records the new records are not part of the table. If I manually use the Convert to Range function on Table6, then recreate the Table, the newly added records are now part of the Table. I created a macro to automate the above steps, when I ran the macro I got the error "Table cannot overlap another table." First I ran the code to add the new records, then ran the recreate table macro. Eventually hope to combine the two. It works if I do step two manually, any ideas what is different?

This is the code I'm running to post the records to the database, Table6, should I add your code to the bottom of my code?

Please Login or Register  to view this content.

I've manage to upload the file, but now can't find it to attach to email. There is nothing in the site Home directory. Any suggestions. Thanks

Hi Tom1977
Did you ever get a chance to look at my code? How would I integrate your code with the code I am using? Thanks