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
0
votes
2 answers

Measuring MS Access SQL query duration

I'm trying to compare MS Access SQL queries for local table vs linked table (it is linked to an Oracle and to a SQL Server database). I can get query duration when running the SQL command directly on Oracle or SQL Server, but when running the SQL…
itsho
  • 4,640
  • 3
  • 46
  • 68
0
votes
1 answer

How to Relink Linked Table on Server without MS Access?

In my asp.net webpage I am loading data from an .accdb MS Access database that has tables that are linked to another .mdb database. My website works fine on my own dev machine. When I upload it to the webserver, the path to the linked database…
bgmCoder
  • 6,205
  • 8
  • 58
  • 105
0
votes
1 answer

Can you link Access 2010 front end to Access 2003 back end?

Maybe I haven't had enough cawphee but teh googles are failing me at the moment. Before I undertake this huge job within my company, does anyone know if a 2010 front end can link to a 2003 back end?
Johnny Bones
  • 8,786
  • 7
  • 52
  • 117
0
votes
1 answer

Make ODBC Linked Access Table Available to Users

I have an SQL database with an MS Access front-end. The linked table I created is only available to me and no one else. I need the other users on the domain to be able to open this linked table. When they open the table, they get an error message…
i_got_roaches
  • 3
  • 1
0
votes
1 answer

sending a table of data in Microsoft Excel Power Pivot including all calculated fields back to excel as a linked table

I have used Power Pivot to create some calculated fields from a table of data. Then I use the modified table, with the calculated fields to create some pivot charts back on the excel workbook. In the same way I linked the original dataset (excel…
yoshiserry
  • 20,175
  • 35
  • 77
  • 104
0
votes
1 answer

Unicode characters not saving with Access front end linked to sql table

I have an old access database that I have converted to Office 2010 format and then moved the one data table to SQL. There is only one form that is associated with the one linked table. Once it was all done I compared the data from before and after…
goneos
  • 319
  • 2
  • 4
  • 16
0
votes
1 answer

Connect to remote Access 2003 database which has linked tables

I've got this scenario: I developed a C# application which connect to a mdb file (Access 2003) through OleDBConnection (engine = Microsoft.Jet.OLEDB.4.0). This mdb file has some linked tables in another mdb file in the same directory. Everything…
lupus
  • 26
  • 5
0
votes
1 answer

Linking to new SQL Server tables from an Access front-end

I'm using Access as a front-end for SQL Server. I was able to link the tables no problem. I was happily developing my user interface when I realized I needed a new table in my database. I created that and populated it in SQL Server. Now I want…
AM Dagoski
  • 11
  • 1
0
votes
0 answers

Web2py linked tables error with Field type

I am trying to link two mysql tables in web2py which have a column with identical entries (different rows though). I want to display the first table in a grid and have a link that displays the appropriate entries of the second table. So far this is…
Makis Ladoykakis
  • 111
  • 2
  • 8
0
votes
1 answer

MS Access updating linked table producing invalid argument error

I am trying to update a linked table in SQL Server through MS Access and I am getting an Invalid argument error. Does anyone know how to fix this error? UPDATE 1 This is the call I am making and it is failing: sql = "UPDATE user INNER JOIN myusers…
mpora
  • 1,411
  • 5
  • 24
  • 65
0
votes
0 answers

Change the location of the linked tables all at once in Access 2010

I have an Access database that I need to move from one server to another and therefore the path of the linked tables will need to change to the new location and I wonder if there is any way to do this for all the tables at once instead of using the…
Adriana Radu
  • 1
  • 1
0
votes
1 answer

Don't enter record if already exists, access linked table to sql

I have an application which has access front end and sql back-end. It used to be Access=>Access but it got migrated. The problem occurs in a linked table where entering an already existing record used to just display a user friendly (this record…
AngelicCore
  • 1,413
  • 3
  • 22
  • 40
0
votes
2 answers

How to execute query only for existing tables?

I'm using MS Access 2003 and I have a "long" query like SELECT * FROM [Table 1] UNION ALL SELECT * FROM [Table 2] UNION ALL SELECT * FROM [Table 3] .... SELECT * FROM [Table 100] Each of table linked to a certain table from HTML file. Sometimes…
mbigun
  • 1,304
  • 4
  • 19
  • 46
0
votes
1 answer

How to link HTML document with several tables to MS Access database

My purpose is to link *.html document to MS Access database and export it to *.XLS file. The problem is my *.html file contains more than 50 similar tables. If I'm using "Link HTML Wizard" it looks like Here I can choose the particular table from…
mbigun
  • 1,304
  • 4
  • 19
  • 46
0
votes
1 answer

Refresh table link

I found the following function while browsing the Web that allows me to dynamically link a table to my Access database at the execution: Function createAttached(strTable As String, strPath As String, strBaseTable As String) As…
dan
  • 3,439
  • 17
  • 54
  • 82
1 2 3
…
13
14