[dba-SQLServer] Access BE to SQL

You might want to pick up a copy of speed ferret, with that number of tables
you have to make sure that the field names in Access conform to SQL
field naming conventions. For example if you have a space in a field name
you might want to change to an underscore. Speed ferret will change
all occurrences in forms reports etc.

Liz Doering wrote:

>Susan,
> 
>Thanks for the confirmation.  I insisted Steve and I needed your book when this project was first discussed--a couple of years ago.  We've moved offices since then, but I know he hasn't gotten rid of it!
> 
>Liz Doering
>Senior Developer
>Symphony Information Services
>www.symphonyinfo.com
>763-391-7400 x802
>
>________________________________
>
>From: dba-sqlserver-bounces at databaseadvisors.com on behalf of Susan Harkins
>Sent: Fri 10/6/2006 7:45 AM
>To: dba-sqlserver at databaseadvisors.com
>Subject: Re: [dba-SQLServer] Access BE to SQL
>
>
>
>I'd also like to suggest an old book that Martin and I wrote together back
>in 2000 -- "SQL: Access to SQL Server" -- Martin wrote the half on migrating
>Access to SQL Server and did an excellent job. It's by Apress. If I had an
>author copy left, I'd just send it to you, but I don't.
>
>That book gets the best reviews and comments and everyone always compliments
>Martin on what a thorough job he did explaining the process.
>
>Susan H.
>
>John,  I don't know whether to smile or cry.  Perhaps I'll split the
>difference with a sigh.
>
>
>_______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>http://www.databaseadvisors.com
>
>
>
>
>
>  
>
>------------------------------------------------------------------------
>
>_______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>http://www.databaseadvisors.com
>
>  
>
>------------------------------------------------------------------------
>
>No virus found in this incoming message.
>Checked by AVG Free Edition.
>Version: 7.1.407 / Virus Database: 268.13.0/465 - Release Date: 06/10/2006
>  
>

-- 
Marty Connelly
Victoria, B.C.
Canada