Hi,
I use Access 2000. FEBE design. Tables on server, and everything else
on local machine. I have 1 table with a primary key ID field and a
text field with names in it. This table is like a translator. I have a
form that gets a text field from another table with numbers seperated
by commas. The form translates this using the translator table and a
module. So like 99,34,23, will be translated to bob,mary,tom,. Again,
99 34 and 23 are from the ID field in the translator table, while bob
mary and tom correspond to the text fields in the translator table.
The problem occurs when a person opens the translator table on one
computer and on another the form is opened, the form freezes. As soon
as the table is closed the form works fine. I tried fixing this by
putting the translator table in a query or another form but still the
form freezes. Any help is appreciated. I don't now what else I can do
at this point.
Thanks in advance.