Search tables on other workstations on network

  • Thread starter Thread starter virtue
  • Start date Start date
V

virtue

I have 5 workstations that are networked together on a
simple pc machine to machine network (I don't have a
dedicated server) On each computer I have access
installed and each computer has the same access form
which updates a table on each computer. I am trying to
run a search for records in Form view which will search
through records on all 5 computers using the find/replace
feature. Can you please tell me if this is possible or
let me know if there is a better way to accomplish this?
 
Can you please tell me if this is possible or
let me know if there is a better way to accomplish this?
Click to expand...

There is a MUCH better way, if I understand correctly!

If you use a "split" database - with the tables in a shared backend
database on a server (or a workstation playing the role of a server),
and a frontend .mdb file on each user's workstation, then all users
will be able to see and share the same data. If they are working with
different subsets of the data it's still a good idea - you can use a
Query to select each user's portion of the table for viewing and
editing.
 
You should consider storing the table on only one machine and linking to it
from the other machines.
If all machines are running the same application and can share all the data,
you could go one step further and split the database into two parts, the
application itself with forms, reports etc., and the data part with only the
tables. Then you link to the tables from each application on each machine.
Access has a database splitter wiz and also a linke table manager.
Ragnar
 
How do I do that? I've tried using the linked tables
manager but when I search for a record on another machine
it wont find it. I know I am doing something wrong but
don't know what. Please let me know
Click to expand...

Well, please let us know how you have tried to do this. It's more than
a bit difficult to tell what you're doing wrong when you haven't told
us what you're doing!

You can initially link to a table in another database using File...
Get External Data... Link to connect to it. The Linked Table Manager
lets you refresh or redirect that link, once it has been initially
established. Is this the problem, perhaps?
 
Back
Top