By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,326 Members | 1,899 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,326 IT Pros & Developers. It's quick & easy.

Behavior Problems with MySQL

P: n/a
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
Nov 13 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.