Djabarov, Robert
Robert.Djabarov at usaa.com
Wed Mar 12 12:58:00 CST 2003
Actually, allowing users to create queries in Access against the base tables is as dangerous as allowing them to create views. Why can't you set a rule that users must submit specs to you for desired views and then you create them, using best practices of course? Robert Djabarov Senior SQL Server DBA USAA IT/DBMS ? (210) 913-3148 - phone ? (210) 753-3148 - pager -----Original Message----- From: Susan Zeller [mailto:szeller at cce.umn.edu] Sent: Wednesday, March 12, 2003 12:29 PM To: dba-SQLServer at databaseadvisors.com Subject: [dba-SQLServer]Not allowing users to create views -- onto an alternative Okay, well the jury's verdict is clear on the issue of letting users create views in my db -- I've lost my marbles. So, now that I've been set back on the right track.... So, I think I'll follow what Charles outlined and create an mdb for them to play around in. Can I create a DTS in SQL Server that will refresh the data I want into the access file? Is that how you go about keeping a fresh copy for your users? Can I execute the DTS from within Access? The users may need to have refreshed data several times a day. --Susan Susan B. Zeller Office of Information Systems College of Continuing Education University of Minnesota 306 Wesbrook Hall 77 Pleasant Street SE Minneapolis, MN 55455 Phone: 612-626-4785 Fax: 612-625-2568 _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com