odbc

I have been trying to extract the same data set via an ODBC connection to a main frame database. One attempt has been using Access simply Query and the other via MS Query. The Access simple query does not return the information I need yet MS Query does. How can there be a difference if I am...

We are runing a clarion product that uses TPS files. We obtained the Softvelocity ODBC Topspeed, however when we run it from data connection in Excel, it immediatly shuts down the worksheet and then restarts Excel. Note the "Test Connection" during the setup works fine. Has anybody else come...

My Office PC has Access 2002 installed (with Office Standard 2003). I'm connecting to a remote Mainframe containing hundreds of DBase2 tables, the structure of which I have no control. Whenever I link to the table I'm interested in, Access pulls through around 256 fields of which I need about...

Is there a way to see the SQL query that someone built in the query editor without actually having the ODBC connection installed on your machine? I assume the query syntax resides in the spreadsheet somewhere, not on the database it is querying. I keep getting the error "[Microsoft][ODBC...

I have imported some data using MS-Query and an ODBC connection to an AS/400 and then add a column to the table that allows the entry of text, Example Column "A" is Cust# (From Database), Column "B" is Cust Name (From Data Base), Column "C" is a column I added to the tabe to allow the entry of a...

My colleague pulled data into Excel from an Access database on his desktop using an ODBC (user DSN with password). He recently left the company and the database was moved to a share drive. When I refreshed the data on Excel, I got an ODBC Fail error message. There are altogether 39 queries...

I have a table in Access 2003 that is linked to a sql 2005 server. So far as I know I ahve all the essential parts for this table/form to update to the server correctly. I have a primary key, as well as a timestamp field in the table. Here is the situation i'm attempting and horribly...

We're exploring the idea of linking our access database to a sql server database. When we go down this route, the application gives us 2 options. Our thought is that option #2- Linking to a SQL Server Db by Creating a Linked table is the way to go. However, the system goes on to say that...

I've got a query in an Excel 2003 sheet from Data - New Database Query which reads a password protected database. So when I run the query the ODBC box pops up to enable me to input a user name and password. No problem. There are some sheets written by my predecessor which query the same...

Hello, I have been searching (a lot!) to find a solution to being able to prompt for parameters for a SQL Pass Through query from Access to SQL Server. I found examples using stored procedures on the server but I do not have write access to the server in this case. I don't have create procedure...

Help please, I'm in way over my head. My report runs fine, except when multiple users run it for the same job at the same time (which they need to do often during meetings for some reason). Then it "slows to a crawl and they don't know if it would even run if they waited long enough". Using...

I have read through alot of posts about excel and ODBC and none that I have read seem to pertain to my situation. I am using a program called Elipse SCADA which has a built in database system using the ODBC protocol. There is very little documentaion on the Elipse software but I have named a...