General information
Category:
Database DAO/RDO/ODBC/ADO
>>
>>In one of your 2 databases, link the tables of your second. This way, you will only need to open 1 connection and you will be able to join queries very easily.
>
>I know I could do this, but at some point in the near future we are probably (hopefully) going to move away from an Access database to SQL Server or some such database. So I was hoping that there was a solution that I could do only in code.
>
>It is probably going to be easier to do it in the back end though.
>
>Pete
You can do the linking programmatically like so: (this works with ACC97)
Set thisdb = CurrentDB
thisdb.TableDefs(0).Connect = "FoxPro 2.6;DATABASE=C:\myDir\"
thisdb.TableDefs(0).RefreshLink
thisdb.TableDefs.Refresh
You may want to research this a little more. I remember that to do this I already had linked tables and with this I could just change the directory where I could find them.
This is from an old ACC mdb project that was converted over to VB.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only