Re: Delete Need help

Access is means access, not speed.

It is universal client for ODBC-compliant data source.

It's true that Oracle ODBC operations can be very slow.

But such operation as deleting all rows can be accomplished with direct query to database.

And, certainly, you can not find Oracle problem using Access, refer to Oracle manuals.

Example

Set obj_db = thisdb

Set obj_qd = Obj_db.createQueryDef ("", "begin null; end;")

obj_qd.connect = connect_string

obj_qd..ReturnsRecords = False

Obj_qd.execute

"Daniel A. Morgan" <dmorgan_at_exesolutions.com> wrote in message news:3AFF7CAC.C50BC735_at_exesolutions.com...
> sean wrote:
>
> > Hi There,
> >
> > my microsoft access takes a very long time to delete 20,000 records,
 from
> > oracle linked table. Is there a easier way to delete these data
 directly
> > from oracle itself ?
> >
> > TIA,
> > sean
>
> After laughing for awhile at your question I came to the conclusion that
 you
> have no idea what Oracle is. I would suggest that as long as you are
> connecting to a real industrial strength relational database from what is
> basically a toy you should go to http://otn.oracle.com and find the Oracle
> Concepts Manual and find out what Oracle is.
>
> There is nothing you can do in Access you can not do faster and better and
> more securely in Oracle except crash.
>
> Get yourself a book on PL/SQL and learn how to use SQL*Plus to accomplish
> your work correctly. To delete 20,000 records from a table in Oracle
 should
> take less than one second.
>
> Daniel A. Morgan
>
Received on Mon May 14 2001 - 08:38:34 CDT