Hello Friends
I have 100 tables and now I changed the name of tables due to some reasons. Now I must to replace the names in other database objects.Is there any option that can reduce the work load because otherwise it is a tiring job to replace it manually.

Dare I ask why you have 100 tables? :rolleyes: sounds a bit suss to me ;)

Col

Dare I ask why you have 100 tables? :rolleyes: sounds a bit suss to me ;)

Col

well i am working on someone else database and actually the database was in Access 97 format and i converted it to Access 2002 and now i wanna frontend backend relationship being established between Access and SQL server.The naming os tables was not good in Access between there was spaces between the letters and i joined the letters with"_" and now a lot of work is waiting for me.

What I meant was that to have 100 tables in a database usually indicates that the database hasn't been written properly, therefore there will be problems further down the line.

What does your database do exactly? and what data is stored in the 100 tables?

Col

The database is about a specific brach of a company.