I have a question for those SQL guys. I do editing and saving in Access using the DAO 3.5 all the time. I have reviewed some code and seeing that altering SQL seems to be nearly the same. Is this true? Or how would you best edit SQL databases through VB with DAO or??
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!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Access to SQL
- Thread starter JohnStep
- Start date
And I would tend to go without a DSN and use OLEDB....
You need a reference to Microsoft ActiveX Data Object 2.x instead of the one to DAO.
Code:
Dim ConnectionString As String
Dim con As ADODB.Connection
ConnectionString = "Provider=SQLOLEDB;Data Source=ServerName;User ID=UserID;Password=Password;Initial Catalog=Database;"
Set con = New ADODB.Connection
con.Open ConnectionString
'...
con.Close
Set con = NothingYou need a reference to Microsoft ActiveX Data Object 2.x instead of the one to DAO.
- Status
Similar threads
