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
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