Re: Upgrade Access backend to SQL database
- From: "Granny Spitz via AccessMonster.com" <u26473@uwe>
- Date: Fri, 06 Oct 2006 00:52:43 GMT
Simon J wrote:
I understand that I will achieve better performance if I link my Access front
end to SQL tables rather than the current Access table structure. Could you
please advise whether this is a reasonable assumption
It's not a reasonable assumption. If the database architecture is a poor one
in Access, switching to SQL Server with the same architecture usually won't
improve performance significantly, but it *will* increase costs significantly.
If the database is well designed in Access and then upgraded to SQL Server
with that same design, and the queries are altered so that the database
server is doing the work, not the client, and the database server has the
same load and networking capabilities as the Access database, and it has
sufficient hardware (cpu, multi-threading, memory, disk space, etc.), then
you can expect some significant gains in performance.
Will
my front end queries, functions, reports and forms still run correctly?
They might. But even if they do, for best performance you're going to want
to alter these so that the database server is doing the work and only the
relevant data is being pulled across the network to the client.
If
not is there an article on upgrading these too?
Hon, it's not an article, it's a whole book. 864 pages. Read Mary Chipman's
and Andy Baron's book, "Microsoft Access Developer's Guide to SQL Server."
It's a five-star book at Amazon.com for a very good reason.
--
Message posted via http://www.accessmonster.com
.
- Prev by Date: Re: Upgrade Access backend to SQL database
- Next by Date: Re: SaveAsText - Run-time error 2002 - Function or feature not installed with this version of Access
- Previous by thread: Re: Upgrade Access backend to SQL database
- Next by thread: Re: Upgrade Access backend to SQL database
- Index(es):
Relevant Pages
|
