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
1
vote
0 answers

Encoding issue with MsAccess/mysql - not displaying accent marks properly

I need to migrate some data we have in Access tables to mysql. I have used Mysql as a backend and MsAccess as a frontend before so I figured this was a no brainer. In the mysql/Access combo that works the mysql tables are in latin1_swedish and both…
Mallow
  • 844
  • 1
  • 13
  • 37
1
vote
1 answer

Can I use my Views on a SQL Sever database in MS Access?

I have Views on a SQL server database that I have painstakingly written. I am creating linked tables on my MS Access Database. I am only able to pick from tables. Is there a way to use my Views on the SQL Server within MS Access, which has all the…
Dasal Kalubowila
  • 103
  • 5
  • 22
1
vote
1 answer

Is there a way in MS Access, using VBA to work out if a ODBC linked Table is a SQL View or Table

I have an Access Database with hundreds of ODBC Linked Tables to a couple of backend SQL Servers. Some of these Linked Tables are to SQL Tables and some are to SQL Views. Is there any way to determine, using VBA, which is to a SQL Table and which…
Mark Fairhead
  • 21
  • 2
1
vote
2 answers

Changing Linked Table Source Access 2016

I am trying to change the links in an Access 2016 database, but the method I've used in the past is not working as required. I am using the t.connect="new connection" t.refreshlink method, where t is a the table. I have seen in the linked table…
Nathan_Sav
  • 8,466
  • 2
  • 13
  • 20
1
vote
1 answer

When writing data to a linked table in Access, what actually does the writing?

If I have a tool that writes data to Access but one of the tables is a linked table, how exactly is the data written to that linked table? Does the data get off-handed to Access and then within Access, Access handles the writing of the data? Or is a…
user5954196
1
vote
2 answers

Cannot connect Access to SQL Server Linked Tables - error message loggingin

I have a client for which I am setting up a new SQL Server Express and (on a different computer) connecting their Access front end to that SQL Server. I created an account on SQL Server, changed authentication to SQL Server. I am able to log on to…
David Britz
  • 117
  • 1
  • 3
  • 9
1
vote
1 answer

Is it possible to update a local table with values from a linked table?

I have two identical tables in my database, T1 and T2. T1 is a local table while T2 is a linked table from a live SQL database. At the moment the two tables are identical. In short, I would like to be able to run a query that will update T1 will all…
gdekoker
  • 185
  • 8
1
vote
1 answer

Test to see if ODBC Linked Table is Available

I have an Access database that links to six tables in other SQL databases using ODBC connections. I then have a couple of queries running checks on these tables generating some reports. However, before I run the queries, I want to ensure that all…
gdekoker
  • 185
  • 8
1
vote
0 answers

Unable to append records to linked table in MS Access. Key Violations issue

I am pretty new with sql server and dealing with the linked table. I tried to append new records to a linked table that is from SQL server in MS Access but then it popped out error saying that all the data hasn't been added because of key…
kevin hiew
  • 96
  • 1
  • 7
1
vote
3 answers

MS Access form - lock columns from editing

Is it possible to lock specific columns from editing in an Access form ? The problem is that I have a linked table in a form that shows information and users can update it. Now it turned out that there are some columns that need to be displayed to…
VBalazs
  • 67
  • 11
1
vote
1 answer

Detecting broken linked Excel Tables

I am looking how to detect if a table has a broken link or not without resorting to attempting to use the table and have my access db error out. I universally have found that every resource uses code similar to this: If Len(TableName.Connect) > 0…
L.P.
  • 169
  • 1
  • 9
1
vote
1 answer

How can I refresh a linked table in VBA when it contains a multi-valued field?

I have some VBA that programmatically updates the location of linked tables so that the front end of my database can be easily pointed at a different back end, without needing to click around in the Linked Table Manager. The technique is explained…
sjy
  • 2,702
  • 1
  • 21
  • 22
1
vote
0 answers

Equivalent to Linked Tables in MS Access on SQL Server

After searching I did not find answer to my question. If I have linked table in Microsoft Access I have table updates every time if data changed. I am now using SQL server and I have a stored procedure collecting data from many tables. I want this…
Yaman Alsaadi jbawi
  • 11
  • 2
1
vote
1 answer

Retrieve column descriptions from SQL Server-linked table in MS Access

I am linking to tables in SQL Server from an MS Access front-end. There are column descriptions for some of the tables in SQL Server that I would like to bring forward when I create the linked tables in Access. Is there a way to get at the column…
mwolfe02
  • 23,787
  • 9
  • 91
  • 161
1
vote
3 answers

Retrieving rows from a table using pairs of IDs from a separate table

Given two files, sentences_detailed.csv contains 3 columns (ID, LANG and TEXT) links.csv contains 2 columns (ID1 and ID2), the ID* is linked to the ID column in sentences_detailed.csv Sample of sentences_detailed.csv: ID LANG TEXT 123 eng I want…
alvas
  • 115,346
  • 109
  • 446
  • 738
1 2 3
…
13 14