0
votes
2answers
32 views

In what way are Access tables linked with SQL server?

I have a mdb file with lots of OBDC linked tables that are linked to the tables in SQL server elsewhere. I can not see any information on how they are "linked". It is a little scary not knowing ...
0
votes
0answers
53 views

Connecting Access 2010 front end to Pervasive database with ODBC

We have an Access 2003 front end attached to a Pervasive database used with Sage Platinum. Access is used for reporting and its running on XP. We switched to Access 2010 on a different client machine ...
0
votes
1answer
52 views

How to link a MySQL Table with a binary key into Access?

In MS Access I've created a linked table via ODBC to a MySQL table with a binary(16) primary key column (UUID). MS Access only shows the first row, all other rows have #deleted entries. I guess the ...
0
votes
0answers
60 views

MS Access: ODBC Err 3146 - Timeout related?

I have an AccessDB that queries that appears to function as expected under light loading (i.e., 1-2 users), no errors, SQL Server returns the desired results. We tried to test using 8 concurrent ...
0
votes
3answers
83 views

How to create an Access query to find # symbol into a field?

It seems easy but I'm missing something. I have a MySQL database that is connected from access through ODBC connector. I'm looking for the fields where there are # symbol but I'm getting zero ...
1
vote
1answer
105 views

Access Linked Tables and Their Network Connections

I need to know some simplistic details about how Microsoft Access' linked tables work. I think I know the answer, and this question is more about asking for a confirmation than anything else. A ...
2
votes
0answers
2k views

Access 2010 linked table - solve the “decimal field's precision” error

I have an Access 2003 database (running on Win 7 64-bit, Office is also 64-bit) that has many linked tables pointing to an Oracle 11g instance through 64-bit Oracle ODBC driver. Most of the tables ...
1
vote
0answers
494 views

Connection to MS Access from Oracle over a DB Link

I need to establish a connection between a MS Access database, which is placed on a network share on a windows box, and an Oracle database on a Unix Box. I need to query the Access tables from the ...
5
votes
2answers
3k views

MS Access / MySQL: unlock locked Records

I have a Microsoft Access database that is connected to a MySQL server via ODBC and is accessed by multiple users. Over time many records are locked and editing is not possible anymore. Is there a ...
5
votes
1answer
1k views

SQL Server ODBC Mirror/Failover Partner

Background/Context We are in the process of moving our SQL Server 2000 databases to a mirrored SQL Server 2008 R2 server with a witness and automatic failover. We have both .Net and Access ...
0
votes
0answers
28 views

Duplicate Customer Records for SQL Query from ODBC with Joins and Group Bys [duplicate]

Possible Duplicate: SQL Query with ODBC, Joins and Group Bys I am getting duplicate customer records with the query below. The main purpose of the query is to pull a list of customers into ...
3
votes
5answers
529 views

SQL Query with ODBC, Joins and Group Bys

I am having issues with the statement below. The main purpose of the query is to pull a list of customers into an Access db from ODBC (our customers are stored in DB2 on IBM i). The query is ...
1
vote
1answer
1k views

Why do I only see SYS and INFORMATION_SCHEMA tables? Access 2007 ODB to SQL Server 2008

I was finally able to create my ODBC connection but now when I go to External Data > ODBC > LINK TABLES using my ODBC connection in Access 2007 I get a huge list of tables such as ...
2
votes
2answers
381 views

SQL Server 2008 ODBC

My SQL Server 2008 is located on a remote computer so I am trying to create an ODBC connection using SQL Server Authentication. My problem is that the way i normally connect to my SQL Server is by ...
2
votes
0answers
271 views

MYSQL & Access ODBC

I am trying to connect mysql with access, i am settings up the ODBC correctly from the data sources, however i get a driver error. I am using access 2010 and the driver version of the ODBC conector ...
2
votes
3answers
360 views

Can I limit access to postgresql 8.4 databases via ODBC on the server side?

I have a bit of a tricky problem at the moment that I could really use some help to solve. I'll do my best to explain it but please feel free to ask questions :-) We have a postgresql 8.4 database ...
3
votes
1answer
1k views

MS Access displays alle columns in SQL Server tables as “deleted”

I have created an ODBC connection to a SQL Server 2005. When I link to the tables from MS Access, some tables have only "deleted" data. This means the rows and columns are displayed, but all data ...
4
votes
1answer
725 views

Ms-access ODBC calls for linked table behaviour

I'm curious if anyone knows how ms-access goes about generating ODBC calls for linked tables. The reason I ask is that I'm trying to make the front-end of a system super efficient and too minimise ...