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
22
votes
10 answers

Linked Access DB "record has been changed by another user"

I'm maintaining a multiuser Access 2000 DB linked to an MSSQL2000 database, not written by me. The database design is very poor, so you'll have to bear with me. On the 'Customer' form there's a 'Customer_ID' field that by default needs to get the…
ChristianLinnell
  • 1,368
  • 2
  • 16
  • 22
14
votes
5 answers

Changing linked table location programmatically

I have an Access database with a linked table in a second database, located in the same directory as the first. I would like to copy the whole directory to a new location (for testing) and have database one still link to the table in database two,…
Steve H
  • 141
  • 1
  • 1
  • 3
13
votes
3 answers

MS Access Link Table With VBA

How can I link a table from one MS Access Database (*.mdb or *.accdb) to another Access database in VBA? Basically I just was to use VBA to replicate what the External Data wizard does. I've googled this and I see many examples of how to update or…
Mark
  • 1,277
  • 3
  • 13
  • 27
11
votes
2 answers

linked table read only

I have an access 2003 (mdb) database on housing projects I update for our local planning office on a quarterly basis. Other folks in our office could benefit from seeing the same data. I thought the easiest way was to give them a separate access…
ako
  • 3,569
  • 4
  • 27
  • 38
9
votes
4 answers

Preserving linked tables for Access DBs in same folder when the folder changes

I've got two Access databases that share linked tables. They are deployed together in a directory and accessed via code in a Word form. How can I make sure that the links are preserved when the two databases are copied (together) to a different…
Caveatrob
  • 12,667
  • 32
  • 107
  • 187
6
votes
4 answers

Spring-boot jpa how to find entity with max value

Lets tell I have two tables. CREATE TABLE user (ID int AUTO_INCREMENT,PRIMARY KEY (ID)); CREATE TABLE points (ID int AUTO_INCREMENT, user_id int, points int,PRIMARY KEY (ID)); How can I use spring-boot jpa to request user and max points like…
passer
  • 123
  • 1
  • 2
  • 7
6
votes
1 answer

ODBC connection to MS Access database with SQLServer linked tables via DSN

So I have a msaccess database with a couple linked tables that point to an SQL Server database via DSN with a username and password built in. In my .net app I need to connect to my access database, and run queries on the linked tables. I have tried…
user2300846
  • 155
  • 2
  • 10
6
votes
1 answer

Access replacing local table with ODBC linked table preserving original name references

I am trying to replace all the local tables in my Access DB with linked tables from an ODBC data source. I am able to import the new table which comes in as "xyz_table". I want to replace the old local "table" with "xyz_table". However when I…
Baxter
  • 5,633
  • 24
  • 69
  • 105
6
votes
2 answers

Transactions using DAO and Sql Server linked tables

I'm migrating a clasic Access application to Sql Server, i.e., DAO+Linked tables. I've found a fustrating behavior: when i make changes using recordsets over linked tables, Access use more than one connection. More than one connection means more…
ricardohzsz
  • 91
  • 1
  • 4
5
votes
1 answer

How does one change the connection string of linked tables in MS Access

So I just started a new job and part of my responsibilities are to support some old Access Database applications until I can get them replaced with something better. One of the first things I noticed is that the Access Database uses Linked Tables…
John
  • 313
  • 1
  • 4
  • 8
5
votes
1 answer

Programmatically change the connection of a linked table in ms access

I have already referenced other pages for my problem but I still can't get this to work. I feel a bit slow given that I have three examples below and still can't figure this out. Changing linked table location programatically Linked table ms access…
jaromey
  • 666
  • 2
  • 10
  • 27
4
votes
2 answers

access 2010 with linked sql tables

I have a split form view with data coming from linked sql server (2008). How do I go about updating the record? Currently, it will not let me change anything in the text boxes i assume this is because the data is coming from linked tables?! In order…
Perplexed
  • 877
  • 2
  • 19
  • 32
4
votes
1 answer

MS Access - How to change the linked table path by amend the table

Below query allow me to show all linked table and its corresponding database path SELECT DISTINCTROW msysobjects.Name, msysobjects.Database, msysobjects.Connect FROM msysobjects WHERE (((msysobjects.Type)=6 Or (msysobjects.Type) Like "dsn*")) ORDER…
useR
  • 3,062
  • 10
  • 51
  • 66
4
votes
2 answers

Entity Framework Does Not Get Linked Table

I have simply two classes (also tables - using code-first mvc5) When I try to get user, user's company doesnt come with EF6. Why is that? Model: public class TblUser { public int Id { get; set; } public string UserName { get; set; } …
Polat Dundar
  • 76
  • 9
4
votes
1 answer

How to link Access table to SQL Server with VBA

I am trying to create a linked (or imported) table in Access with a SQL Server backend. Basically the business users periodically need a copy of the table [SQL Rulesnew] (yes, with the space, sigh) so we want to give them a little Access 2003 tool…
Our Man in Bananas
  • 5,809
  • 21
  • 91
  • 148
1
2 3
…
13 14