H
HarvestWind
Hi,
I have some data in a multiuser program on a network that is in Paradox.
The Paradox database has a table called "Members" that I want to link to in
Access. In addition, there is more information that I want to add to
"Members", but cannot (and don't want to) modify that table. I want to put
the additional info in a table in Access and call it "Member Info".
I linked the Paradox table and it has a primary key called "ID" (Long
Integer). I prepared my table in Access and made the Primary Key "MembID"
(Long Integer). Then I used a query and populated my "Member Info" table's
"MembID" field with the data from "Members" field "ID" (that way both would
have all the same numbers to connect them).
I then used a query and related the two tables Members --> ID to MembID <--
Member Info. The query is a one-to-one join. When I run the query, all of
the records are present.
If I attempt to update the data in the query, both tables are updated with
no problem. However, I built a form with that query as the RecordSource.
When I attempt to edit any field for any record, I get a message that says
that someone else was editing the record and they saved their data before I
tried to save mine. It then tells me to try to re-edit.
I was not trying to save the data, I only had one keypress.
If I make a new table from the linked "Members" table, make the "ID" field
the primary field, replace the linked table with the new "Members"
table...then my form works fine. It has something to do with the linked
table.
Any ideas would be welcome.
Thanks in advance,
JP
I have some data in a multiuser program on a network that is in Paradox.
The Paradox database has a table called "Members" that I want to link to in
Access. In addition, there is more information that I want to add to
"Members", but cannot (and don't want to) modify that table. I want to put
the additional info in a table in Access and call it "Member Info".
I linked the Paradox table and it has a primary key called "ID" (Long
Integer). I prepared my table in Access and made the Primary Key "MembID"
(Long Integer). Then I used a query and populated my "Member Info" table's
"MembID" field with the data from "Members" field "ID" (that way both would
have all the same numbers to connect them).
I then used a query and related the two tables Members --> ID to MembID <--
Member Info. The query is a one-to-one join. When I run the query, all of
the records are present.
If I attempt to update the data in the query, both tables are updated with
no problem. However, I built a form with that query as the RecordSource.
When I attempt to edit any field for any record, I get a message that says
that someone else was editing the record and they saved their data before I
tried to save mine. It then tells me to try to re-edit.
I was not trying to save the data, I only had one keypress.
If I make a new table from the linked "Members" table, make the "ID" field
the primary field, replace the linked table with the new "Members"
table...then my form works fine. It has something to do with the linked
table.
Any ideas would be welcome.
Thanks in advance,
JP