Hi all,
I'm wondering if there's a way to remove the password Access (2003)
has stored for an ODBC linked table without quitting and reopening the
application.
I have a set of linked tables which I update with a user's password
on login using tdf.Connect, thereby keeping them from having to use the
linked table manager or see the ODBC connection dialog. When a user
logs out, I set the connect string back to a generic connect string
without a username or password again using tdf.Connect.
When a logout is followed by quitting Access, the changes update
perfectly, and opening a linked tables without logging in opens the
ODBC connect dialog to ask for the password, effectively blocking the
user from getting into the table without entering a password. However,
when the logout is not followed by quitting the application, then the
tables are still holding on to the passwords,
even though
SELECT Name,Connect from MSysObjects shows my updated
(password-less)connection string for these linked tables.
Is there somewhere else that the password is stored that I can clear
out?
The tables are originally linked with DoCmd.TransferD atabase, and I
fooled around with setting the StorePassword parameter to false, but
this resulted in my being unable to get tdf object set when a user
logged in in the first place.
Any advice or suggestions would be greatly appreciated.
Many thanks,
Eric
0  2379  This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: David Gray |
last post by:
Hello all,
Having problems connecting to an Oracle 9i database from within
SQL/Server 2000 using the Security/Linked Servers feature.
Server1 (SQL/Server)
-----------
Windows Server 2003, Standard edition
MS SQL/Server 2000
Oracle 9i Client kit (OLEDB & ODBC) & Enterprise management tools
|
by: Bill J. |
last post by:
I have to update a PostgreSQL linked server through MSSQL2K.
I first configured the connection with ODBC as follows and I can do queries
with no problem:
EXEC sp_droplinkedsrvlogin @rmtsrvname = 'PostgreSQL', @locallogin = NULL
GO
EXEC sp_DropServer 'PostgreSQL'
GO
|
by: Bill J. |
last post by:
I have to update a PostgreSQL linked server through MSSQL2K.
I first configured the connection with ODBC as follows and I can do queries
with no problem:
EXEC sp_droplinkedsrvlogin @rmtsrvname = 'PostgreSQL', @locallogin = NULL
GO
EXEC sp_DropServer 'PostgreSQL'
GO
|
by: Tim |
last post by:
Hi, I'm using ASP to connect to an ACCESS database (db1) via ODBC.
The table that I connect to (table1) in db1 is an ACCESS query linked
to data in another database (db2).
When I try the connection from a web browser I get the following
message:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
The Microsoft Jet database
|
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:
| | |
by: Neil Ginsberg |
last post by:
I have ODBC linked tables to a SQL 7 database in an A2K database. The linked
tables do not have the password stored in them, so the first time the user
accesses them, they need to enter the SQL password.
I am developing a process that will automatically run at night which will
access those tables. I need to be able to give Access the password, as the
user currently does, so that the process can run without a password prompt
appearing....
|
by: Oren |
last post by:
Hi,
Is there a way to hide the connection information of linked SQL Server
tables from users? It's easy to open a system table and find the
connection info, and if the username and password are saved with this
info, anyone could potentially access this information.
Much thanks,
Oren
|
by: Jill Elaine |
last post by:
I am building an Access 2002 frontend with linked tables to an
encrypted Paradox 7 database. When I first create these linked tables,
I'm asked for the password to the encrypted Paradox database, and the
linked tables are successfully created. I use the data from these
linked tables in several forms.
All works great until I close the Access frontend and open it again.
When I try to use the forms, I get an error message: "Could not...
|
by: jdorp |
last post by:
I read KP article at support.microsoft.com (Q177594) that stated that
with the following code:
Sub Command1_Click()
Dim db1 As Database
Dim db2 As Database
Dim rs As Recordset
Dim strConnect As String
'*** You have to modify the path to where db1.mdb is located
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
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 most users, this new feature is actually very convenient. If you want to control the update process,...
|
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 choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
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 launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| | |
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 effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
