ra*@aic.net.au (Ray) wrote:
I can code the RefreshLinks sample to do it all (I have versions that
do Access refreshes or SQLServer refreshes, with the ODBC string and
all), but will it allow me to use and swap the same TableDef connect
string for either the Access version of the table or the 'upsized'
SQLServer version of the same table?
Yes, I've done this in the past although I never finished the upsizing process on
that database.
1) I much prefer DSN-Less connections as it is one less thing for someone to have to
configure and one less thing for the users to screw up. This is also better for
Citrix/TS farms where each individual system would have to have a DSN created and
maintained.
Using DSN-Less Connections
http://members.rogers.com/douglas.j....LessLinks.html
ODBC DSN-Less Connection Tutorial Part I
http://www.amazecreations.com/datafa...m&Article=true
HOWTO: Use "DSN-Less" ODBC Connections with RDO and DAO
http://support.microsoft.com/?id=147875
ODBC DSN Less
http://www.able-consulting.com/MDAC/...BC_DSNLess.htm
2) The SQL Server tables will have dbo. as the table name. You can strip that out
when creating the Access table name.
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm