You did not say what version of MS Office you're using, so my example is coming from MS Office XP:

1) Create a simple SELECT query from your linked table/view. Arrange...

You can also go to this website:

http://www.mvps.org/access/modules/mdl0064.htm

This has a download of an Access add in which is called DSNStripper - it automatically creates the DSNless connection for you. Website...

Use the In String function - much better at removing unwanted characters. Just pass in the string that contains the unwanted character, then pass in the actual unwanted character to...

Place this line of code into a module. Then, call this line of code from your update query:

Function cLeft(sVal As String, lLen As Long)

    cLeft = VBA.Left(sVal, lLen)

End...

Jamie:

Since your using version 2002, try using this add-in for Access. It's called DSN Stripper and gives you what's called a DSN-less connection. No more need for ODBC drivers. Here...

UPDATE tblMyTable

SET Col014 = 7.45

WHERE Col014 IS NULL

Sometimes I get that message in Access. In your SQL table, create an Auto ID column:

[nAutoID] [int] IDENTITY (1, 1) NOT FOR REPLICATION  NOT NULL

This is like creating a column...

Open your linked table in the Access db...check at the bottom where the record selectors are - make sure that the one on the far right (asterick) is not greyed...