[BEGINNER] - VBA / ODBC / Project 98

[Antoine]

Hi,

i have to create a button on a customed menu under Microsoft Project 98,
that executes an oracle stored procedure.

I tried to RTFM, but when I cut & paste piece of sample code from
the MSDN it doesn't work. For instance, when i try 'dim db_test as
database', database is not recognized (i tried under a module and under a
class module).

Any idea ?

Thx in advance and sorry fo my pathetic english.

Antoine

 

[Rod Gill]

Hi,

You need to decide whether you are using DAO or ADODB (I recommend the
later) and then in the VBE select Tools, References and select the
appropriate library. You will need DAO or ADODB drivers from Oracle.

Then you can declare database.

--
Rod Gill
Project MVP
For Microsoft Project companion projects, best practices and Project VBA
development services
visit www.projectlearning.com/