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

MSAccess Missing Column After Relinking Table

I am trying to add a pull-down combo box to a form in MSAccess. The strange part is that the (email) column is missing. I have performed the following checks/actions Validated the SQL table (SUP_CONTACTS) has the desired column Validated MS Access…
NanoNet
  • 218
  • 3
  • 11
-1
votes
1 answer

How do I add linked tables to a microsoft access database where the source is stored on Google Drive (for free)?

So for context, I have a database backend that is stored in Google Drive and I have a frontend with an interface, forms, and reports. The current solution that we have is that all employees in the company have Google Drive for desktop and the source…
Astro Mec
  • 61
  • 1
  • 4
-1
votes
1 answer

Access 2010 Query Execution Crash

In Windows 10 and MS Access 2010, I am running a vba function that executes a SQL query extracting records from a linked a table that is linked to Outlook. The query looks like this: select * from where LinkedTable.Field1 like '*string1*' and…
Dave Branson
  • 5
  • 1
  • 4
-1
votes
1 answer

ACCESS 2007, Linked Table, Locking Back End DB for other users when open

I have a problem with tables linked to BE database. Opening the table on FE database with linked tables by specific user locks the BE database for others, even for read. An error Run-time 3045 comes when somebody wants to use a linked table. Same…
Fryta
  • 11
  • 5
-1
votes
1 answer

Linked Access table to ODBC Database doesn't show all columns

I am creating a database in Access 2013. I need to create a few tables that are linked to a SQL Server that other Access queries will use to get data. No information will be returned to the SQL Server, the tables are for information only. I tried…
Mackles24
  • 111
  • 1
  • 8
-2
votes
1 answer

Two databases to one linked table on SQL

We have an Access database that is currently doing an append query on a table on another database. We have moved all the tables to a SQL Server 2008 database. The dba used the SSMA tool to migrate the tables to the SQL Server database thus…
KevLRay
  • 1
-3
votes
2 answers

SQL request 3 linked tables

I have 3 Tables: And i want this result: I try with order by but, it did not work, Someone have an idea
Alexandre Libert
  • 41
  • 6
1 2 3
…
13
14