Rebuild Links from Access 2003 to SQL server 2005 using Vs.net app

E

Ed Warren

Problem statement:

I have many legecy MS Access front-end applications. Each is linked to a
small set of sql server 2005 databases (3)

The database structure in each sql server instance is the same for each
database. Of course the rows are different. However the sql server instance
changes (e.g. sqlTest, sqlProduction)

It's not as simple as referring to them as "local host" and running the code
only on the appropriate machine.

I am trying to write a vs.net application (note: not vba) that will read
the current:

tbl.Properties("Jet OLEDB:Link Provider String").Value

for each table and then update the link to the new desired link using a
string variable.

tbl is an adox.table

I have all this working the way I want within a loop that examines each
msaccess data file, captures the string value of the tbl.properties above.

However, I find the object:
adox.table.properties is read only.

the line:
tbl.Properties("Jet OLEDB:Link Provider String").Value = strNewConnection

I have also tried creating a new adox.property (ThisProperty)
then assigning a value to it with no luck.

fails with object read only error.

Sooo, I'm so close, yet soooo very far??
I have all the little bits together, just not sure how to set the value for
the property.

Any advice would be greatly appreciated.
 
Top