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?
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?
Boyd Trimmell aka HiTechCoach
Microsoft Access MVP -2010-2015
Programming: Nine different ways to do it right, a thousand ways to do it wrong.
Binary--it's as easy as 1-10-11
Posting Permissions
Reply With Quote
