No Prefixes Used for Objects

[Guest]

I have been given a database where the individual that created it did not use
a prefix for the objects... qry, tbl, etc. Is there a way to change the names
of the objects now?

Thanks, Jani

 

[Amy Blankenship]

Hopefully not, because the feature that Access uses to accomplish this can
corrupt your database when it is on. So hopefully the original developer
turned it off.

 

[Allen Browne]

Jani, while I personally do use the prefixes, there is no way I would
consider trying to add these to an existing appllication.

The benefit could not justify the effort in tracking down and making all the
changes. You might end up spending more time in trying to understand all the
queries and code and logic and identifying problems with the database than
you would if you recreated it.

 

[Brendan Reynolds]

I agree with what Allen says elsewhere in this thread - while I use the RVBA
conventions myself in Access/VBA work, I would hesitate to attempt to
'retrofit' such usage into an existing app.

That said, if I was going to do it, I'd use Rick Fisher's Find and Replace
(www.rickworld.com). I first used it when I needed to fix an 'inherited'
database that used non-standard characters in field names, and was very
pleased with the results.

There is also SPEEDFerret (www.moshannon.com). I have not personally used
SPEEDFerret, but all the reports I have seen from those who have used it
have been very favourable.