I am tasked, at work, to support a massive database after another employee retired. He created this in access 97, then over the years, it has been upgraded it to SQL and I’m in process of upgrading to Access 2010 front end. He didn’t know anything about databases or access when he started, so it is completely custom and all done in macros. I know only basic knowledge about databases\front ends, but I can tell this access frontend so poorly written and just needs to be completely redone. But that is not within my ability. So I am forced to run and maintain it.:banghead:
Sorry, had to get that out of the way, now the task at hand. After upgrading the database frontend from Access 2003 to 2010 a few things do not work.
He created a macro where a query is opened, then all the records are selected, then “Copy” command, and then another query is opened with another table, and that data is then “Paste” command into that table and then both queries are closed.
It no longer works because Access 2010 does not appear to have these “Copy” “Paste” macro commands, even when clicking Show all Actions.
I tried creating an Append query to eliminate the macro but I kept getting Validation errors, but I could not find what was wrong with the records.
What is the best way to do this? VBA? Append Query?
Sorry for the poor explanation. Please go slow with me. I’m inexperienced. Let me know if i should post any other information.
Thanks
Sorry, had to get that out of the way, now the task at hand. After upgrading the database frontend from Access 2003 to 2010 a few things do not work.
He created a macro where a query is opened, then all the records are selected, then “Copy” command, and then another query is opened with another table, and that data is then “Paste” command into that table and then both queries are closed.
It no longer works because Access 2010 does not appear to have these “Copy” “Paste” macro commands, even when clicking Show all Actions.
I tried creating an Append query to eliminate the macro but I kept getting Validation errors, but I could not find what was wrong with the records.
What is the best way to do this? VBA? Append Query?
Sorry for the poor explanation. Please go slow with me. I’m inexperienced. Let me know if i should post any other information.
Thanks
