Test SQL Statements

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to find out if/how I can test SQL statements (something like a SQL interpreter) in ACCESS. Is there anyway to run a test before actually setting up the SQL query

Many thanks

Jack
 
Hi,


Not for Jet, and not within Access, even with MS SQL Server as database
engine. At least, with Jet, you are not obliged to SAVE the query to run it,
but with MS SQL Server, you HAVE TO save it, before running it, within
Access. On the other hand, MS SQL Server Developer (not MSDE, unfortunately)
has tools to test the SQL syntax and tables/fields existence without
actually running the statement, as it seems you are already aware, but you
have to access them outside Access.


Hoping it may help,
Vanderghast, Access MVP


Jack said:
I am trying to find out if/how I can test SQL statements (something like a
Click to expand...
SQL interpreter) in ACCESS. Is there anyway to run a test before actually
setting up the SQL query?
 
Michel (Vanderghast, Access MVP)

Thank you very much for your response. I've been racking my brain trying to figure out if I could test the statements in Access - perhaps MS will include that capability in a new version. Your info is most helpful

Best regards

Jack
 
Back
Top