[AccessD] Access 97 Migration to SQL

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








More information about the AccessD mailing list