Object not defined error

A

Ashish Nanda

I tried using the following syntax to ope a connection and
run a SQL query from it in my MS Access shared program
which is used simultaneosly by sevenral users.
The application runs this SQL script from my workstation
where i did the coding and designed the application but
when i take the application to aanother system it gives me
an error saying object not defined.
What could be the cause of this.
I have all the tables in the application linked and they
reside in the database server.
Is there an easy way to perform this operation as whenever
i log in a connetion is estabvlished if so how can i run a
qury like this or call a procedure.


Dim IRowcount As Integer
'Set OraSession = CreateObject
("OracleINProcServer.XOraSession")
'Set OraDataBase = OraSession.OpenDatabase
("bio", "scott/nanda", ORABD_DEFAult)
'IRowcount = OraDataBase.ExecuteSQL("Update leadman.leads
set date_avail=null,remove ='Y',rsn2remove='De Allocated'
where (sysdate-date_avail)>15")
'MsgBox IRowcount & " Rows De Allocated"



Best REgards,
Ashish nanda
 
B

Bruce Loving

Object not defined -- usually you are missing a Reference
Go into the code and click the Tools, References
check that all checked references exist on the
other systems. It is computer dependent.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top