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

edit a read only access form

P: n/a
I created an Access 2000 form from a query. But I cannot edit it. I can
flip through the records. If I create a table from the query
(maketable) and then create the form from the table, it is editable.
But that is not the way I want it. Any suggestions?

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Make sure the form's AllowEdits property is set to Yes.

If the form is based on a query, open the query itself, and see if you can
edit there. You won't be able to get the form editing if its source query
won't.

Examples of things that will make your query read-only:
.. It has a GROUP BY clause (totals query).

.. It has a TRANSFORM clause (crosstab query).

.. It contains a DISTINCT predicate.

.. It uses First(), Sum(), Max(), Count(), etc. in the SELECT clause
(performs aggregation).

.. It involves a UNION.

.. It has a subquery in the SELECT clause.

.. It uses JOINs of different directions on multiple tables in the FROM
clause.

.. The query is based on another query that is read-only (stacked query.)

.. Your permissions are read-only (Access security.)

.. The database is opened read-only, or the file attributes are read-only, or
the database is on read-only media (e.g. CD-ROM, network drive without write
privileges.)
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

<li*********@libertyresources.org> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...
I created an Access 2000 form from a query. But I cannot edit it. I can
flip through the records. If I create a table from the query
(maketable) and then create the form from the table, it is editable.
But that is not the way I want it. Any suggestions?

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.