-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Microsoft does not recommend opening linked tables by using the table
object in the database window. Queries are better - especially
queries with criteria (so as not to return the entire contents of a
table).
I've found that relinks/refreshes for remote ODBC tables sometimes
take over a minute per table on LANs/WANs.
The description of the results of your simple query seems to indicate
a slow response from Oracle or the Cache size needs to be changed.
Cache Size determines how many records are returned from the server.
See the Access help article on "CacheSize Property" (both DAO & ADO -
ADO info is in the VBA help articles "Cache size").
Also, in the past I believe there were some problems using the Oracle
ODBC drivers. I believe it was recommended that the Microsoft drivers
be used instead of the Oracle drivers. The Microsoft drivers should
be listed under the ODBC Administrator dialog box "Drivers" tab.
HTH,
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/AwUBQARMa4echKqOuFEgEQKkFwCgkRoA4B71csMqN25AtComaE c3AQgAn2Jt
k+lz+p7/ZVs3EGhqfJPGT+xK
=GlOb
-----END PGP SIGNATURE-----
Ian wrote:
We are currently experiencing problems with our Access XP database. We
are using access as the front-end and are connecting to Oracle 7.3 via
ODBC. Our users are running Win 98 and Win Xp.
We are currently using Oracle73 drivers ver:1.15.03.01 File:
SQ032.73.dll Date:18/06/1996.
The Problem,
I can re-link the Oracle tables and open them within access, However
the tables take around a minute to open.
When I try to run a query I receive an error,
ODBC – Call Failed
[Microsoft][ODBC Driver Manager] Memory Allocation failure (#0).
The query I am running is only a simple query, however when I make it
even simpler i.e. (Select * from table) the results are displayed but
then vanish when you scroll down the page leaving #Name? displaying in
every field.
I have just downloaded Oracle7 ODBC Driver Version 2.5.3.1.7 but am
still getting the same problem.
Any ideals or suggestions would be great. Many thanks in advance,
Ian