W
Wafnda at COT
What are the benefits of upsizing Access to SQL server?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
Alex Dybenko
Hi,
You can make some data processing on server, using stored procedures, etc,
and bring only results to client. So you reduce network traffic and
processor/memory resouces on clients. You can use triggers, which are not
availabel in Access DB.
But you have to consider this if you have a lot of data (> 100-200 MB)
and/or many users (> 15-20), else better use Access database
You can make some data processing on server, using stored procedures, etc,
and bring only results to client. So you reduce network traffic and
processor/memory resouces on clients. You can use triggers, which are not
availabel in Access DB.
But you have to consider this if you have a lot of data (> 100-200 MB)
and/or many users (> 15-20), else better use Access database
O
Ofer
Have a look at this sites
http://www.databasejournal.com/features/mssql/article.php/1490561
http://www.aspfaq.com/show.asp?id=2214
And you can find alot more sites that will explain the difference between
Access to SQL Server, using google.com
http://www.databasejournal.com/features/mssql/article.php/1490561
http://www.aspfaq.com/show.asp?id=2214
And you can find alot more sites that will explain the difference between
Access to SQL Server, using google.com
D
David C. Holley
Numerous, definetly worth the cost. Give me triggers or give me death.
D
David C. Holley
I would add in there that if you have multiple tables that are updated
in a single transaction (eg a reservation system*) that SQLServer can be
worth it because the triggers can be setup to manage all of that, as
opposed to having to code the SQL statements
David H
*where the following tables have to be updated
reservations table
inventory summary table
pre-assigned inventory table
folio header table
deposit information table
group master block table
additional names table
(not that I know anything about property management systems)
in a single transaction (eg a reservation system*) that SQLServer can be
worth it because the triggers can be setup to manage all of that, as
opposed to having to code the SQL statements
David H
*where the following tables have to be updated
reservations table
inventory summary table
pre-assigned inventory table
folio header table
deposit information table
group master block table
additional names table
(not that I know anything about property management systems)
T
Tim Ferguson
"=?Utf-8?B?V2FmbmRhIGF0IENPVA==?=" <Wafnda at
[email protected]> wrote in [email protected]:
It keeps Microsoft shareholders happy...
Tim F
[email protected]> wrote in [email protected]:
What are the benefits of upsizing Access to SQL server?
It keeps Microsoft shareholders happy...
Tim F
D
David C. Holley
Bill can by another car.
Tim said:"=?Utf-8?B?V2FmbmRhIGF0IENPVA==?=" <Wafnda at
[email protected]> wrote in [email protected]:
It keeps Microsoft shareholders happy...
Tim F
T
Tim Ferguson
Bill can by another car.
Does Bill Gates drive? I always assumed that he'd have laid-on corporate
transport if he wanted to go anywhere; and with that hippy Green Computing
Environmental stuff I figured he would be cycling the rest of the time.
All the best
Tim F
D
Douglas J Steele
Tim Ferguson said:Does Bill Gates drive? I always assumed that he'd have laid-on corporate
transport if he wanted to go anywhere; and with that hippy Green Computing
Environmental stuff I figured he would be cycling the rest of the time.
Obviously you've never heard about the trials & tribulations he's had with
his Porsche 959! <g>
http://www.jalopnik.com/cars/announ...ed-porsche-959-and-some-gadget-guy-029211.php
T
Tim Ferguson
Obviously you've never heard about the trials & tribulations he's had
with his Porsche 959! <g>
<vbg>
Tim F
D
David C. Holley
Didn't he buy Porsche and force the auto engineers to install WindowsXP
as the car's opsystem?
as the car's opsystem?