MS Access 2010 - Variables (Declare/Set)

[vsummers]

I am working with MS Access 2010 and hoping to, as I would using SQL Server, declare and set variables within a query. Does MS Access support this? If so what is the syntax?

 

[hernantorres23]

Hi, you can use the Pass-Through query. In my case, Mikel ERP, take advantage of everything related to the environment in MySQL, SQL Server, PostgreSQL. But in most cases, I use stored procedures from VBA

 

[vsummers]

Hi,
Thank you very much for looking at my post and replying.
Grateful...

 

[xenou]

MSAccess SQL doesn't directly support declare or set with variables. By which I mean you cannot write SQL queries with DECLARE and SET and run them.

However, You can use MSAccess VBA to combine visual basic programming elements (variables) and manipulate them in conjunction with SQL queries. This will be clunky compared to TSQL but will get the job done if you really need this kind of behavior and can't work around it with plain SQL or SQL parameters.

As stated above, if you use a pass-through query to pass through the sql to a server such as SQL Server, then you can write the query exactly as it would be executed on SQL server - in the case Access isn't executing the query but the remote server is doing the execution so you can leverage the features available on the remote server.