This code fails to update the connection strings (Access97 - SQL Server 2000
table links). It works in Access2000.
Public Sub updateConnStrin gs()
For i = 0 To db.TableDefs.Co unt - 1
Set td = db.TableDefs(i)
td.Connect = "ODBC;DSN=dsnNa me;UID=DFS;PWD= DFSpw"
td.RefreshLink
Next i
db.TableDefs.Re fresh
End Sub 3 4371
On Mon, 26 Jan 2004 22:41:12 -0500, "DFS" <no****@nospam. com> wrote:
I think you need to add the tablename to the Connect string. Attach
one manually, then check what the Connect string is.
-Tom. This code fails to update the connection strings (Access97 - SQL Server 2000 table links). It works in Access2000.
Public Sub updateConnStrin gs() For i = 0 To db.TableDefs.Co unt - 1 Set td = db.TableDefs(i) td.Connect = "ODBC;DSN=dsnNa me;UID=DFS;PWD= DFSpw" td.RefreshLink Next i db.TableDefs.Re fresh End Sub
I don't recall that I've ever had to include the table name in the connect
string. Personally, I can't see any reason the code below should not work,
though I'm not sure why an index number was used instead of a For Each loop.
On Mon, 26 Jan 2004 22:09:11 -0700, Tom van Stiphout <to*****@no.spa m.cox.net>
wrote: On Mon, 26 Jan 2004 22:41:12 -0500, "DFS" <no****@nospam. com> wrote:
I think you need to add the tablename to the Connect string. Attach one manually, then check what the Connect string is.
-Tom.
This code fails to update the connection strings (Access97 - SQL Server 2000 table links). It works in Access2000.
Public Sub updateConnStrin gs() For i = 0 To db.TableDefs.Co unt - 1 Set td = db.TableDefs(i) td.Connect = "ODBC;DSN=dsnNa me;UID=DFS;PWD= DFSpw" td.RefreshLink Next i db.TableDefs.Re fresh End Sub
"Tom van Stiphout" <to*****@no.spa m.cox.net> wrote in message
news:ei******** *************** *********@4ax.c om... On Mon, 26 Jan 2004 22:41:12 -0500, "DFS" <no****@nospam. com> wrote:
I think you need to add the tablename to the Connect string. Attach one manually, then check what the Connect string is.
Tom,
Adding the tablename didn't affect it. Turns out my code is working, sort
of.
RefreshLink in Access 97 doesn't update the Connect string to exactly what I
say; it will change the DSN, UID and DATABASE, but it adds (or won't drop)
the WSID, the App=MicrosoftAc cess, and the Trusted_Connect ion settings.
Access 2000 sets the Connect string to whatever you say (as long as it's
valid). So you can have a minimal Connect string in A2000:
ODBC;DSN=Produc tionSystem;DATA BASE=Production DB
Thanks
-Tom.
This code fails to update the connection strings (Access97 - SQL Server
2000table links). It works in Access2000.
Public Sub updateConnStrin gs() For i = 0 To db.TableDefs.Co unt - 1 Set td = db.TableDefs(i) td.Connect = "ODBC;DSN=dsnNa me;UID=DFS;PWD= DFSpw" td.RefreshLink Next i db.TableDefs.Re fresh End Sub This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Sean Anderson |
last post by:
ODBC
under System DSN
Setup Access Driver
give it the DSN (Data Source Name) MSA
Click on Select and point to the myfile.mdb (your database file)
|
by: Andreas Lauffer |
last post by:
I changed from Access97 to AccessXP and I have immense performance
problems.
Details:
- Access XP MDB with Jet 4.0 ( no ADP-Project )
- Linked Tables to SQL-Server 2000 over ODBC
I used the SQL Profile to watch the T-SQL-Command which Access ( who
creates the commands?) creates and noticed:
|
by: Nolan |
last post by:
I have created an ODBC connection to our Teradata database. Whenever I
attempt to link to a table on Teradata the process seems to be working.
But then I get the error message, "Reserved error (-7778); there is no
message for this error." The diaglog box of tables to select appears,
but there are no tables present.
The usual answer to these ODBC types of questions seem to be that there
is something wrong with your ODBC connection...
|
by: RLN |
last post by:
RE: Access 2003 using WinXP SP2
Problem: When I start up my app I double click either one of my two
Oracle tables in the table list, it asks for an id and pass. I need
them to be linked at startup automatically.
The Oracle db contains two tables I need.
I've already created an ODBC data source that contains the userid and
pass to link to the Oracle DB. It works.
When I go into linked table manager, I can link to them just fine
|
by: cindy |
last post by:
this is the call
private void Page_Load(object sender, System.EventArgs e)
{
OdbcConnection connection = new OdbcConnection ("DSN=PFW52");
CreateDataAdapter(connection);
}
this is the code, no errors, but NO UPDATE I have to use ODBC I just
need to update a field based on a key, EMBARASSED to say days going
| |
by: mike11d11 |
last post by:
Our company has a collection system with a list of accounts in it, I
connect to this system with access using an ODBC connection. I pull in
the account #'s and other fields, then I have to run and update query
to update other fields from another table in our collection system. I
am able to update every field except for one and it gives me unknown
error -7776, then the help with says error 3000. It won't update this
one field for about...
|
by: nolanmadson |
last post by:
I'm creating a front-end for some Teradata user maintenance tables in
MS Access. I've started having problems in occasionally not being able
to insert or update records in these tables. I've been able to create
the Teradata tables, link to them via ODBC and then insert or update in
MS Access. However, in subsequent sessions have not been able to do so.
In another instance a colleague created tables, I was able to make
entries. She had to...
|
by: BillCo |
last post by:
I need to Connect to an online mySQL database from Access using JET
ODBC with no saved DSN.
Anyone out there who as made this work and can give example of how
it's done? I've seen lots of posts saying it's possible, but no code.
This has to be Jet ODBC, because the users are technophobes and I
wouldnt expect them to download and install a myODBC driver - or
create a working DSN for that matter. My visiting the sites and
configuring...
|
by: insomniux |
last post by:
Hi,
I need to install an ODBC driver for a database, but our system-
administrator does not allow me to install it on the VPN-server. Is
there a way to install an ODBC driver for a separate user. The client
using the driver is an ms-access database. The server is windows 2000
Thanks
Insomniux
|
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: 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: 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 instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
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 the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
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: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |