Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Data Environment w/Access & SQL ?

Status
Not open for further replies.
cj92713696

cj92713696

Programmer
Nov 23, 2000
105
US
I've developed an app. using Visual Basic 6 that utilizes the data environment w/an Access 2000 database. I have since setup a SQL Server replicating the Access schema. Am I allowed to connect my data environment to my SQL Server by just changing the data source? Is there any way to do this?

The problem I have lies in the variable declares in the actual SQL text. Access variables are listed as @VarName whereas SQL Server lists variables as a simple ?.

I'd really like to connect my app. to my SQL Server database w/o re-doing the entire data environment changing all the query variables to ?. I have at least 60 queries that would need to be converted and this seems like an excessive amount of extra work if it can be avoided.

Thanks,
CJ
 
Status
Not open for further replies.

Similar threads

2009luca
  • Locked
  • Question
graph with access database - im on vb6 2
Replies
10
Views
400
strongm
strongm
Swi
  • Locked
  • Question
API - multipart/form-data
Replies
3
Views
343
Swi
Swi
sal21
  • Locked
  • Question
ARRANGE this Access coe to vb6
Replies
4
Views
177
strongm
strongm
Niki_S
  • Locked
  • Question
How to use a combo box to get data from SQL? 1
Replies
1
Views
93
Andrzejek
Andrzejek
Niki_S
  • Locked
  • Question
How to get data from sql into a combo box in vb6?
Replies
3
Views
156
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top