Solved

reading a table from another access database

Posted on 2014-09-22
4
175 Views
Last Modified: 2014-09-22
Experts,


Can I read a table in a query from a database that is located on another drive by just giving the path name.

"\\patha\libary\Reportsfoldera\folderb\WEEKLY_extracts\database_a\table_1"
0
Comment
Question by:morinia
  • 2
4 Comments
 
LVL 84

Assisted Solution

by:Scott McDaniel (Microsoft Access MVP - EE MVE )
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 200 total points
ID: 40336877
No, but you can use this syntax:

SELECT * FROM Table1 IN '\\patha\libary\Reportsfoldera\folderb\WEEKLY_extracts\database_a'

See here: http://office.microsoft.com/en-us/access-help/HV080761082.aspx
0
 
LVL 12

Accepted Solution

by:
danishani earned 300 total points
ID: 40336889
It might be easier to link the table_1 of your other Access database.
Then you can query it just like any other table.

Does that work for you?
0
 

Author Comment

by:morinia
ID: 40336986
Just curious,  can you link to a query?
0
 
LVL 12

Expert Comment

by:danishani
ID: 40336997
Just curious,  can you link to a query?

Not that I am aware of. You can however import the query, but that is not the same as linking.
Also it will not update automatically.
0

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question