DAO/ADO utilities and SQL Server

[Sirocco]

I inherited an Access 2000 mdb database about 2 years ago, and will be
upsizing to a SQL Server later this year. A utility program is run when
the db is opened to (re)attach the tables. About 1/10 of the code is below.
When I upsize the tables to SQL later this year, and use an Access 2003
front end (the Access 2003 front end is already in use), will I need to
convert it to its ADO equivalent, or will the utility even be necessary?
By the way I'm just upsizing the tables, not the queries, forms or reports,
i.e. I'm not making an adp file. Are there any commercially available
utilities for this purpose (to relink the tables to the SQL backend), if
it's even necessary?

Many thanks in advance.

Do Until snpAttachedTables.EOF
Set tdfTable = dbCurrent.TableDefs(snpAttachedTables!Name)
tdfTable.Connect = ";DATABASE=" & strDefFileName
tdfTable.RefreshLink
snpAttachedTables.MoveNext
intCount = intCount + 1
varStatus = SysCmd(SYSCMD_UPDATEMETER, intCount)
Loop

 

[Douglas J. Steele]

http://www.mvps.org/access/tables/tbl0010.htm at "The Access Web" shows how
to relink if you're using a DSN.

http://members.rogers.com/douglas.j.steele/DSNLessLinks.html shows how to do
it without a DSN.