Thread: edit live sql data
March 30th, 2006, 10:50 AM #1
- Join Date
- Jun 2004
- south jersey, USA
edit live sql data
I have a sql express database with a couple tables of information. I have a user modifying one of these tables with a data access page using Office Web Controls.
To backtrack a bit, the sql db used to be an access db. The same user modifying the data the same way. I also had a asp page making odbc calls to the access db to lookup information. But if the data access page was open, the odbc page would error. So i moved the data to sql.
Now, I'm getting ready to setup an application to make odbc calls to the sql db. I still want the user to modify the data using the DAP. Should I allow the user to modify the live data used for the app or should I make a copy of the data evertime its updated?
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By cdavis in forum Storage RelatedReplies: 5Last Post: March 14th, 2013, 01:17 PM
By vass0922 in forum Webmastering and ProgrammingReplies: 2Last Post: October 16th, 2003, 10:03 PM
By Nerry in forum Technical SupportReplies: 1Last Post: July 30th, 2003, 09:02 AM
By Jimmy319 in forum Technical SupportReplies: 0Last Post: July 13th, 2003, 07:45 PM