Peter,
Go to a backup, display the query in SQL view, copy it.
Go to the production database, create a new query, view it in SQL, paste it. >If you go into Design view, you can move the tables around to make it more readable.
Regards,
Cindy
Alternatively, import the queries from the old database. If you have 2016 or 365, that would be: External Data \ New Data Source \ From Database \ Access, If you have quite a few queries to import, that will make it quicker. Also, if one or more iscorrupted, then you will probably find that Access interrupts the import when it encounters the corrupt one. That can make it easier to spot where the error is.
Jack
Sysop: | Keyop |
---|---|
Location: | Huddersfield, West Yorkshire, UK |
Users: | 296 |
Nodes: | 16 (2 / 14) |
Uptime: | 79:56:18 |
Calls: | 6,658 |
Calls today: | 4 |
Files: | 12,203 |
Messages: | 5,333,178 |
Posted today: | 1 |