Re: Manipulate Oracle with Access97

This may sound simple, because it is.

1. Create a new query and make it a Pass Through query.
2. Enter the correct SQL Statement (Oracle Syntax) CREATE TABLE tblEmployees (empNo NUMBER NOT NULL , empName VARCHAR2(10) , HireDate DATE DEFAULT sysdate )

   DROP TABLE tblEmployees

3) Run the query. You will be prompted for ODBC connection

     which requires a login with DDL permissions.

--

Danny J. Lesandrini
dan_nospam_at_yahoo.com



"Phil" <phg3113_at_hotmail.com> wrote in message news:CVWI4.6$4v2.575_at_nreader2.kpnqwest.net...


> Hi everybody,

>

> I'm looking for some explanations and some examples (code) to create, drop,

> fill ... tables in an Oracle Database through an Access97 application .

>

> All I can do for the moment is to list the tables

>

> ...

>     Dim wrkODBC As Workspace

>     Dim OracleDB As DATABASE

>     Dim Tb As TableDef

>     Dim s As String

>

>     Set OracleDB = dbengine(0).OpenDatabase _

>         ("", , False, "ODBC;UID=userX;PWD=a_pass;DSN=DWH Production")

>

>     For Each Tb In OracleDB.TableDefs

>         Debug.Print Tb.Name

>     Next

>

>     s = "Create Table rszdwh.AAAAAAA (CodeIntern Number(7), Temps

> Varchar2(8), LAN11 Number (4,0)"

>     s = s & " , MAN11 Number (4,0)"

>     s = s & " , SECRSOC Number (4,0)"

>     s = s & " , VAL1 Number(10)"

>     s = s & " ) storage (initial 6M next 2048k pctincrease 0) pctfree 1 ;"

>     OracleDB.Execute s ' DOESN'T WORK!!!

>     OracleDB.Close

>     wrkODBC.Close

> ...

>

> but I can't create a new table ('ODBC Call Failed')

>

> I'd like some help please (doc file or internet link...)

>

> Thanks in advance

>

> Phil

>

>

>