Query-problem

Andren

Registered User.
Local time
Today, 02:38
Joined
Sep 3, 2002
Messages
55
Dear world forum!

I finalized my Access-db with a lot of help from you in Access 2000. Thanks!
When I now want to make a MDE-database ,Access denies that without
explanation. Trying to convert my work to Access97 I am also denied that, due to an error #3017 ("One field is to long"). I am puzzled because I have no string field that is longer than 240 positions - and 250 is max).
However - I have built a "main" query consisting of 41 fields assembled from three tables. I need that query to feed my main input form.The SQL view of all these fields are however more than 250 positions. Is that what is causing the troubles I have? And - does anyone have any idea how to overcome this problem?

Then I have another query-question. The queries I have created so far are not specified as "update-queries" but however they seam to update my tables OK when I input data through my main form (bound to my main query).
Shall I redefine my queries to become "update" queries.

Thanks in advance for any comment on this.

/ Anders
 
Your db needs to be compiled without errors before it will let you make an .mde

You don't specify that a query should produce an updatable recordset, jet does that automatically if it can. There are certain things that will prevent a recordset from being updated. Two common ones are the use of aggregates such as Sum() and Max() and improper joins.
 

Users who are viewing this thread

Back
Top Bottom