[AccessD] Access 97 Migration to SQL

I'm taking a look into that.  I noticed another Access database for a different customer with a SQL backend.  It works with the spaces in the field names.  I'm not sure if that is a driver issue or what.  I'll check out the search and replace.  I'll have to load the tables with underscores and run the search and replace to update field references in all of the database objects. 
 
Thanks,
Jeremy

 

Fred Hooper <fahooper at trapo.com> wrote:
I'd say that the quickest solution would be to use a search/replace program
for the table names (they don't work in the code, so you'd need to do that
with Access' search/replace). The only one I have experience with is Speed
Ferret which also works with SQL Server, although it's probably the most
costly. This would change all the table references inside queries, reports,
etc.

Fred Hooper

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jeremy Toves
Sent: Saturday, September 24, 2005 9:24 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