What's the reason for the local tables? I recall having to do this due to locking issues or when a user needed exclusive access to the database. With SQL Server, that should not be a problem. If you really need to keep separate copies, why not issues a SP during login and copy the data to another SQL Server db?
-----Original Message----- From: Botts, Tom [mailto:[EMAIL PROTECTED] Sent: Thursday, March 17, 2005 9:00 AM To: CF-Talk Subject: Best Practice I am converting an old Access application. When a user opens the application it refreshes data from a remote machine to the local tables. What would be the best practice to use for the web app. I plan on using sql instead of access. Each person that logs in would get their own version of the table? What happens if one person is running the app and another person logs in and refreshes the table with new data ? thanks for any tips, Tom. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199132 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
