Using MS Access/Access 2007 Query

Advertisement


Question
I was asked to look at a co-worker's database today because he was experiencing problems.

All of his queries were not working and I discovered it was because they were ALL looking for a table named "Venders" instead of the correct table named "Vendors".  

Do you have any idea how all these (maybe 20) queries could have been changed apparently accidently at once?

Do you know how all the queries can be changed back without having to go into each one and select the correct Vendor table and redirect all the fields to the correct table?  Is there something globally that can be done to correct these queries all at once.

Answer
No clue how they could have changed, but you can find a tool here:

http://www.rickworld.com/

to do global search and replaces throughout a database.

Hope this helps,
Scott<>
Blog: http://scottgem.wordpress.com
Website: http://www.diamondassoc.com
Microsoft Access MVP 2007
Author: Microsoft Office Access 2007 VBA

Using MS Access

All Answers


Answers by Expert:


Ask Experts

Volunteer


Scottgem

Expertise

I can answer almost all types of questions relating to Microsoft Access usage and application design. My strengths are database and interface design.

Experience

I've been designing databases for over 25 years working with dBase, FoxPro, Approach and Access.

Organizations
Author of Microsoft Office Access 2007 VBA
Techncial Editor for Special Edition Using Microsoft Access 2007 and Access 2007 Forms, Reports & Queries From Que Publishing

Education/Credentials
Brooklyn College BA

©2016 About.com. All rights reserved.