STRING SEARCH OF DB?

[PATRICKC]

How can I search my entrire datbase for a string? I changed a sql table and now it has different field names....

 

[tlbroadbent]

I'm unclear on your request. Do you need to find data in columns of a table or names of the objects or columns in the database?

In reference to the SQL table:

1- Is it an MS SQL Server table linked in an Access DB?
2- Did you replace one table with another or modify the schema of the table, thus changing the field or column names? Terry

X-) "Life would be easier if I had the source code." -Anonymous

 

[MichaelRed]

There is a 'tool' called "Speed Ferret". It advertises the capability of doing a global search and replace throughout Ms. Access MDB files. It is NOT cheap.

You can do most of the searching in the tables MSys*. Replacing is a bit more complex, but still depends on the MSys* information. I have done the searching part (programatically) through the tables in Ms. Access '97. this is where you can find all occurances of the table and field names for all of the objects in the database. You can also find the references to external "objects" - if they are instantiated by Ms. Access. For objects instantiated via code or references - I can not help you.

For my purposes, the finding was the issue - I started with the thought of building a 'data dictionary' for the database. Only later did I need to do the global search and replace. Thankfully, the repalcements I need t do were few enough to be able to do comfortably in manual/edit mode.


MichaelRed
redmsp@erols.com

There is never time to do it right but there is always time to do it over

 

[raskew]

I've used Speed Ferret for years and have found that it does work as advertised. But, as Michael pointed out, it's gotten a little pricey ($149). However, it's well worth the cost. You'll find it at:

http://www.moshannon.com/speedferret.html