473,572 Members | 3,210 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Linked tables in ms access asking for login/password

Hi,

I have an Access 2000 database, which contains some native tables,
and some linked tables which belong to an ORACLE database, through
ODBC.

Using VB.NET, I am trying to fetch some data by joining two tables,
one table native to the mdb file, and another belonging to ORACLE.

I am using a connection string to connect to mdb file:
Provider=Micros oft.Jet.OLEDB.4 .0;Data Source=database .mdb;User ID=Admin;
Jet OLEDB:Database Password=xxxx;P ersist Security Info=True;

My problem is that as soon i try to fetch the data, a window (not belonging
to my vb program) comes up with the title "ORACLE ODBC driver connect"
asking for ORACLE's username and password. Its the same screen which
i get when i open Access database, and try to view one of the oracle
tables for the first time.

I don't want this screen. Somehow :
- i want to store this info with access
OR
- pass this info through something like the connection string.

User should not be able to see this screen.

I would appreciate any help.
anand saha
Nov 13 '05 #1
4 14458
Hi Anand,

Nice crossposted, however this newsgroup where this is often the question is
not in it.
If I was you I would try it especially there.

Adonet
<news://msnews.microsof t.com/microsoft.publi c.dotnet.framew ork.adonet>

Web interface:

<http://communities2.microsoft.com/co...s/?dg=microsof
t.public.dotnet .framework.adon et>

I think you have more change there to get an answer that fits you.

Cor
"anand" <an*******@redi ffmail.com> schreef in bericht
news:f7******** *************** ***@posting.goo gle.com...
Hi,

I have an Access 2000 database, which contains some native tables,
and some linked tables which belong to an ORACLE database, through
ODBC.

Using VB.NET, I am trying to fetch some data by joining two tables,
one table native to the mdb file, and another belonging to ORACLE.

I am using a connection string to connect to mdb file:
Provider=Micros oft.Jet.OLEDB.4 .0;Data Source=database .mdb;User ID=Admin;
Jet OLEDB:Database Password=xxxx;P ersist Security Info=True;

My problem is that as soon i try to fetch the data, a window (not belonging to my vb program) comes up with the title "ORACLE ODBC driver connect"
asking for ORACLE's username and password. Its the same screen which
i get when i open Access database, and try to view one of the oracle
tables for the first time.

I don't want this screen. Somehow :
- i want to store this info with access
OR
- pass this info through something like the connection string.

User should not be able to see this screen.

I would appreciate any help.
anand saha

Nov 13 '05 #2
On 21 Jun 2004 01:36:31 -0700, an*******@redif fmail.com (anand) wrote:

¤ Hi,
¤
¤ I have an Access 2000 database, which contains some native tables,
¤ and some linked tables which belong to an ORACLE database, through
¤ ODBC.
¤
¤ Using VB.NET, I am trying to fetch some data by joining two tables,
¤ one table native to the mdb file, and another belonging to ORACLE.
¤
¤ I am using a connection string to connect to mdb file:
¤ Provider=Micros oft.Jet.OLEDB.4 .0;Data Source=database .mdb;User ID=Admin;
¤ Jet OLEDB:Database Password=xxxx;P ersist Security Info=True;
¤
¤ My problem is that as soon i try to fetch the data, a window (not belonging
¤ to my vb program) comes up with the title "ORACLE ODBC driver connect"
¤ asking for ORACLE's username and password. Its the same screen which
¤ i get when i open Access database, and try to view one of the oracle
¤ tables for the first time.
¤
¤ I don't want this screen. Somehow :
¤ - i want to store this info with access
¤ OR
¤ - pass this info through something like the connection string.
¤
¤ User should not be able to see this screen.
¤
¤ I would appreciate any help.

When you create the linked table in Access there is an option to save the password so that you will
not be prompted when accessing the table.
Paul ~~~ pc******@amerit ech.net
Microsoft MVP (Visual Basic)
Nov 13 '05 #3
Paul Clement <Us************ ***********@sws pectrum.com> wrote in message news:<vj******* *************** **********@4ax. com>...
On 21 Jun 2004 01:36:31 -0700, an*******@redif fmail.com (anand) wrote:

¤ Hi,
¤
¤ I have an Access 2000 database, which contains some native tables,
¤ and some linked tables which belong to an ORACLE database, through
¤ ODBC.
¤
¤ Using VB.NET, I am trying to fetch some data by joining two tables,
¤ one table native to the mdb file, and another belonging to ORACLE.
¤
¤ I am using a connection string to connect to mdb file:
¤ Provider=Micros oft.Jet.OLEDB.4 .0;Data Source=database .mdb;User ID=Admin;
¤ Jet OLEDB:Database Password=xxxx;P ersist Security Info=True;
¤
¤ My problem is that as soon i try to fetch the data, a window (not belonging
¤ to my vb program) comes up with the title "ORACLE ODBC driver connect"
¤ asking for ORACLE's username and password. Its the same screen which
¤ i get when i open Access database, and try to view one of the oracle
¤ tables for the first time.
¤
¤ I don't want this screen. Somehow :
¤ - i want to store this info with access
¤ OR
¤ - pass this info through something like the connection string.
¤
¤ User should not be able to see this screen.
¤
¤ I would appreciate any help.

When you create the linked table in Access there is an option to save the password so that you will
not be prompted when accessing the table.
Paul ~~~ pc******@amerit ech.net
Microsoft MVP (Visual Basic)


Paul-

I'm having this same difficulty, and tried your suggestion by
re-linking the Oracle table so I could save the user ID and password.
However, during re-linking I was never given the option to enter the
user ID and password. Is this an option that has to be set-up in the
Oracle driver or database?

John
Nov 13 '05 #4
On 22 Jun 2004 10:45:33 -0700, jb***@gene.com (John B) wrote:

¤ Paul Clement <Us************ ***********@sws pectrum.com> wrote in message news:<vj******* *************** **********@4ax. com>...
¤ > On 21 Jun 2004 01:36:31 -0700, an*******@redif fmail.com (anand) wrote:
¤ >
¤ > ¤ Hi,
¤ > ¤
¤ > ¤ I have an Access 2000 database, which contains some native tables,
¤ > ¤ and some linked tables which belong to an ORACLE database, through
¤ > ¤ ODBC.
¤ > ¤
¤ > ¤ Using VB.NET, I am trying to fetch some data by joining two tables,
¤ > ¤ one table native to the mdb file, and another belonging to ORACLE.
¤ > ¤
¤ > ¤ I am using a connection string to connect to mdb file:
¤ > ¤ Provider=Micros oft.Jet.OLEDB.4 .0;Data Source=database .mdb;User ID=Admin;
¤ > ¤ Jet OLEDB:Database Password=xxxx;P ersist Security Info=True;
¤ > ¤
¤ > ¤ My problem is that as soon i try to fetch the data, a window (not belonging
¤ > ¤ to my vb program) comes up with the title "ORACLE ODBC driver connect"
¤ > ¤ asking for ORACLE's username and password. Its the same screen which
¤ > ¤ i get when i open Access database, and try to view one of the oracle
¤ > ¤ tables for the first time.
¤ > ¤
¤ > ¤ I don't want this screen. Somehow :
¤ > ¤ - i want to store this info with access
¤ > ¤ OR
¤ > ¤ - pass this info through something like the connection string.
¤ > ¤
¤ > ¤ User should not be able to see this screen.
¤ > ¤
¤ > ¤ I would appreciate any help.
¤ >
¤ > When you create the linked table in Access there is an option to save the password so that you will
¤ > not be prompted when accessing the table.
¤ >
¤ >
¤ > Paul ~~~ pc******@amerit ech.net
¤ > Microsoft MVP (Visual Basic)
¤
¤ Paul-
¤
¤ I'm having this same difficulty, and tried your suggestion by
¤ re-linking the Oracle table so I could save the user ID and password.
¤ However, during re-linking I was never given the option to enter the
¤ user ID and password. Is this an option that has to be set-up in the
¤ Oracle driver or database?
¤
¤ John

I don't believe that the Linked Table Manager supports this capability if that is what you are
using. AFAIK, you have to delete the existing linked table and use the File...Get External
Tables...Link Tables... method.
Paul ~~~ pc******@amerit ech.net
Microsoft MVP (Visual Basic)
Nov 13 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
1913
by: jason | last post by:
Is it actually possible for a local access 2000 database to link to a remote database online via linked tables... I know www.aspfaq.com has spoken about possibliites (although not secure) for local-remote hook ups but I just wanted to know how feasible a LINKED TABLE scenario would be. If this was possible it would solve so many...
10
16989
by: Mo | last post by:
A user is complaining that Access Dbs on her PC asks her to type in a username and password whenever she opens an Access Db. The username that appears in the username box is the same as her network username. No password actually works to open any DB. I've also logged in to that pc using the Admin account and get the same problem. She does...
2
2526
by: Sam DeRT | last post by:
Is there a way to hard code what a path to a linked table would be without going through the Linked Table Manager or a re-linking process? My issue is that I'm installing a database with linked tables onto several different networks. I can pre-determine what each path will be, but I can't do the re-linking or the Linked Table Manager...
1
1851
by: Karen Hill | last post by:
I have a database which is split. The logic is in an MDE file, which connects to a MDB file via linked tables. Now, since the MDE file is installed, on one computer and the linked tables reside on another, how can I programatically create it so they hook up properly? I was thinking of something like a Form to add to the MDE file which the...
7
3410
by: smd | last post by:
Hello and thanks for taking the time to read this. I've looked all over the web and newsgroups and can't find a solution to my problem. I've posted this question to the Access 2000 group as well - sorry for cross posting. Back ground: User at remote site has Access 2000 running on XP (don't know SP of either). Linked tables are DB2 v8...
4
1854
by: anand | last post by:
Hi, I have an Access 2000 database, which contains some native tables, and some linked tables which belong to an ORACLE database, through ODBC. Using VB.NET, I am trying to fetch some data by joining two tables, one table native to the mdb file, and another belonging to ORACLE. I am using a connection string to connect to mdb file:
4
2624
by: xperre van wilrijk | last post by:
Hi, I have inherited an access userinterface that links to sql server tables through ODBC. The SQL server database contains data related to villages in my country and is populated by my collegues. Now I have to create an access data file for each village and deliver it to the local governments ... so they can see only their data using...
1
2199
by: hk777 | last post by:
Hi I have Access 2007 installed at work, and last week it suddenly started asking me for a username and password whenever I try to open anything, even a new database. If I log in to my computer with someone else's ID, everything is fine- and if I use my login on a different computer, it's fine- but using my own login on my computer doesn't...
1
2164
by: Martin Clark | last post by:
I use access to get data from a As400, i have linked various tables from the AS 400 but access has selected some of the fields as primary keys and won't let me take the keys off? Is this to do with the ODBC driver or is it something in Access?
0
7957
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
1
7705
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
8000
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
6337
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
1
5524
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
3685
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
3673
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
1240
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
975
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.