Refresh Link 
Author Message
 Refresh Link

I Want to have my application look at two different
Access Db depending on the function they are performing.

In going thru the Microsoft Jet Engine Programmer's Guide
(3.0) I found a (sort of) solution.  It shows a foxpro
solution (Page 312 - Maintaining Links).  So I tried the
following code.
'******************************************************
' Code from Book - It Works I tried it
'******************************************************
 Set dbsCurrent = OpenDatabase
("C:\AccessJet\Samples\Chap08\Jet_Sampl97.mdb")
    dbsCurrent![LostLink] _
        .Connect = "FoxPro 3.0"
& ";DATABASE=C:\AccessJet\Samples\Chap08\LostLink"
    dbsCurrent.TableDefs![LostLink].RefreshLink
'******************************************************

'******************************************************
'  My Code
'******************************************************
    Dim db As Database
    Set db = CurrentDb

    db!aSa_AuditMaster _
        .Connect
= "DATABASE=C:\Tc_AuditData\Auditor_AuditData.mdb;TABLE=aS
a_AuditMaster"
    db.TableDefs!aSa_AuditMaster.RefreshLink

'******************************************************
'  Problem - Error Message #3170
'******************************************************

Received "Couldn't Find Installed ISAM" error message.  
Anyone have a solution?

Thanks;

Dean



Wed, 09 Feb 2005 08:32:03 GMT  
 Refresh Link
Hi Dean,

If you're connecting to a Jet database, you don't need to specify an ISAM
name, but you do need to include the semicolon delimiter, so the Connect
property should be:
  .Connect = ";DATABASE=C:\Tc_AuditData\Auditor_AuditData.mdb ...etc...

----
Simon Lewis


Quote:
> I Want to have my application look at two different
> Access Db depending on the function they are performing.

> In going thru the Microsoft Jet Engine Programmer's Guide
> (3.0) I found a (sort of) solution.  It shows a foxpro
> solution (Page 312 - Maintaining Links).  So I tried the
> following code.
> '******************************************************
> ' Code from Book - It Works I tried it
> '******************************************************
>  Set dbsCurrent = OpenDatabase
> ("C:\AccessJet\Samples\Chap08\Jet_Sampl97.mdb")
>     dbsCurrent![LostLink] _
>         .Connect = "FoxPro 3.0"
> & ";DATABASE=C:\AccessJet\Samples\Chap08\LostLink"
>     dbsCurrent.TableDefs![LostLink].RefreshLink
> '******************************************************

> '******************************************************
> '  My Code
> '******************************************************
>     Dim db As Database
>     Set db = CurrentDb

>     db!aSa_AuditMaster _
>         .Connect
> = "DATABASE=C:\Tc_AuditData\Auditor_AuditData.mdb;TABLE=aS
> a_AuditMaster"
>     db.TableDefs!aSa_AuditMaster.RefreshLink

> '******************************************************
> '  Problem - Error Message #3170
> '******************************************************

> Received "Couldn't Find Installed ISAM" error message.
> Anyone have a solution?

> Thanks;

> Dean



Thu, 10 Feb 2005 00:05:59 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Refresh Links

2. Using VBA code to refresh links

3. refresh link in code or other method

4. Refreshing Link to Excel97 Spreadsheet with Code

5. 97 Dev Handbook refresh links problem

6. Refresh Links

7. Refresh linked/imported tables programmatically

8. Refreshing links to data mdbs of unknown location 95

9. How to Refresh Links in a Run-Time Application

10. Refresh link of attach table

11. Refresh links in Access Database with VB 6.0 SP4

12. Refreshing linked tables in Access 2000

 

 
Powered by phpBB® Forum Software