This is easy to do. You will first nee to create a DSN on the users computer. Then give the user an account on the SQl server, then go into MS Access, create a new database, then link to the tables. Then you would go and import the queries, forms, and reports into the new datbase. Also, when you link the SQL tables, they will all be prefixed with dbo_. Rename all the tables so that the queries and reports work. We do this here at Baylor all the time and we have not had any issues to date. And the users are using a mixture of Acess 97, 2000 AND XP, hitting SQl 6.5, 7.0 and SQl 2K machines on various clients (Windows95, 2000 and XP). ---------- Original Message ---------------------------------- From: "Goldstein, David" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Thu, 29 Nov 2001 13:45:11 -0600
>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
