After having reformatted my workstation, I installed Windows XP and
Office 2000 Premium. However, when I open an Access database to link
to a SQL Server database, I notice that in the "Files of Type"
dropdown list, "ODBC Databases" does not appear. I looked through the
Office 2000 setup, but didn't see any option that I was obviously
missing. How do I restore this feature?
- Robert -
2  1359 
I have to say, that's a new one on me. Perhaps, the ODBC libraries are
missing from the system, or something? Do you still find the Data Sources
(ODBC) tool in the control panel under "Administra tive Tools"?
On 22 Oct 2004 07:45:19 -0700, po******@yahoo. com (Robert Mayer) wrote: After having reformatted my workstation, I installed Windows XP and
Office 2000 Premium. However, when I open an Access database to link
to a SQL Server database, I notice that in the "Files of Type"
dropdown list, "ODBC Databases" does not appear. I looked through the
Office 2000 setup, but didn't see any option that I was obviously
missing. How do I restore this feature?
- Robert -
Actually, that was the first thing I thought of, so I immediately went
to setup of my ODBC profiles again and the connections all tested out
fine. I then went to do a repair install of Office 2000, but that
didn't seem to have any effect on the link tables feature.
- Robert -
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it! This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
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: Philip Wright |
last post by:
I am trying to connect to a DB2 v7.2 database from Lotus 123 v9.8
on a Windows XP Pro machine. I have the Software Development Client
installed on the XP machine and have run the Client Configuration
Assistant and registered the SAMPLE and my TEST databases with the
ODBC Administrator as System DSN data sources. Everything seems
fine, but when I try to connect to "External Tables" through 123
my DB2 databases are not listed under available...
|
by: TheAd01 |
last post by:
In an Access97 application I fetch data from an Oracle database via a
linked table (via Odbc/sqlnet). The Oracle database now upgrades from
7.3 to 8.0. The Oracle odbc driver I use (2.0.3.1, supplied with 7.3)
always worked fine on all Nt4 workstations. Now with the 8.0 db an
odbc error occurs when the db is contacted: {ODBC Oracle
Driver]ORA-01034: ORACLE not available. (#1034)
SQLSetConnectAttr of the device
driver had failed.
On a...
|
by: Bob |
last post by:
All,
I have read through lots of postings regarding my concerns, but I
haven't found what I am looking for.
The center (non profit University) where I work collects scientific
data about subjects enrolled in studies related to respiratory
diseases. Both lab data and questionnaire information are collected.
We use W2K as PC operating systems, MS Access XP, XP Developer, and
Visual SourceSafe. Our databases use a front end – back end...
|
by: Igor |
last post by:
An error "ODBC connection to failed"
is raised when I am trying to get data from a table in
Microsoft Access (97, or 2000) which is actually a linked
table to another table in SQL Server 7 . The exception is
raised from a Web .Net app while exactly the same code
works fine in Windows .Net app. That makes me thinking the
issue somehow is related to security context. Anyway I do
not know how to solve the problem, and any help is...
| | |
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: Greg Strong |
last post by:
Hello All,
The short questions are
1 Do you know how to make DSN connection close in Access to Oracle 10g
Express Edition?
&/or
2 Do you know how to make a DSN-less pass-through query work from
|
by: Neil |
last post by:
I just started using Access 2003, and I can't link a SQL Server table. I
right-click on the database window; select Link Tables; and select ODBC
Databases from the Files of Type dropdown. As soon as I select ODBC
Databases from the Files of Type dropdown, the entire dialog box disappears.
No error message. Just disappears, and I'm back at the database window.
I have tried this with other databases, including a brand new blank one, and...
|
by: Bret Kuhns |
last post by:
I recently started a co-op/internship at a company and they are
looking to migrate a large legacy supported application from OLEDB to
SQL Server. I'm doing prelim work in experimenting with the options
available. The application is huge (1+ million lines of C++ code), so
it'd be quite a bit of man hours to adapt all the database code for
SQL Server. I stumbled upon linked tables in an OLEDB file to an ODBC
source (such as SQL Server) and...
|
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: 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.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
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: 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: 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: 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.
| |
