Dan Waters
dwaters at usinternet.com
Fri Feb 1 11:41:30 CST 2008
Arthur, I am soon going to convert all my systems from A2003 FE/BE to A2003 FE / SQL Express 2005 BE. But your email says, "It works, sort of." Could you elaborate on this? You've got me nervous! Thanks, Dan -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller Sent: Friday, February 01, 2008 11:14 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] SQL vs Access Rocky, As Susan wrote, SQL Express is a viable option. The IT department's point about backup and restore is well-taken, too. Since they already have a backup strategy in place, adding one more DB to it should be trivial. Then you (and they) can forget about it, except for the verification step, which they probably have automated already for their other databases. Were I you, I would acquiesce immediately on this one. You have nothing to lose but credibility if you fight them, and an opportunity to work with SQL Express or SQL Server. Given this path, you should be concerned about which version and format you'll be using. IMO the best combination is A2K or A2K3 using ADP format to talk to a SQL 2000 db. If you try talking to a SQL 2005 db from either of those Access versions, it works, sort of, but you miss a lot of the goodies due to the internal restructuring of the SQL db format. OTOH if you're going to use A2K7 then it's a good fit with SQL 2005. hth, Arthur On Fri, Feb 1, 2008 at 12:03 PM, Susan Harkins <ssharkins at gmail.com> wrote: > You might find SQL Server Express easier to work with than Access -- they > might be willing to make that compromise with you. > > Susan H. > > > > Hi Rocky > > > > As he has several running servers and a proven backup scheme, he has a > > valid point. > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com