Brad Marks
BradM at blackforestltd.com
Tue Mar 25 10:36:52 CDT 2014
All, Thanks to everyone who posted their ideas and insights. I appreciate it. I am curious if anyone has worked with Windows Azure SQL Database. I have briefly looked at this approach and I am curious if it would be a good approach for a small firm. Thanks, Brad -----Original Message----- From: accessd-bounces at databaseadvisors.com on behalf of Gary Kjos Sent: Tue 3/25/2014 8:36 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] New Database Table - How to Proceed I think that people who haven't actually used Access often have a bias against it. The "risk" of an Access DB would be possibly a corruption issue that couldn't be recovered from excepting reverting to a previous backup. With the amount of updates that would seem to not be a huge risk for your application. Assuming that these updates could be reentered somehow and are not being captured ONLY in the database without other documentation. If I were in your place, I would be using an Access backend at least to develop it. I would plan on having backups made at minimum every day with a rotating cycle of daily/weekly/monthly backups so that if some catastrophic issue was encountered you could go back generations if necessary as sometimes there could be an undetected error with something that you don't even realize there is a problem with. Sql Server Express would be my upgrade plan or where the final version would reside once the development in Access was complete or near to it. During development you are likely to be fiddling with additional fields and perhaps more tables etc. A single table? Really? Is that a well thought out design? And making those changes in the tool you are most familiar with will speed your development. On the other hand that would also be a good opportunity to learn the procedures to do this in SQL Server too. Is this a publicly held company? If you are subject to audits using Access for a business critical application might be looked at suspiciously where SQL Server, even the Express version would be better accepted by outside auditors. Good luck! GK On Mon, Mar 24, 2014 at 4:15 PM, Brad Marks <BradM at blackforestltd.com>wrote: > All, > > I have a question, but first I need to explain a little background. > > -- Gary Kjos garykjos at gmail.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- This message was scanned by ESVA and is believed to be clean. Click here to report this message as spam. http://h0stname/cgi-bin/learn-msg.cgi?id=9CDE32864E.1C65F