Re: cannot write to database query
- From: Asherman <Asherman@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 19 Feb 2008 06:06:00 -0800
Thanks John
What I failed to mention is that this database was fully functioning last
month but since then the linked tables have had to be re linked to the sql
database. A collegue did suggest that I compact and repair the database but
this did not work. However whilst trying to find a solution I did a
replicate it, which fixed the problem, but when I tried it on a similar
database it did not work. Someone else told me that it looked as if the
relationships needed refreshing as some of them may still be linked
incorrectly even thought they look OK. I dont quite understand that if
anyone has any suggestions?! In the end instead of linking the tables for
the other database, I imported the ones I needed but still have the same
problem.
"John Spencer" wrote:
That means that you have created a query that is not updatable. Beyond that.
we would need to know more about your table structure and query.
As a guess you may need to use a Main form and subform(s) to control the
data entry in this situation.
In Access Help type the following in the Answer Wizard tab
When can I update data from a query
Select that from the list for an explanation of some of the causes and
alternative solutions.
Access MVP Allen Browne has summarized the reasons:
Query results will be read-only if any of the following apply:
.. 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's Recordset Type property is set to Snapshot.
.. 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.
--
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
..
"Asherman" <Asherman@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:E90C4D66-A306-482C-8D6B-A8AC3CD61CBC@xxxxxxxxxxxxxxxx
I have created a query using a table and another query but cannot write
into
it. I dont get an error message at all just a bleep. I have tried doing
the
query using the 3 tables that I need but the same thing happens. Each
query/table concerned has an ID field which is linked to each other in the
relationships area.
- Follow-Ups:
- Re: cannot write to database query
- From: Duane Hookom
- Re: cannot write to database query
- References:
- Re: cannot write to database query
- From: John Spencer
- Re: cannot write to database query
- Prev by Date: Re: Stopping mouse wheel in Access 2003
- Next by Date: Re: cannot write to database query
- Previous by thread: Re: cannot write to database query
- Next by thread: Re: cannot write to database query
- Index(es):
Relevant Pages
|
