[AccessD] Access 97 Migration to SQL

Jeremy,

Make a BE with the ODBC links to the SQL tables.

Link the existing FE to the BE, renaming the links to whatever table
names the FE is expecting.

It's a double link, so the longest possible way around, but it should
make all the pieces work together.

Good luck!

Liz

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jeremy Toves
Sent: Saturday, September 24, 2005 8:47 PM
To: AccessD
Subject: [AccessD] Access 97 Migration to SQL

I am migrating an Access 97 backend to a SQL server database.  The
previous Access table design included spaces in the field names.  I can
view the table in a pass through query, but can't view it with an ODBC
link.  If I change the fields names from spaces to underscores, the ODBC
link can view the SQL tables.  Has anybody experienced the following
problem?  Do you know where I can find some white papers on this issue?
 
Upgrading the Access version is not an option.  A quick turn around is
required, so I've been asked to find a solution other than changing from
spaces to underscores if possible.  Ideas?  
 
Thanks,
Jeremy
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com