[MS_AccessPros] Refresh a Linked table

 

Hi All... :)

I want to refresh a linked table, i tried this code :

'----------------------------------------------------------
Dim Db As Database
Dim sLinkAddress As String

sLinkAddress = "D:\HDK_DB\AG_BE.mdb"
Set Db = CurrentDb

Db.TableDefs("T_1_PEG").Connect = ";Database=" & sLinkAddress
Db.TableDefs("T_1_PEG").RefreshLink

MsgBox "Refreshed"
'----------------------------------------------------------

but got an erorr :

Invalid Operation, and "Db.TableDefs("T_1_PEG").Connect = ";Database=" & sLinkAddress" was highlited

Please give me directions to solve this,,,it would be appreciated,, thank you.

Regards
Hendra Agestha

__._,_.___

Reply via web post

Reply to sender

Reply to group

Start a New Topic

Messages in this topic (1)

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___