RE: Error in 2007 but not in 2003 - suggestions please

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Ron2006,

i had the same problem when i upgraded from 2003 to 2007 using SQL Server
2000 as a backend db. on the forms that i was getting an error on (record
not found in this query) i had to create and save the forms query in the
query section (i used a SQL statement in the record source originally, then
changed it to the query name), that seemed to fix the problem.

"Ron2006" wrote:

Here is the scenario.

An application runs just fine in 2003 but I am getting two different
types of errors in the when trying to do things in the same mdb in
2007.

Error 1:
- multiple tabs on a form
- each tab has independent subforms and query
- The subform record source is empty until the tab is touched at which
time it is loaded IF the source was empty (meaing the tab had NOT been
touched before)
- If I touch tab 1 - source is loaded - query executes correctly -
records appear
- then if I touch any other tab I get an error message indicating that
the query cannot find tablename.fieldname asking for a value.
- If I don't cancel it, the query executes but I get this message
twice.
- If I then touch tab 1 again, the same combination of errormessages
now appear.
- This occurs no matter which tab is the first tab touched and no
matter which tab is the second one touched.
- THE FIELD THAT IS REFERENCED IS NOT IN ANY OF THE QUERIES INVOLVED
IN ANY OF THE SUBFORMS.

Related Error 2:
- If I enter the DB in design mode and go to any of the queries
involved in these tabs the following happens:
- If I execute the query, it runs properly.
- If I then right click and ask for SQL view of this query, I can see
it.
- If I however right click it and ask for the design view I get the
following error message:
'' is not a valid name. Make sure that it does not include invalid
characters or punctuation and
that it is not too long.
- After I press the OK button, the message disappears BUT the the
design view for the query DOES NOT appear.

I have updated Office 2007 to include all of the latest updates.

The same mdb operates properly with no errors at all when executed
under Access 2003.

Ron

.

Relevant Pages

  • Re: Jet SQL and Virtual tables/subqueries qiestions
    ... Perahps we've begin to uncover some bugs in the Access query ... If you PASTE SQL test in the following format into the SQL window ... around a field or table name within the VirtTbl1 subquery, ... I would think that producing a correct error message for that sort of query ...
    (microsoft.public.access.queries)
  • Re: How do I temporarily limit values in a query field
    ... I am getting an error message: "The expression you entered has a invalid ..or! ... This is the last few lines of the 'old' sql with an attempt to limit the records to values of <500: ... works fine until I try to put limits on it value in the qryClaimDetails query. ...
    (microsoft.public.access.queries)
  • Re: Delete Records From One Table that are Duplicated in Another
    ... Your error message indicates Access / JET think there are 2 Tables involved ... Post your Table Structure and the SQL String of your Query. ... I linked them on the Loan# ...
    (microsoft.public.access.queries)
  • Re: 3061 Error when doing everything that works in another module.
    ... Error message states that 1 parameter is expected. ... > I assume that the SQL statement is a properly delimited text string in your ... is this a reference to using the design view ... > of a query to create the SQL statement and to run the query? ...
    (microsoft.public.access.modulesdaovba)
  • Re: 3061 Error when doing everything that works in another module.
    ... built the SQL string in the query designer. ... > Error message states that 1 parameter is expected. ... >> of a query to create the SQL statement and to run the query? ...
    (microsoft.public.access.modulesdaovba)