I do IT for small business' and don't have much experience with Access so I was hopinh to find some help. I wasn't sure if this was a Query question a Table question or something else.
My clients database software company applied a big update and now all queries are broken. They updated all of the tables so that for example "table" is now "table1". All of the queries that were built many years ago that refer to the tables are now broken as they are still looking for "table". I played around and was able to copy the settings in a query using "table1" in place of "table" and it seemed to work.
The software support guys said "just update your queries" and won't help further. My problem is I'm not familiar with Access and couldn't find a solution other than manually recreating each Query. Any advice would be great.
My clients database software company applied a big update and now all queries are broken. They updated all of the tables so that for example "table" is now "table1". All of the queries that were built many years ago that refer to the tables are now broken as they are still looking for "table". I played around and was able to copy the settings in a query using "table1" in place of "table" and it seemed to work.
The software support guys said "just update your queries" and won't help further. My problem is I'm not familiar with Access and couldn't find a solution other than manually recreating each Query. Any advice would be great.