Access Link Help!
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 -- lehainam ------------------------------------------------------------------------ lehainam's Profile: http://www.excelforum.com/member.php...o&userid=18615 View this thread: http://www.excelforum.com/showthread...hreadid=388976 |
Access Link Help!
Try he
http://support.microsoft.com/newsgroups then navigate to the newsgroup you want, i.e: Your language Office Access Access Programming VBA -- - K Dales "lehainam" wrote: 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 -- lehainam ------------------------------------------------------------------------ lehainam's Profile: http://www.excelforum.com/member.php...o&userid=18615 View this thread: http://www.excelforum.com/showthread...hreadid=388976 |
All times are GMT +1. The time now is 01:59 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com