Hello all,

I have following problem. I got database which I don't wan't to 
change. There are some macros which runs queries, expors data... The 
problem is as follows:
Running this queries takes a long time and consumes lot of system 
resources. I need this data every monday morning when I come to work 
and I can't use any farm. So I will use AT command to run at specific 
time... but there is a problem with database login in:

Is it possible to set up Microsoft ODBC for oracle driver to keep 
information about password?

Thank you for your help and ideas.

Regards, Petr


--------------------
Krásnější s Avonem! Zapojte se do soutěže.
http://user.centrum.cz/redir.php?url=http://bonus.centrum.cz/souteze/AVON.phtml

Yes it is.  Are you using DAO or ADODB to connect to the Oracle database?

|-----Original Message-----
|From: coon@c... [mailto:coon@c...]
|Sent: Monday, October 28, 2002 10:50 PM
|To: Access
|Subject: [access] ODBC settings
|
|
|Hello all,
|
|I have following problem. I got database which I don't wan't to
|change. There are some macros which runs queries, expors data... The
|problem is as follows:
|Running this queries takes a long time and consumes lot of system
|resources. I need this data every monday morning when I come to work
|and I can't use any farm. So I will use AT command to run at specific
|time... but there is a problem with database login in:
|
|Is it possible to set up Microsoft ODBC for oracle driver to keep
|information about password?
|
|Thank you for your help and ideas.
|
|Regards, Petr
|
|
|--------------------
|Krásnější s Avonem! Zapojte se do soutěže.
|http://user.centrum.cz/redir.php?url=http://bonus.centrum.cz/soutez
e/AVON.phtml
|
|
|
|
|

How can I determine it? These tables are linked into this file and 
the queries run on them. There is no VBA code. Only Tables, queries 
and macros... 
(I use Access 2000)
______________________________________________________________
> Od: "Leo Scott" <leoscott@c...>
> Komu: "Access" <access@p...>
> CC: 
> Datum: Tue, 29 Oct 2002 02:36:47 -0800
> Předmět: [access] RE: ODBC settings
>
> Yes it is.  Are you using DAO or ADODB to connect to the Oracle 
database?
> 
> |-----Original Message-----
> |From: coon@c... [mailto:coon@c...]
> |Sent: Monday, October 28, 2002 10:50 PM
> |To: Access
> |Subject: [access] ODBC settings
> |
> |
> |Hello all,
> |
> |I have following problem. I got database which I don't wan't to
> |change. There are some macros which runs queries, expors data... 
The
> |problem is as follows:
> |Running this queries takes a long time and consumes lot of system
> |resources. I need this data every monday morning when I come to 
work
> |and I can't use any farm. So I will use AT command to run at 
specific
> |time... but there is a problem with database login in:
> |
> |Is it possible to set up Microsoft ODBC for oracle driver to keep
> |information about password?
> |
> |Thank you for your help and ideas.
> |
> |Regards, Petr
> |
> |
> |--------------------
> |Krásnější s Avonem! Zapojte se do soutěže.
> |http://user.centrum.cz/redir.php?url=http://bonus.centrum.cz/soutez
> e/AVON.phtml
> |
> |
> |
> |
> |
> 
> 
> to unsubscribe send a blank email to leave-access-
1567078Y@p...
> 


--------------------
Nový vyhledávač pro český internet www.WebFast.cz - prostě najde ...