Is there any hashing in access linked table

Is there any hashing in access linked table?

I mean..did the link table take data into access from ms sql.... ?

or it will directly connect to ms sql at runtime and manipulates data?
jaisonshereenAsked:
Who is Participating?
 
jmoss111Connect With a Mentor Commented:
Using linked tables you are basically using sql server in access like a file server or top half of the .gif illustration.
0
 
dportasConnect With a Mentor Commented:
The data gets re-queried at run time.
0
 
jmoss111Commented:
Hello jaisonshereen,

A linked table can be imported into Access, and it can manipulate data if there are unique keys in sql or a timestamp. The connection is always alive as long as there is a link.

Regards,

Jim
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
jmoss111Commented:
See attached .gif for explanation
sqlservervsfileserver.gif
0
 
jaisonshereenAuthor Commented:
jmoss111: So you mean...hashing is possible manually through coding ... and it can be imported to a access table from link table.... right?

if we double click and open data of a linked table in access that data is actually resides in ms sql not in ms access...right?
0
 
jmoss111Commented:
This question is already closed but there are much better (faster, less bandwidth) ways to Access than using linked tables.
0
 
jaisonshereenAuthor Commented:
i requested for opening the thread!
0
All Courses

From novice to tech pro — start learning today.