Linked table manager

[ideefixe]

Hello

I was wondering if there were any way to simulate the access Linked Table Manager programmatically? We have a SQL Server view in our app which fails to update correctly in Access unless the actual link is refreshed. I'd like to be able to do this each time we link up the app to the live database.

Any suggestions gratefully appreciated, thanks for your help.

 

[stopher]

There's quite a few options out there. I used some other code some some web site in the past but I can't find it right now (note to self: must file code properly/links properly)

Here's some I haven't tried:
Dev Ashish

Danny Lesandrini

hth
Stopher

 

[Bodisathva]

check out this thread.

 

[ideefixe]

Thanks very much for your assistance with this!

 

[Oldsoftboss]

Our here.....

http://www.access-programmers.co.uk/forums/showthread.php?t=95119&highlight=linked+table

Dave

 

[ideefixe]

Hi all

Just to let you know that this thread in particular helped me out:

http://www.access-programmers.co.uk/forums/showpost.php?p=525662&postcount=6

so thank you very much, Bodhisatva.

Just to add as well - there's a bug in Microsoft that means if you use the CurrentDB object to reference the tabledefs they will lose their state immediately afterwards - as I discovered!

Thanks again