G
Guest
Using Access2003, recently split the db to a FE/BE with BE on server and FE
on each user workstation. All are folders are rwx.
In a nutshell:
I have an issue with one field on a form being updated in the FE (I even
requery the form and it shows updated) but if I close the FE and go and look
in the BE it shows the old data. When I reopen the FE it shows the old data.
Occassionally I will get the "search key not found" error and the record has
become corrupt. I have been able to recover the corrupt record using the
compact and repair utility.
The problem did not occur when the DB was not split, I am sure it is the VBA
code I have written around this field, as the other data entered in the form
saves just fine.
Details of the problem:
I have a customer info form. After the form is filled out the data is stored
in two tables. TableA holds the customer name and type of company. TableB
contains the address for each branch the customer has. There is a
relationship between TableA and TableB on CompanyId. The problem field is in
TableA the company type . It is a pull down dialog with a bunch of choices
from a third TableC on the form and is saved in TableA as a number field.
There is a relationship between TableA and TableC on TypeId.
I am currently using a single sql query to update the data in both TableA
and TableB. (Using the recordset edit and doevents commands).
I am going to try to create two separate sql queries and updates to see if
that helps but thought I would throw this out there to see if anyone had any
additional suggestions before I go down into the debugging hole. Thanks
on each user workstation. All are folders are rwx.
In a nutshell:
I have an issue with one field on a form being updated in the FE (I even
requery the form and it shows updated) but if I close the FE and go and look
in the BE it shows the old data. When I reopen the FE it shows the old data.
Occassionally I will get the "search key not found" error and the record has
become corrupt. I have been able to recover the corrupt record using the
compact and repair utility.
The problem did not occur when the DB was not split, I am sure it is the VBA
code I have written around this field, as the other data entered in the form
saves just fine.
Details of the problem:
I have a customer info form. After the form is filled out the data is stored
in two tables. TableA holds the customer name and type of company. TableB
contains the address for each branch the customer has. There is a
relationship between TableA and TableB on CompanyId. The problem field is in
TableA the company type . It is a pull down dialog with a bunch of choices
from a third TableC on the form and is saved in TableA as a number field.
There is a relationship between TableA and TableC on TypeId.
I am currently using a single sql query to update the data in both TableA
and TableB. (Using the recordset edit and doevents commands).
I am going to try to create two separate sql queries and updates to see if
that helps but thought I would throw this out there to see if anyone had any
additional suggestions before I go down into the debugging hole. Thanks