I'm using Access to view data from an Oracle 9i database. When I try
to link an Oracle database, the PC appears to Hang before finally
presenting the list of tables to choose from. It's a large Oracle
Database (lots of objects) and I know it's pulling every object over to
make up this list. It may take as long as 3 minutes of waiting before
seeing the table list. Is there a workaround/configuration setting for
this? 2 2741
3 minutes is a long time, but I seem to remember having to wait quite a
while for the object listing with databases that had a lot of objects.
Do you need access to all of those objects? If not, you might try
associating only a limited set with the user that you're using for
accessing the Oracle database.
Also, this is an operation that is normally done only once, unless
you're deleting the links after you create them. I wonder why you
would need to do it repeatedly.
If you do need to do it repeatedly and you can't solve the problem any
other way, you could code your own utility that gets the list of the
objects (tables, views) from one of the system tables. The user could
click on each desired object and you could create a linked tabledef in
code with the appropriate connection string.
Bill E. bd*****@hotmail .com wrote: I'm using Access to view data from an Oracle 9i database. When I try to link an Oracle database, the PC appears to Hang before finally presenting the list of tables to choose from. It's a large Oracle Database (lots of objects) and I know it's pulling every object over to make up this list. It may take as long as 3 minutes of waiting before seeing the table list. Is there a workaround/configuration setting for this?
This is a bother for me too, though I tend to use PTQs and DAO most of
the time, so don't bother with linking tables unless I am doing Oracle
database administrative type tasks.
One thing that may or may not help, might be to set up an Oracle user
with just the tables that you want. Going through that user instead of
the sysadmin user or whatever might be faster.
Other than that, I don't know what to tell you.
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Phil S |
last post by:
I used the Migration Workbench for Oracle 9.2 Client to migrate the
tables in an Access 2K back-end database to Oracle. (The Migration
Workbench is intended to automate the process of migrating tables from
Access to Oracle.) Following the migration, when I try to link the
Oracle table to the Access front-end using Oracle ODBC Driver, I have
to either select one or more fields in the Oracle table as key fields
or not have any key fields. ...
|
by: Mark P |
last post by:
I have a bit of vb code that uses Tables.Append to programatically
link tables from Oracle and DB2 datasources. The problem I am having
on some client machines is that the link will take anywhere from 1 to
3 minutes to link the table. When I manually link the tables,through
Access, it takes no time at all. Note that only certain client have
the problem, and the problem will sometimes go away.
These clients will usually get an ODBC Call...
|
by: anand |
last post by:
Hi,
I have an Access 2000 database, which contains some native tables,
and some linked tables which belong to an ORACLE database, through
ODBC.
Using VB.NET, I am trying to fetch some data by joining two tables,
one table native to the mdb file, and another belonging to ORACLE.
I am using a connection string to connect to mdb file:
|
by: premmehrotra |
last post by:
I am using Access 2000 and Oracle 9.2.0.x on a Windows 2000. I have
setup Oracle 9.2 ODBC Driver (I have not yet figured how to set
Microsoft's Oracle ODBC driver).
I am exporting a table from Access to Oracle and I get following error:
ODBC Call Failed:
ORA-12571: TNS Packet Failure Error
I see table and its indexes created in Oracle. However, there are no
|
by: John |
last post by:
I need to upsize my Access 2002 "database" to a larger database. I
would like to use Access projects to manage the database. With this
preference, it would seem MS SQL Server 2000 is the ideal way to go.
Nothwithstanding scalability, performance, pricing, my question is
this: what are the distinct advantages MS SQL Server have over
Oracle when used in conjunction with Access? What are the drawbacks, if
any, to using an Access project...
| |
by: lucy.randles |
last post by:
We're implementing automated logins to Oracle, using the users NT
password. However, when trying to link in tables through the ODBC
datasource in MS Access, we're encountering errors. Because users
local tables are kept on the domain, the path comes up as
domainname/username.tablename. It appears that Access doesn't like the
/, and therefore falls over. When linking tables that aren't proceded
by the / it works fine.
Is there any...
|
by: egoldthwait |
last post by:
I need to convert a 17mb access 2000 db to Oracle and house it in a
Citrix farm. The issue: we have never converted an Access Db to Oracle
but can probably use Oracle's Workbench to assist with this. Also - the
citrix folks do not want us to keep the FE in Access as the queries and
other activities consume a lot of power. The users will be in 3
different offices across the globe all accessing the 1 Oracle DB in
Citrix.
Does anyone have...
|
by: zwasdl |
last post by:
Hi,
I'm using MS Access to query against Oracle DB via ODBC. Is it
possible to use HINT in Access?
Thanks,
Wei
|
by: MeeMee |
last post by:
Hi,
I am trying to get some tables from the oracle 10g database that I have on my machine into an access database. I used the Get External Data option in access and followed the steps in this tutorial:
http://aspalliance.com/893_Creating_an_MS_Access_2003_Front_End_for_an_Oracle_10g_Express_Edition_Database.2
For example, I tried getting the Employees and Departments tables from the hr schema. I was able to link them successfully, however...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |