Access & SQL Server w/Data Environment

[cj92713696]

I wrote an application using VB 6 and the Data Environment. My variables are declared as @Variable in my SELECT statements. I am using the same schema on my SQL Server and when I attempt to connect to SQL I get errors. I have read that I need to use ? as my variable names in my SQL selects, but the ? doesn't work w/Access 2000.

Is there a way I can use my Data Environment w/both Access 2000 & SQL Server?

Thanks,
CJ