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
2
votes
1 answer

Add a contact to a linked exchange table

I am trying to build an access process to add contacts to an outlook folder. I have linked the folder and can add, update and delete records. But not all of the fields are showing up correctly in outlook. Namely the address field. I have added a…
Herrozerro
  • 1,601
  • 1
  • 22
  • 37
2
votes
1 answer

Excel to Access linked table date format issues

i have an excel sheet linked into access which has varying data type. I'm having an issue specifically with dates though. In excel dates are formated as dd/mm/yyyy. When the data reaches access is it numeric. i.e. the number that relates to the…
Ian
  • 23
  • 1
  • 3
2
votes
1 answer

updating an Access 2010 Linked Table connection

How do I change the connection string of a linked table in Access 2010? I don't want to do it programmatically but through the interface. When I try to change it via the table's Properties I get the following message:
Robert
  • 1,638
  • 7
  • 34
  • 45
2
votes
2 answers

SQL Server Relationships displayed in Access

In Access, you can setup a one-to-many relationships between tables. There is then a (+) sign in one table which links to many rows in the second table. When you click the (+) sign it shows all the rows in Table 2 that are related to Table 1. Is…
Steve
  • 729
  • 14
  • 29
2
votes
2 answers

Concurrency error with MS-Access Linked Tables

I am linking tables to a SQL 2008R2 DB via MS Access Linked Tables. I am getting this warning when I want to change the data in an Access linked table where the underlying SQL table has more than one bit field in it: The record has been changed by…
Schalk Dormehl
  • 185
  • 1
  • 5
2
votes
1 answer

Is it possible to query the linked table manager in Access 2003?

I have a directory of databases (*.mdb)s which are linked to several other *.mdb in other locations. We've split the original database from one file into two partitions. The databases in the directory point to the original database file (and a few…
leeand00
  • 25,510
  • 39
  • 140
  • 297
1
vote
1 answer

ms access 2010 update linked table with no primary key

My sql 2008 linked query data has no primary key column - because I need to bulk update duplicate rows (that are duplicate in 2 or more columns). When I link the query (I have it as a sql view for now) - the records load in the form ok. Is there a…
Perplexed
  • 877
  • 2
  • 19
  • 32
1
vote
1 answer

Issue using Access DoCmd.Rename on table: linked names not renamed

Summary: why might Docmd.Rename on a table result in tables that don't change name over a Link from another DB? I'm trying to fix up an old database that needs TLC. Part of this is deleting lots of unused cruft, amongst which are some tables. The…
rivimey
  • 921
  • 1
  • 7
  • 24
1
vote
2 answers

Is it possible to change Msysobjects in ms access

Is it possible to change MSYSObjects table values manually. Especially the Database field in MSysObjects Table Because i need to change path of linked table manually. Linked table manager is no use in my case.
Nishanthini
  • 97
  • 2
  • 4
  • 12
1
vote
1 answer

Power Query New column with Unique ID

I have an excel power query that transforms new files when added to a folder. The resultant table is then linked to a database. I would like to create a new column in power query that creates a unique ID that will never change (Always assigned to…
Philip M
  • 13
  • 2
1
vote
1 answer

How to get the columns of a linked odbc table in MS Access through SQL Query

I have linked a couple of tables in MS Access database from SQL Server and also from Excel. Now I want to query them from a Java application using jdbc. But when I run the query SELECT * FROM sys.MSysObjects Where Type = 4; I am able to see the list…
Kranthi.Gogikar
  • 31
  • 5
1
vote
0 answers

Suddenly none of my linked tables work in Access

I have a large MS Access application that uses linked tables to a SQL Server back end. The Access database links to SQL Server via ODBC. Suddenly, none of my linked tables work, if there is a unique index anywhere in the SQL table containing a text…
Bill Tidwell
  • 31
  • 2
1
vote
2 answers

Access Linked Table from SQL Shows #Delete

I created this table: CREATE TABLE [dbo].[dbo_Country] ( [Country] [nvarchar](100) NOT NULL, [ISO3166Code] [smallint] NULL, [CountryEn] [nvarchar](255) NULL, [Abriviation] [nvarchar](255) NULL, CONSTRAINT…
Mehdi Shahgholi
  • 51
  • 1
  • 9
1
vote
0 answers

Write Conflict on azure backend

I am getting a Write Conflict Error I can't seem to get around. My database has all of the tables on Azure. The tables are all linked I have a form that shows details about a specific course. I select the course by using a split form. On that form,…
Merrikay
  • 11
  • 2
1
vote
1 answer

How to access an Oracle linked table in Linq2db?

I have a linked table I access like this: SELECT Id, Name FROM MySchema.Sectors@STATS How do I define that in Linq2db? I tried: [Table(Schema = "MySchema", Name = "SECTORS@STATS")] public partial class Sector but when I try to load it, I…
Robin Bennett
  • 3,192
  • 1
  • 8
  • 18
1 2
3
…
13 14