Can you test SQL Statements from in Access like in SQL Server Mgmt

[MLyons10]

Hi everyone, I have Access 2007 installed and was wondering if there was a
way to open a window in Access 2007 and test SQL Statements like you can in
SQL Server Management Studio Express. This would really be a very useful
feature if it isn't there. I don't know why it wouldn't though...

Any help or information would be greatly appreciated.

Thanks Again,

 

[Jeff Boyce]

The user interface shows SQL statements as queries in design view.

You could open a new query in design view, switch to SQL view, enter your
SQL statement, then try to switch back to design view.

If Access displays the design view, it could figure out what the SQL meant.
If it can't figure it out, you'll get an error message.

Is this what you had in mind?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[adan perez]

hey