Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 2 / May 2008

Tip: Looking for answers? Try searching our database.

Access + Linked Table, some times blocked

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Paulino Padial - 08 May 2008 16:36 GMT
Spanish:
Tengo una tabla vinculada a sql server ( con mysql tb ocurre ), con el
driver de sql server de microsoft.
La tabla tiene unos 300.000 registros.

Mi problema es el siguiente, cuando estoy navegando por la vista de tabla,
llega un momento, en el que se me bloquea el access y se queda en no
responde.
Cuando hay menos registros en una tabla, el tiempo es mucho menor, pero no
se porque ocurre, si son buffers que se llenan... comunicacion con el
servidor... o que

¿ A alguien le ha pasa/pasado ? alguna solucion?

English:

Hi, have a linked table with sql server ( 2k ) using microsoft sqlserver
odbc standart.
table have about 300.000 rows ( but with less rows, is the same )

I have a trouble: when open table view, and navigate with keys across the
columns and rows, sometimes access frozen.
I dunno what happens... any have some idea?
Alex Dybenko - 09 May 2008 07:46 GMT
Hi,
this is expected behavior, it took some time for access to load more rows
from SQL server. Furthermore - browsing records like this is ok for jet
tables, but not to SQL tables, you need to give user ability to make search
on records and show a smallest subset

Signature

Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

> Spanish:
> Tengo una tabla vinculada a sql server ( con mysql tb ocurre ), con el
[quoted text clipped - 19 lines]
> columns and rows, sometimes access frozen.
> I dunno what happens... any have some idea?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.