By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,139 Members | 1,247 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,139 IT Pros & Developers. It's quick & easy.

HELP ME ACCESS 2000 and ORACLE ODBC 8I

P: n/a
have an interface Access 2000. all my tables are on a waiter oracle 8i. I
have fastener all the tables which I have needs in my access application.
When I clic on a table for the first time, it requires of me to be connected
on driver ODBC
Exemple: I have create a connextion ODBC (driver 8.1.7)
Username: username Password: pwd DSN: VALINTRA
When I have between the name and the password of the user that I desire to
have (which forms part of the users of oracle) for the first time, it will
not ask me this validation on the other link table ? when I shows a doucle
click above the contents. What I want to do is perhaps simple but I do not
know how to take to me there. I have a form which requires the name of user
and its password of me. I takes his information and I wanting to validate
this name aupres oracle without I receive an ODBC windows of the system
asking me of me revalid?.
Thereafter, I would like to be able to change user has my own way and that
the customer oracle either modifies all the time has. The goal of Ca it is
that I have various users who serf of the system and dependamment of the
name, the safety of are not all the same one.
Esperant which my explanations are clear

Excuse my english i doing my best!

Marc
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
I'm afraid that the most-flexible solution will require a process like the
following:

1) Open Access DB
2) User is prompted for login (an unbound form in Access...not the ODBC login)
3) When the user clicks "LOGIN", the system will have to DROP ALL LINKED
TABLES, and then recreate the links using a custom connect string conatining
the authentication information from the login form.

You will not need a DSN for this solution. I've only had experience using the
MS Oracle driver in these cases.
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.