Search in MS Access

[Simon Sweden]

Howdy folks
I want to search my MS Access 2000 DB for any string in
any of the fields. This should result in a list of all the
mathing posts which I can view, edit and export to Excel.

Any ideas?

 

[RobFMS]

You could either purchase a product that would give you what you want or you
could write some code that opens all the tables (tabledefs) and goes through
each of the fields.

--

Rob

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Problems with your database? Need to upgrade your application?
Contact the FMS Professional Solutions Group: www.fmsinc.com/consulting

Need a Book Recommendation?
www.fmsinc.com/toplevel/books.htm

Need software tools for Access, VB or .NET?
http://www.fmsinc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-