MS says that all tables should live in SQL (for performance reasons)

  • Thread starter Thread starter a a r o n . k e m p f
  • Start date Start date
make sure that all Access tables get moved to SQL Server to increase
performance. Creating queries against a mix of Access (Jet) and SQL
Server using linked tables can be very resource-intensive.

http://technet.microsoft.com/en-us/library/cc917601.aspx
Click to expand...

"Migrating Your MS Access Database to MS SQL Server 7.0
Updated : July 19, 2001"

Just a little out of date.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/
 
message
make sure that all Access tables get moved to SQL Server to increase
performance. Creating queries against a mix of Access (Jet) and SQL
Server using linked tables can be very resource-intensive.

http://technet.microsoft.com/en-us/library/cc917601.aspx
Click to expand...

You do realize that the article is 9 years old and contains advice which may
not have been the best even then? SQL-Server 7 was quickly replaced by those
of us developers who very quickly realized how much better SQL-Server 2000
was. Since then there have been 5 versions of both Access and SQL-Server.
 
message
make sure that all Access tables get moved to SQL Server to increase
performance. Creating queries against a mix of Access (Jet) and SQL
Server using linked tables can be very resource-intensive.

http://technet.microsoft.com/en-us/library/cc917601.aspx
Click to expand...


The article is about procedures for upsizing an Access database to a SQL
Server back-end. The quoted passage is a caution to avoid joining linked
SQL Server tables and local Jet tables in queries, as that will be very
inefficient. It is in no way a statement that all tables in all Access
applications should be kept in SQL server.
 
I think everyone here thinks SQL Server is a great product.
I think everyone here also thinks Microsoft Access is a great product.

and yes linked tables (to SQL server data) used in Access is not always the
best way to go.
Sometimes pass-thru queries are the way to go, sometimes Access is not the
right tool.

However there still are a variety of applications that can be built in
Access.

Aren't there Microsoft SQL server newsgroups you should be posting at, you
seem to
be fixated on SQL Server and how it should be used for everything? If you
have stock
in Microsoft they make money off Microsoft Office as well as SQL Server so
no worries.

You could go after the .net developers and try and make sure they use SQL
Server or those PHP people
using MySQL. Just a thought?

--
Mark Andrews
RPT Software
http://www.rptsoftware.com
http://www.donationmanagementsoftware.com

message
news:2966ac44-e6f1-422f-b5e2-946bf7f8b146@n11g2000prh.googlegroups.com...
 
I think that linked tables are just flat out stupid stupid stupid
as is anyone who uses a product that corrupts data

most of the mental midgets around here complain about 'not having
local storage' as an option for ADP

and I just think that it's sad that people think that they're smarter
than Microsoft
 
ADP ****ing rocks

sorry.. but it's what I believe in.

Maybe you should go and find Excel people and tell them about your
mini-sized database (that won't effectively hold 1m records - even
excel can do that)
 
Dirk

you're a ****ing tard

this is exactly what Microsoft says: 'It is in no way a statement that
all tables in all Access
applications should be kept in SQL server. '

-Aaron
 
You did not address the out-of-date article you quoted, nor that you quote
out of context to support your point of view that was/is not supported by
the statements in that article.

Actually, most of those around here (whatever their mental height may be)
point out that the Access team at Microsoft recommends MDB or ACCDB wtih
linked tables as the method of choice... the Microsoft push for ADP is as
old as the out-of-date article you cite.

So you are sad about yourself... thinking that you are smarter than
Microsoft? But, how thoughtful it was of you to, once again, give us the
benefit of your superior knowledge and wisdom.

Larry Linson



message
I think that linked tables are just flat out stupid stupid stupid
as is anyone who uses a product that corrupts data

most of the mental midgets around here complain about 'not having
local storage' as an option for ADP

and I just think that it's sad that people think that they're smarter
than Microsoft
 
OUT OF DATE?

SQL SERVER HAS ALWAYS BEEN SUPERIOR, KID

TIRED OF CRASHING? MOVE TO SQL SERVER / ADP
TIRED OF LINKING? MOVE TO SQL SERVER / ADP
TIRED OF CORRUPTION? MOVE TO SQL SERVER / ADP
TIRED OF DATASILOITIS? MOVE TO SQL SERVER / ADP
 
a a r o n . k e m p f @ g m a i l . c o m said:
OUT OF DATE?
Click to expand...
SQL SERVER HAS ALWAYS BEEN SUPERIOR, KID
Click to expand...
TIRED OF CRASHING? MOVE TO SQL SERVER / ADP
TIRED OF LINKING? MOVE TO SQL SERVER / ADP
TIRED OF CORRUPTION? MOVE TO SQL SERVER / ADP
TIRED OF DATASILOITIS? MOVE TO SQL SERVER / ADP
Click to expand...

There are many occasions when it is appropriate to store one's data in a
Server database, just as there are many (equally or more) occasions when it
is appropropriate to store one's data in a Jet or ACE database. Intelligent
DBAs and developers have no difficulty determining which they should use.

SQL Server is a good server database; so are many other server databases.
ADP is no longer recommended by the Access team at Redmond as the front-end
of choice for SQL Server. Instead they recommend using MDB or ACCDB and
linking to the SQL Server database via ODBC, which approach will also work
nicely for those organizations which have chosen some other ODBC-compliant
database as their corporate or company standard.

The citation has been posted here many times. Shouting by typing all caps
does not make your claims valid.

Larry Linson
Microsoft Office Access MVP
 
The citation has been posted here many times. Shouting by typing
all caps does not make your claims valid.
Click to expand...

It seems to work for the Republicans in Congress.
 
Back
Top