P
Paulie
Greetings all,
We currently have an ADP that connects to a SQL Server 2000 database. This
ADP was working fine under Access 2003, but we have run into a number of
problems when trying to move it up to 2007.
Here is the basic setup: There is a main form (Accounts) that holds
'master' type records (Accounts), and there is a button on that form that
opens a separate form, filtered, for 'detail' type records (Transactions). Of
course, the transactions displayed when the second form is opened are
filtered by the account that was being viewed in the first form.
All of the problems that we've run into have been on the transactions form.
The latest, and the one that has us a bit mystified, is that the form is not
allowing us to insert new records. We can edit information on transactions
that are already there, but the New Record button is disabled, and nothing
can be entered in the last, blank row.
We've checked the form properties and the extended properties on all the
database objects, and they all look fine. Additionally, all the properties
are the same on the master (Accounts) form, and that form is allowing both
inserts and updates.
Can anyone give me a lead on where to start looking for a solution to this?
With all the properties apparently the same between the two forms, and no
actual error messages on an attempted insert on the detail form, we don't
have a lot go on...
Thanks in advance.
We currently have an ADP that connects to a SQL Server 2000 database. This
ADP was working fine under Access 2003, but we have run into a number of
problems when trying to move it up to 2007.
Here is the basic setup: There is a main form (Accounts) that holds
'master' type records (Accounts), and there is a button on that form that
opens a separate form, filtered, for 'detail' type records (Transactions). Of
course, the transactions displayed when the second form is opened are
filtered by the account that was being viewed in the first form.
All of the problems that we've run into have been on the transactions form.
The latest, and the one that has us a bit mystified, is that the form is not
allowing us to insert new records. We can edit information on transactions
that are already there, but the New Record button is disabled, and nothing
can be entered in the last, blank row.
We've checked the form properties and the extended properties on all the
database objects, and they all look fine. Additionally, all the properties
are the same on the master (Accounts) form, and that form is allowing both
inserts and updates.
Can anyone give me a lead on where to start looking for a solution to this?
With all the properties apparently the same between the two forms, and no
actual error messages on an attempted insert on the detail form, we don't
have a lot go on...
Thanks in advance.