Wortz, Charles
CWortz at tea.state.tx.us
Wed Mar 12 13:01:20 CST 2003
Susan, It my situation, the app reloads the data whenever it is opened. My users normally only open the app once in the morning and stay in it until quitting time when they close it. Now, when they want to get any updates made since the morning, they close the app and reopen it. I could have put a Refresh button on the main form, but that would have consumed precious screen space for a rarely used feature. Charles Wortz Software Development Division Texas Education Agency 1701 N. Congress Ave Austin, TX 78701-1494 512-463-9493 CWortz at tea.state.tx.us -----Original Message----- From: Susan Zeller [mailto:szeller at cce.umn.edu] Sent: Wednesday 2003 Mar 12 12:29 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