RE: Access and Linked tables to Oracle

Hi Tim,

>From your descriptions, I understood that you would like to why your new
database

Generally, performance issues can be caused by various factors, and it is
difficult to locate the root cause in a newsgroup thread. If the issue
still exists after you have used the troubleshooting steps above, to
efficiently troubleshoot a performance issue, we recommend that you contact
Microsoft Customer Service and Support and open a support incident and work
with a dedicated Support Professional.

To obtain the phone numbers for specific technology request please take a
look at the web site listed below.
http://support.microsoft.com/default.aspx?scid=fh;EN-US;PHONENUMBERS

For now, I would like to collect the following information narrowing down
this issue
1) What's the differenct between your old database and new database? (for
example, Access 97 and Access 2000?)

2) Make sure you are using the latest MDAC
If you are using XP SP2, you could ignore this point, otherwise, MDAC 2.8
is available in the link below
http://www.microsoft.com/downloads/details.aspx?FamilyID=6c050fe3-c795-4b7d-
b037-185d0506396c&DisplayLang=en

3) Make sure your are using the latest Jet 4.0 SP8

Information about Jet 4.0 Service Pack 8
http://support.microsoft.com/kb/829558

4) What Dirver you are using for ODBC? Oracle's driver?

5) Please have a look at the articles below and let me know whether it will
help you more

Information about query performance in an Access database
http://support.microsoft.com/kb/209126

Microsoft Access Performance FAQ
http://www.granite.ab.ca/access/performancefaq.htm



Sincerely yours,

Michael Cheng
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.

This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/technicalsupport/supportoverview/40010469
Others: https://partner.microsoft.com/US/technicalsupport/supportoverview/

If you are outside the United States, please visit our International
Support page: http://support.microsoft.com/common/international.aspx
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

This document contains references to a third party World Wide Web site.
Microsoft is providing this information as a convenience to you. Microsoft
does not control these sites and has not tested any software or information
found on these sites; therefore, Microsoft cannot make any representations
regarding the quality, safety, or suitability of any software or
information found there. There are inherent dangers in the use of any
software found on the Internet, and Microsoft cautions you to make sure
that you completely understand the risk before retrieving any software from
the Internet.

.

Relevant Pages

  • RE: Repairing / modyfing Exchange
    ... Customer Service and Support for more immediate assistance. ... This service gives you access to Microsoft technical support engineers who ... database by using the old Server's database files, ... >> up with the First Storage Group, so you would like to delete it and then ...
    (microsoft.public.windows.server.sbs)
  • RE: Repairing / modyfing Exchange
    ... > Customer Service and Support for more immediate assistance. ... > This service gives you access to Microsoft technical support engineers who ... As you mentioned, you have reinstalled the Exchange, and overwrote the ... > database by using the old Server's database files, ...
    (microsoft.public.windows.server.sbs)
  • Re: Ajax on .NET 2.0
    ... Please try to create a new ASP.NET AJAX-Enabled Web Site. ... Microsoft Online Support ... You can send feedback directly to my manager at: ... where an initial response from the community or a Microsoft Support ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: NTDS ISAM Database Corruption erors on SBS 2003 Server
    ... it seems that the AD database has corrupted fully. ... You may best to restore the system from backup or do an Offline Defragment ... contact CSS for better support. ... Microsoft CSS Online Newsgroup Support ...
    (microsoft.public.windows.server.sbs)
  • RE: Access Table Datasheet Name To None
    ... I believe the issue is setting the SubDatasheet property to, ... Importing into a brand new database ... How to Troubleshoot Corruption in a Microsoft ... Microsoft Online Community Support ...
    (microsoft.public.access.tablesdbdesign)
Loading