Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
computerforce
Starting Member
10 Posts |
 Posted - 2006-08-17 : 06:10:48
|
| Have few MS Access frontends - mdb's, which has many SQL Server tables as linked tables, and MS Access tables inside. I have to migrate them (SQL Server tables) from one SQL server to another and to change linked tables properties in MS Access, related to MS SQL Server's tables. Anybody has idea how to do it? |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-08-18 : 06:38:31
|
| 1) Open the TableDefs collection2) Change the connect property accordingly3) Do a .RefreshLink call for every TableDefPeter LarssonHelsingborg, Sweden |
 |
|
|
|
|
|
Linked tables properties - where?