Hi Willie,
Have you checked to see if the underlying query is updateable?
If it's no longer updateable it's very possible that JET 4.0 (for 2000 and
above) does not allow your query to be updateable versus JET 3.5 (Access
97). Thereby, the things I recommend you do are the following:
- Install latest service pack of JET 4.0 (service pack 8) from
http://support.microsoft.com/?id=239114
- Reboot computer and recheck query to see if it's still not updateable
- If it's still not updateable from the query then your option is (outside
of rewriting the query to an updateable query) is to change the Form's
Recordset Type to "Dynaset Inconsistent Updates"
I hope this helps! If you have additional questions on this topic, please
respond back to this posting.
Regards,
Eric Butts
Microsoft Access Support
"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<
http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <
http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."
--------------------
| Content-Class: urn:content-classes:message
| From: "Willie" <
[email protected]>
| Sender: "Willie" <
[email protected]>
| Subject: Data Entry Disabled after conversion
| Date: Sat, 7 Feb 2004 10:35:50 -0800
| Lines: 13
| Message-ID: <
[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcPtqTW9/krCEvKyT8OOsEolq5u2aQ==
| Newsgroups: microsoft.public.access.conversion
| Path: cpmsftngxa07.phx.gbl
| Xref: cpmsftngxa07.phx.gbl microsoft.public.access.conversion:39580
| NNTP-Posting-Host: tk2msftngxa13.phx.gbl 10.40.1.165
| X-Tomcat-NG: microsoft.public.access.conversion
|
| I have been operating a mailing list database for approx
| 3 years, (flawlessly). Built in Access 97, converted to
| access 2000, now converted to Access 2003. Now I find
| that I cannot enter (update) data on my forms that used
| to work perfectly. The forms are populated from a query.
| I simply cannot discover why I cannot enter data on the
| form or in the datasheet view of the query.
| I figure it is something little that changed in the
| conversion, but darned if I know where the changes are.
| I would appreciate at least a hint of where to look.
|
| Thank You
| Willie SMith
|
