Access Database (Change Table names etc.)

[lks10]

Hello,

I am editing an Access Database, which was programmed for me. I need to do some minor changes, however, I am only familiar with VBA not so much with access and sql.

Is there a way through a hotkey to see the sql code, so I can edit it, or add lines?

[HiTechCoach]

I would urge you to make lots of backups.

WARNING: Change Table names is NOT a minor change.


I would urge you to make lots of backups.

Test on a copy!


I would urge you to make lots of backups.

Unless you have a very good reason, like you want to rebuild everything, I would avoid changing table names and fields names. If yu must, I would purchase dome of the developer tools that will help with this.

What version of Access?

In Access there is a query designer that is normally used to edit the SQL.

Where is the SQL you want to change?