Stack Overflow
Stack Overflow

Questions tagged [linked-tables]

Linked-tables are tables that are joined from different data sources. Example- creating a query in access that joins the access table with data from sql-server.

A linked server allows for access to distributed, heterogeneous queries against OLE DB data sources. After a linked server is created, distributed queries can be run against this server, and queries can join tables from more than one data source.

These tables when joined from two different data sources are called linked-tables.

202 questions
3
votes
1 answer

What does 'Insert into linked table failed, RAISERROR could not locate entry for error x in sysmessages' mean?

I'm asking Access 2002 to run a query like this against an SQL 2000 Server: INSERT INTO tableA (col1, col2, col3, ...) SELECT (col1, col2, col3) FROM tableB LEFT JOIN tableA ON tableA.id = tableB.id WHERE tableA.id IS NULL; But it fails and gives…
Shawn
  • 10,931
  • 18
  • 81
  • 126
3
votes
2 answers

ODBC Call Failed with stored procedure - Pass through query

I have created a pass through query and trying to call a stored procedure from it. I am able to execute the queries on sql server database sucessfully but when it comes to stored procedures, i am getting an error as : "ODBC call Failed" The problem…
Sai Avinash
  • 4,683
  • 17
  • 58
  • 96
3
votes
3 answers

phpmyadmin warning, "The additional features for working with linked tables have been deactivated"

In the footer of the phpmyadmin homepage is a warning that reads, "The additional features for working with linked tables have been deactivated. To find out why click here."
user163831
  • 1,031
  • 3
  • 13
  • 25
3
votes
1 answer

Linked table in MS Access needs a hyperlink column

I've recently moved a table from MS Access 2003 into SQL Server 2005. Then in the Access DB I created a linked table back to the table in SQL Server to replace the original table. So far everything is working great. With one exception. Several of…
Kenneth Fisher
  • 3,692
  • 19
  • 21
3
votes
2 answers

Converting timestamps to human readable in MS Access

I have dozens of MySQL tables linked in a MS Access program. There are also a dozen or so Queries which pull these tables togather and provide data in a human fashion, especially converting timestamps to mm/dd/yyyy format. I have tested the…
Alex.Barylski
  • 2,843
  • 4
  • 45
  • 68
2
votes
3 answers

How do I link tables with id from a list stored as XML in a column

Hopefully the question explains it well. I have a DB for a Library. Since they can be used many times, and contains more data than just a name, I have a table for Authors. Then there's a table for Books. I have no problem linking Authors to…
Tanoshimi
  • 463
  • 1
  • 4
  • 11
2
votes
0 answers

Disappearing Linked Table

I have a problem that arose last week and seems to be spreading. I installed a MS Access database front end on several pcs at a company, that link by ip address to SQL Server backend. This was done over a year ago and has been working perfectly…
EddieL
  • 55
  • 6
2
votes
1 answer

How to setup a link from an Access .accdb file to a mdb file with user level security?

We use in a company an Access database which I developed a long time ago with front end and back end .mdb files and user level security. (We don't need high security standards) Now I am developing an extension to that database which is mostly…
Edgar
  • 2,527
  • 2
  • 19
  • 40
2
votes
1 answer

Refine a WHERE condition on ORACLE query to staging tables

I am looking for some assistance with refining a WHERE condition on a SQL query to a set of linked Oracle data staging tables. One table is for case data, containing meta-data about the record. There is only one record per case on this table. There…
William Walters
  • 23
  • 3
2
votes
0 answers

LinkTable is not editable in MS Access

I have MySQL table which is linked to access using odbc(Mysql ODBC connector 8.0 32 bit). Initially one of the column has length of Varchar(1000) and everything works fine. However now I need to increase the column size to Varchar(2000). However as…
Maqsood
  • 369
  • 4
  • 17
2
votes
2 answers

Creating multiple linked tables in Access with VBA

So I currently have this code Public Sub DoTrans() Set cn = CreateObject("ADODB.Connection") dbPath = Application.ActiveWorkbook.Path & "\db1.accdb" dbWb = Application.ActiveWorkbook.FullName dbWs = Application.ActiveSheet.Name scn…
ThePangloss
  • 31
  • 5
2
votes
0 answers

MS-Access Add Additional Linked Tables

I have an MS-Access database that was converted to use SQL Tables using the "Microsoft SQL Server Migration Assistant 2008 for Access" (aka SSMA) and created linked tables (so the MS-Access interface still works but is linked to SQL…
ChrisHDog
  • 4,473
  • 8
  • 51
  • 77
2
votes
1 answer

How to change data type default from Decimal to Double when linking external tables in Access?

I am using PostgreSQL backend with linked tables in Access. On using the wizard to link to the linked tables, I get errors: Scaling of decimal value resulted in data truncation This appears to be the wrong scale for numeric data types being chosen…
user3851177
  • 45
  • 1
  • 9
2
votes
2 answers

My userform turns blank because I can't edit linked table connection

I am currently developing an access application, which dynamically builds userforms through a VBA module. In order to create the forms, I need data from an MS SQL DB. I collect this data through linked table connections, which are established upon…
MDSN
  • 21
  • 1
2
votes
1 answer

Setting Linked Database (MS Access) path without access to linked database

I have an Access system that comprises two parts: a "frontend" .mdb file that contains forms, reports and macros, and a backend .mdb file that contains the data. Copies of the frontend MDB files are stored on each computer and the backend file is…
Dai
  • 141,631
  • 28
  • 261
  • 374
1
2
3
…
13 14