When you say manages the data, can you be more specific? Does he change the data? Is he using view, reports, etc. that could be done in SQL Server?
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Goldstein, David Sent: Thursday, November 29, 2001 1:45 PM To: [EMAIL PROTECTED] Subject: Access Front-Ending SQL Server Database We currently have an application that is maintained by and used by one user using Microsoft Access. He generates reports from his database to manage the data and to mail the reports out to internal customers. We would like to migrate the database tables to SQL Server and have the reports that he mails out become web pages. It should be easy to migrate the database tables and data, and we'll use CF to write the web page reports that the customers will use, instead of receiving paper reports. The person who manages the data still wants to use Access to run his special analyses and do data maintenance through Access. Is this do-able? Can Access front-end SQL Server database tables? Are we likely to have to make many changes to the Access reports or forms? (The sophistication of what's in Access is mid-level, at best.) What stumbling blocks might we hit? Thanks, -- David ------------------------------------------------------------------------- This email server is running an evaluation copy of the MailShield anti- spam software. Please contact your email administrator if you have any questions about this message. MailShield product info: www.mailshield.com ----------------------------------------------- To post, send email to [EMAIL PROTECTED] To subscribe / unsubscribe: http://www.dfwcfug.org ------------------------------------------------------------------------- This email server is running an evaluation copy of the MailShield anti- spam software. Please contact your email administrator if you have any questions about this message. MailShield product info: www.mailshield.com ----------------------------------------------- To post, send email to [EMAIL PROTECTED] To subscribe / unsubscribe: http://www.dfwcfug.org
