If that is all he is doing, a CFGRID object could give him very simple edit capabilities. This is far more practical in CF 5 than in previous version.
Just in addition to the good replies you have already gotten. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Goldstein, David Sent: Thursday, November 29, 2001 1:54 PM To: [EMAIL PROTECTED] Subject: RE: Access Front-Ending SQL Server Database He is generally using the table view of data in Access to update the data. (He occassionally adds or deletes a record. Most of the new data is imported from a CSV file generated from another source.) The reports are done from the Reports part of Access. We won't give him Enterprise Manager. Also, since it's only one user who edits the data and who is happy using the simple interface of Access, we don't want to go through the time, expense, testing, etc. to do web pages to allow him and him alone to view the data in tabular format or make the editing changes. -- David -----Original Message----- From: Dave Cahall [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 29, 2001 1:59 PM To: [EMAIL PROTECTED] Subject: RE: Access Front-Ending SQL Server Database 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 ------------------------------------------------------------------------- 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
