Hello,
It's been a long time since I posted here.
I bumped and actually kept bumping on this ODBC stuff.
I created a DSN and connected to an external mdb using ODBC.
What I did was SELECT the data and it is good.
Now, I want to UPDATE some data. After hours of searching,
I just can't make it work.
Before, my DB is within my Access application.
So I used this:
* This works fine.
When I started using external DB thru ODBC,
I was able to do SELECT.......but can't UPDATE!
(Haven't tried DELETE yet but I think I can't as well)
I badly need your intelligent advice.
It's been a long time since I posted here.
I bumped and actually kept bumping on this ODBC stuff.
I created a DSN and connected to an external mdb using ODBC.
What I did was SELECT the data and it is good.
Now, I want to UPDATE some data. After hours of searching,
I just can't make it work.
Before, my DB is within my Access application.
So I used this:
Code:
Dim sSQLUpdate As String
sSQLUpdate = _
"UPDATE TableName " & _
"SET ColumnStr = 'NewStr' " & _
"WHERE ColumnNum > 100"
DoCmd.RunSQL sSQLUpdate
When I started using external DB thru ODBC,
I was able to do SELECT.......but can't UPDATE!
(Haven't tried DELETE yet but I think I can't as well)
I badly need your intelligent advice.