Re: Performance of ODBC

and again..

when you use MDB against linked tables; you'll have awful performance..
because it SCANS THE WHOLE TABLE AND DOWNLOADS IT BEFORE STARTING A
SEEK

ADP doesn't have this same problem; if you request 20 seconds from SQL
Server you get 20 records.

again, to simplify

if you send a request fom MDB to SQL Server.. saying 'give me 20
records' MDB sits there and says 'I dont know wtf a database is; let me
bring this WHOLE TABLE across the network, piece through it.. and
finally find the 20 records that im looking for'

lol

MDB Is completely obsolete; spit on anyone that still uses it


Vadim Rapp wrote:
Most likely this is a problem with your or your ISP network configuration,
most likely with DNS. I just tried to connect from home computer to sql
server running at my work computer and published on the firewall; both
Access through odbc and vb6 program were able to connect and extract the
data practically instantly..

Did you try tracert to your server?

Also, if you close your Access and then reopen and reaccess the server data,
is it still slow? perhaps sql server is autostarted when you connect first
time, or maybe the database is autoclosed and needs to reopen?

Vadim Rapp

.

Relevant Pages

  • Re: DAO 64 Bit
    ... MDB Dateien mit einem 32 Bit Prog/Service nach Eintreffen immer automatisch ... in einen SQL Server hochladen. ...
    (microsoft.public.de.vc)
  • Re: Merge Agent fails to connect to mdb
    ... I have created a new Linked Server def using the UNC reference to the mdb. ... I again get the msg below in my Merge Agent when using the Linked ...
    (microsoft.public.sqlserver.replication)
  • Re: New Technoligy with Jet engine (terminal service and MDB)
    ... You've had answers from two intelligent and experienced database developers ... Yes, you can continue to use an MDB, by adding ODBC, and linking the tables. ... server back end, you are going to need to know the server, anway (there are ... and understood why sql is better. ...
    (comp.databases.ms-access)
  • Re: VBA Programming - HELP
    ... Of course, when I am working on an ADP, with ADO, using SQL Server, I have ... an MDB to do the things that are easier. ... Server DBA implementing the necessary table. ... Of course, if the back end is SQL Server or some other Server DB, ...
    (microsoft.public.access.modulesdaovba)
  • Re: Guide for switching to .ADP from .MDB
    ... After struggling with the .adp for 2 days I have determined ... >decided to go with .mdb with linked tables. ... Performance problems with MDB front-ends to MS SQL Server are rarely a result ... generating the tables on the server, then hand-tweak the script before running ...
    (microsoft.public.access.adp.sqlserver)
Loading