FRONT END ACCESS BACK END SQL SERVER

[Chance1234]

Been a long long time, brain is a bit rusty

I have in my database a f linked tabel going back to Sequel server,

name of the table is dbo_vw_acc_check_priority

im trying to run the following code,

StrSql = "UPDATE tblmain INNER JOIN (dbo_vw_acc_check_priority INNER JOIN tbltiers ON dbo_vw_acc_check_priority.cpty_priority_c = tbltiers.LetCode) ON tblmain.CounterpartyID = dbo_vw_acc_check_priority.CounterpartyID SET tblmain.Tier = [tbltiers]![Tier2];"

DoCmd.RunSQL StrSql

and i keep getting ODBC connection errors, i have a feeling im missing somethign damm obvious


please help!

 

[AshleyRickards]

You'll need to supply a connection string prior to you SQL statement. Something similar to this:

'Connect to the GenTCA DSN (Data Source Name), where UserID and Password are blank.
adoConn.Open "MyDSN", "", ""
Ashley L Rickards
SQL DBA