Access Link Help!

[lehainam]

Dear all,

I am trying to create a linked table in Access from a table in SQL
Server.

However this below code could not run and has an error: 'Could not find
installable ISAM'.

Sub SunSys_Linking_ADO()
Dim Lnk

Set Lnk = CurrentDb.CreateTableDef("KNOC")
Lnk.SourceTableName = "SALFLDG112"
Lnk.Connect = "Provider=SQLOLEDB;User ID=SUN;Password=SUNSYS;Data
Source=SUNSYSTEM"
CurrentDb.TableDefs.Append Lnk
Application.RefreshDatabaseWindow
End Sub

Could any one can help me or let me know some website of Access like
this web site so I can get advices.

Thanks a lot



Nam

 

[Guest]

Try here:
http://support.microsoft.com/newsgroups

then navigate to the newsgroup you want, i.e:
Your language
Office
Access
Access Programming VBA