Faster Access to Table

[Guest]

I have a table on our interoffice network. When I requery it, it takes
several seconds. Is there a way to allow the user to copy the table to their
own computer, than requery the copied table on their own hard drive? I
assume that would make the access speed faster.

Thanks,

Jon Mulder Red Bluff, CA

 

[Guest]

One can import a table to the desktop and work with it locally. Presuming no
security settings prevent this.

When in the Tables tab - go up to File - and select 'Get External Data'

However - currently your Front End is set up to look at the Linked Table.
So you either need to change that - or copy that Query and name it something
like LocalQuery to differentiate it.

In the end however - end users may not be comfortable in the guts of Access
doing housekeeping stuff like this. But this is how you do it. Will it be
faster? Hard to say. You will need to experiment. If it is a superbig
query - possibly not - as it is a processing question. If it is a small
query - probably yes - as it is probably network related delays or a busy
server....

 

[Guest]

Thanks for the info.
Actually (to be more specific), I was looking to tweak some VBA code. I use
the following lines to open a table:

Set dbs = CurrentDb()
Set rst = dbs.OpenRecordset("TempNewSharesIndexedByPurchaseDate")

I'm looking at "help" at it looks like I can use "type argument =
dbOpenSnapShot". I am only using the table to look up a record, then I close
the form and table that was used to look up the record.

I appreciate your help!