Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 08-14-2019, 09:18 AM   #1
Learn2010
Newly Registered User
 
Join Date: Sep 2010
Posts: 404
Thanks: 92
Thanked 0 Times in 0 Posts
Learn2010 is on a distinguished road
Thumbs up Linked Tables or Not Linked

I have several linked tables in a database. They are linked to two other databases. I am sure you guys can answer this. Is it more efficient to use linked tables for queries or is it better to use the Append To Another Database? I am trying to speed up the queries.

What do you think?

Thank you.

Learn2010 is offline   Reply With Quote
Old 08-14-2019, 09:32 AM   #2
theDBguy
Im here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 5,783
Thanks: 57
Thanked 1,267 Times in 1,248 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Linked Tables or Not Linked

Hi. In a typical database setup, the data is stored externally to the query (and forms), so not sure how one could consider storing a copy of a table locally for use in a query. If it's a select query, maybe. Otherwise, it may not make much sense to do it.
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is offline   Reply With Quote
The Following User Says Thank You to theDBguy For This Useful Post:
Learn2010 (08-14-2019)
Old 08-14-2019, 10:01 AM   #3
isladogs
High Noon Moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 10,980
Thanks: 114
Thanked 3,003 Times in 2,730 Posts
isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold
Re: Linked Tables or Not Linked

If the tables are normalised & queries are well designed, these should be almost as fast using linked tables as with local tables.
This link may help you look at ways of Optimising Queries:
http://www.mendipdatasystems.co.uk/s...s-8/4594556613

__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Colin (Mendip Data Systems)
Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


"As we know, there are known knowns; there are things we know we know. We also know there are known unknowns; that is to say we know there are some things we do not know. But there are also unknown unknowns the ones we don't know we don't know. It is the latter category that tend to be the difficult ones" Donald Rumsfeld
isladogs is offline   Reply With Quote
The Following User Says Thank You to isladogs For This Useful Post:
Learn2010 (08-14-2019)
Old 08-14-2019, 10:14 AM   #4
Learn2010
Newly Registered User
 
Join Date: Sep 2010
Posts: 404
Thanks: 92
Thanked 0 Times in 0 Posts
Learn2010 is on a distinguished road
Re: Linked Tables or Not Linked

I have a SQL backend. I have a database that the team takes with them out in the field. When I open the main database it reloads that database. Also, if they make certain changes to records in the main, it updates the field DB.
Learn2010 is offline   Reply With Quote
Old 08-14-2019, 10:31 AM   #5
isladogs
High Noon Moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 10,980
Thanks: 114
Thanked 3,003 Times in 2,730 Posts
isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold
Re: Linked Tables or Not Linked

When you say the database is taken out in the field, are they using a wired connection or wireless?
Do users have the FE on the field workstation or do they remote connect to the network?
__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Colin (Mendip Data Systems)
Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


"As we know, there are known knowns; there are things we know we know. We also know there are known unknowns; that is to say we know there are some things we do not know. But there are also unknown unknowns the ones we don't know we don't know. It is the latter category that tend to be the difficult ones" Donald Rumsfeld
isladogs is offline   Reply With Quote
The Following User Says Thank You to isladogs For This Useful Post:
Learn2010 (08-14-2019)
Old 08-14-2019, 10:36 AM   #6
Learn2010
Newly Registered User
 
Join Date: Sep 2010
Posts: 404
Thanks: 92
Thanked 0 Times in 0 Posts
Learn2010 is on a distinguished road
Re: Linked Tables or Not Linked

The one in the field is a stand-alone version. The main DB loads it up with data. They go out, meet with a client, collect information, return to the office, and upload it into the main.

Last edited by Learn2010; 08-14-2019 at 10:53 AM.
Learn2010 is offline   Reply With Quote
Old 08-14-2019, 10:53 AM   #7
isladogs
High Noon Moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 10,980
Thanks: 114
Thanked 3,003 Times in 2,730 Posts
isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold
Re: Linked Tables or Not Linked

Perfect!
So are your queries making full use of the local copy of the SQL backend...or are these local copies of the tables in the FE?

__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Colin (Mendip Data Systems)
Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


"As we know, there are known knowns; there are things we know we know. We also know there are known unknowns; that is to say we know there are some things we do not know. But there are also unknown unknowns the ones we don't know we don't know. It is the latter category that tend to be the difficult ones" Donald Rumsfeld
isladogs is offline   Reply With Quote
The Following User Says Thank You to isladogs For This Useful Post:
Learn2010 (08-14-2019)
Old 08-15-2019, 05:34 AM   #8
Pat Hartman
Super Moderator
 
Join Date: Feb 2002
Location: Stratford,Ct USA
Posts: 28,253
Thanks: 15
Thanked 1,592 Times in 1,512 Posts
Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all
Re: Linked Tables or Not Linked

Since the field copy is recreated each time, it would probably be just as easy to make the tables local when you create the travelling copy.

__________________
Bridge Players Still Know All the Tricks
Pat Hartman is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
[SOLVED] Editing in a query linked to a linked table NSAMSA Queries 3 01-08-2016 01:34 PM
[SOLVED] Insert/update values into linked table (linked from sql server via odbc connection) dejanc Tables 2 12-17-2015 04:31 AM
Linked Forms - Subform is Linked to table not form Klegg72 Forms 0 03-14-2011 06:47 PM
Linking Tables and Creating Reports based on those linked tables rexmorgan Tables 1 01-30-2011 08:03 PM
Linked tables Mozz Tables 2 11-28-2006 11:01 PM




All times are GMT -8. The time now is 05:01 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World