Liz Doering
ldoering at symphonyinfo.com
Mon Sep 26 09:08:16 CDT 2005
Jeremy, That's what I get for replying with a severe head cold. Fred's way is your best bet. Good Luck! Liz -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jeremy Toves Sent: Sunday, September 25, 2005 10:46 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Access 97 Migration to SQL Liz, My email was a little confusing. The naming problems are with fields in the table. The table names are fine. I appreciate the effort. Thanks, Jeremy Liz Doering <ldoering at symphonyinfo.com> wrote: 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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com