Susan Zeller
szeller at cce.umn.edu
Wed Mar 12 12:28:49 CST 2003
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