Good day,
I have inherited a very complex Access database that has a
plethora of tables, queries, forms modules and reports. Within a few
tables are a number of data elements with names that include a space.
My client wants me to place the database on their Informix platform
however, these fields with the spaces in them are causing problems.
I've identified the tables and the data elements that need to be
changed and am wondering if there's a way to identify where these data
elements are used in the balance of the database objects short of
opening every query, form, report individually and looking at each.
Have you any ideas that help me to automate the wonderfulness of this
search? Thank you.

Best Regards,
Jeff Jones
jpjones23 (AT) earthlink (DOT) net

Hi:

Goto :http://www.moshannon.com/
Speed Ferret is a wonderful tool. I do a lot of Access and a year
ago was involved with a big conversion of the backends of a number of
systems to SQL Server. It would have taken much more time without
this product.
It isn't cheap, but it was well worth the money.

Also, if you have a problem, you get to talk to one of the authors.

Good luck

Ira Solomon

On Thu, 10 Feb 2005 21:53:42 GMT, Jeff Jones <jpjones23 (AT) earthlink (DOT) net>
wrote: