User Profile

sherryj2 · Mar 4 '10, 10:56 PM

Wow. That was much simpler even. Yes you are right that all I needed to do was refresh (relink) the link for each table. I had searched all over Google for a simple way (that I could understand) which is how I came across msquared's "insight" on this site.

It amazes me that I spent the better part of two days trying to find the answer to that. I suppose it's time I just learned how to write some code, no?

...

sherryj2 · Mar 4 '10, 10:38 PM

NeoPa:

Wow, that totally worked. Thanks very much for your input! I knew it was simple, but I had no idea how to do it.

sherryj2 · Mar 4 '10, 10:32 PM

Great. I will give that a try right now.

sherryj2 · Mar 4 '10, 10:31 PM

NeoPa:

1: here are three connection strings used in the multiple back-end scenario:

DRIVER=SQL Server;SERVER=O urServer;APP=Mi crosoft Data Access Components;WSID =OSC-SHERJ1-9794;DATABASE=V egetation;Netwo rk=DBMSSOCN;Tru sted_Connection =Yes

DRIVER=SQL Server;SERVER=O urServer;APP=Mi crosoft Data Access Components;WSID =OSC-SHERJ1-9794;DATABASE=M onitoring;Netwo rk=DBMSSOCN;Tru sted_Connection =Yes

DRIVER=SQL...

sherryj2 · Mar 4 '10, 09:48 PM

Here is how I have modified the code that Mary provided (I only added the ODBC connection string):

Code:

Function relinkTables()

Dim tdf As DAO.TableDef

     For Each tdf In CurrentDb.TableDefs
        If Len(tdf.Connect) > 0 Then
             tdf.Connect = "DRIVER=SQL Server;SERVER=OurServer;DATABASE=sdeTrails;Trusted_Connection=Yes"
             tdf.RefreshLink
        End

...

sherryj2 · Mar 4 '10, 09:36 PM

Here is the code I mentioned I was using above:

http://bytes.com/topic/access/insigh...bles-using-vba

It works for a single back-end, but not for multiple backends...

User Profile

Profile Sidebar

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Relinking Access Linked Tables (Multiple Back-Ends)