Re: Oracle - Access

2002-05-06 Thread Sergey V Dolgov

Hello Roland,

Check your system variables. You maybe miss it in your icon
application.

Friday, May 03, 2002, 9:48:30 PM, you wrote:

RSis Hallo, anyone who has a good hint on this:

RSis I have an appplication which goes against Oracle and when I am inthe application 
and run VBA code which connects to linked tables everything works fine.
RSis But when I have an icon on the desktop and runs that icon as shortcut then I get 
error messagelike table not exist, but it really exists and it is the same code 
running both times.

RSis Thanks in advance

RSis Roland






-- 
Best regards,
 Sergeymailto:[EMAIL PROTECTED]


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Sergey V Dolgov
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



Oracle - Access

2002-05-03 Thread Roland . Skoldblom

Hallo, anyone who has a good hint on this:

I have an appplication which goes against Oracle and when I am inthe application and 
run VBA code which connects to linked tables everything works fine.
But when I have an icon on the desktop and runs that icon as shortcut then I get error 
messagelike table not exist, but it really exists and it is the same code running 
both times.

Thanks in advance

Roland



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



RE: Oracle - Access

2002-05-03 Thread Pardee, Roy E

Can you show us your code, call out the line that returns the error and give
the exact error #  message?  Also, consider moving this to an msaccess
list.  One good one can be found at
http://peach.ease.lsoft.com/archives/access-l.html

Cheers,

-Roy

Roy Pardee
Programmer/Analyst
SWFPAC Lockheed Martin IT
Extension 8487

-Original Message-
Sent: Friday, May 03, 2002 7:49 AM
To: Multiple recipients of list ORACLE-L


Hallo, anyone who has a good hint on this:

I have an appplication which goes against Oracle and when I am inthe
application and run VBA code which connects to linked tables everything
works fine.
But when I have an icon on the desktop and runs that icon as shortcut then I
get error messagelike table not exist, but it really exists and it is the
same code running both times.

Thanks in advance

Roland



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Pardee, Roy E
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



Re: Oracle - Access

2002-05-03 Thread Thomas Day


Try right-clicking on the icon on your desktop.  Check under properties
and see where the program is starting (it's under the shortcut tab).
Maybe you're starting in the wrong directory.

HTH


   

Roland.Skoldb  

lom  To: Multiple recipients of list ORACLE-L  

@ica.se  [EMAIL PROTECTED]

Sent by: rootcc:   

 Subject: Oracle - Access  

   

05/03/2002 

10:48 AM   

Please 

respond to 

ORACLE-L   

   

   





Hallo, anyone who has a good hint on this:

I have an appplication which goes against Oracle and when I am inthe
application and run VBA code which connects to linked tables everything
works fine.
But when I have an icon on the desktop and runs that icon as shortcut then
I get error messagelike table not exist, but it really exists and it is
the same code running both times.

Thanks in advance

Roland



--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Thomas Day
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



Re: Oracle - Access

2002-05-03 Thread Jan Pruner

Looks like Access doesn't connect to Oracle db.
Try to create connection to Oracle in Autorun procedure in MS Access.

JP

On Fri 3. May 2002 16:48, you wrote:
 Hallo, anyone who has a good hint on this:

 I have an appplication which goes against Oracle and when I am inthe
 application and run VBA code which connects to linked tables everything
 works fine. But when I have an icon on the desktop and runs that icon as
 shortcut then I get error messagelike table not exist, but it really
 exists and it is the same code running both times.

 Thanks in advance

 Roland
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jan Pruner
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



Re: Oracle - Access

2002-05-03 Thread DBarbour


I guess this is what has replaced Friday humor and recipes.  Anything
tangentially related to Oracle.

David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002


   

Roland.Skoldbl 

[EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L 
[EMAIL PROTECTED]   
Sent by: cc:   

[EMAIL PROTECTED]   Subject: Oracle - Access  

om 

   

   

05/03/2002 

09:48 AM   

Please respond 

to ORACLE-L

   

   





Hallo, anyone who has a good hint on this:

I have an appplication which goes against Oracle and when I am inthe
application and run VBA code which connects to linked tables everything
works fine.
But when I have an icon on the desktop and runs that icon as shortcut then
I get error messagelike table not exist, but it really exists and it is
the same code running both times.

Thanks in advance

Roland



--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).