[MS_AccessPros] RE: Refresh a Linked table

 

Hi Hendra,
The same restriction applies to the QueryDefs collection, you can only change the SQL or Connect if you assign/create a QueryDef object and then manipulate the parameters, otherwise they are readonly.
In my experience, you don't normally need to do a RefreshLink after changing the Connect string (at least with Linked SQL Server Tables), it might however be "best practice" to do so.
Yours,
Andrew

__._,_.___

Reply via web post

Reply to sender

Reply to group

Start a New Topic

Messages in this topic (6)

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___