Win XP Pro
Access 97
MySQL 4.0.x
I'm attempting to convert a number of apps to MySQL backends. Having
converted the tables from the MDB backend, I'm running into a number of
differences in behavior between the app using the MDB backend and that
using the MySQL backend.
Several problems seem to boil down to the following: A "Single Form"
view form which allows users to both edit existing records and add new
records. "Allow Edits/Additions/Deletions" set to YES; "Data Entry" set
to NO.
With the MDB backend, if there are no records in the recordset
associated with the form, all of the form's controls are visible, with
defaults set, ready to create a new record. With the same form and the
MySQL backend, the form opens plain grey - no controls are visible,
apparently because there is no Current Record.
What can I do to the MySQL-related for to restore the
let-user-add-a-new-record behavior which works so well with the MDB
backend?
TIA,
-Dave
--
"Sometimes what seems to be enough smoke to guarantee a robust
fire is actually just a cloud of dust from a passing bandwagon."
- Daniel Dennett