sql server programming: SQL server and Access update -- sql server programming

SQL server and Access update

Bonzol
11/30/2006 8:14:58 PM

sql server programming: Hey there,, I know when updating,, Access can be differnt from SQL
server

this works in access from a vb.net 1.1 prog

SQL = "Update Clients SET UnameID= '" + updatevalue + "' WHERE ID = " +
checkValue + ""

Can anyone just quickly tell me what i have to change for it to work in
SQL server 2005?

Thanx..

Re: SQL server and Access update

xyb
11/30/2006 9:25:50 PM

SQL =3D "Update Clients SET UnameID=3D '" + updatevalue + "' WHERE ID =3D '"
+
checkValue + "'"

"Bonzol =D0=B4=B5=C0=A3=BA
"
[quoted text, click to view]

Re: SQL server and Access update

Arnie Rowland
11/30/2006 11:33:42 PM

It looks like it should work as a command string in VBA.

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server programming group.