Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Using varibles in SQL
0 views
Skip to first unread message
OD
Nov 6, 2009, 11:00:09 AM11/6/09
to
I would like to upsize my data base, but I'm having a problem with the SQL
statement. I access 2007 I had to rap a varible into a function then use the
function in the access querry. How do I use a varible in a SQL statement. If
I use the @ it prompts me for input. I need to pass the a varible to the SQL
statement.
statement. I access 2007 I had to rap a varible into a function then use the
function in the access querry. How do I use a varible in a SQL statement. If
I use the @ it prompts me for input. I need to pass the a varible to the SQL
statement.
Thanks
OD
Sylvain Lafontaine
Nov 16, 2009, 3:46:17 PM11/16/09
to
If you have upsized to a MDB (or ACCDB) database file with ODBC Linked
Tables, you shouldn't have this problem of passing a variables for your
current queries; so my thinking is that you have upsized to an ADP (Access
Database Project) project file. It's much more complicated to work with an
ADP project than with a MDB or ACCDB database file with ODBC Linked Tables.
Tables, you shouldn't have this problem of passing a variables for your
current queries; so my thinking is that you have upsized to an ADP (Access
Database Project) project file. It's much more complicated to work with an
ADP project than with a MDB or ACCDB database file with ODBC Linked Tables.
Please provide more details on what you have done exactly.
Finally, the official newsgroup for ADP is
microsoft.public.access.adp.sqlserver but I'm not suggesting that you keep
going this way.
--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Blog/web site: coding-paparazzi.sylvainlafontaine.com
"OD" <O...@discussions.microsoft.com> wrote in message
news:CEC2B543-E303-4DFD...@microsoft.com...
0 new messages