Nicholson, Karen
cyx5 at cdc.gov
Fri Jan 7 09:06:16 CST 2005
He wants to build an SQL database to act as the backend, and use Access as the front end? Create the table in SQL server, create that Access database defining the odbc datasource. Then cheat like crazy to build SQL statements by creating queries in Access and viewing the sql code in design view of the query. Most of the time I can do this without having to pick up and sql book to get code. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Klos, Susan Sent: Friday, January 07, 2005 9:58 AM To: 'AccessD at databaseadvisors.com' Subject: [AccessD] Books on building SQL I have a co worker who is working in C++. He wants to use SQL to create a table in an Access Database. Can anyone on the list help? I am also looking for a book that will help us build SQL statements. Any ideas? Susan Klos Senior Database Analyst Evaluation and Reporting Florida Department of Education 850-245-0708 sc 205-0708 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com