Re: Help! Have I lost my query?

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

From: John Viescas (JohnV_at_nomail.please)
Date: 03/20/04 

Date: Sat, 20 Mar 2004 14:56:36 -0600

Stacy-

Setting Tools / Options / Advanced / Default File Format to Access 2003
affects only any new database you create. Access 2003 can work with either
2000 or 2002/2003 format.

What did you name the query? Some query names are "reserved" and will be
hidden by default - such as any query beginning with "USys". You can try
going to Tools / Options / View and check Hidden Objects and System Objects
under Show. If you find the query that way, you can try renaming it. Also
select the query in the database window, right-click, and choose Properties
from the shortcut menu. Make sure the Hidden property is unchecked. 

-- 
John Viescas, author
"Microsoft Office Access 2003 Inside Out"
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
(Microsoft Access MVP since 1993)
"Stacy" <anonymous@discussions.microsoft.com> wrote in message
news:675571DE-3777-4903-A463-BFBFB540BF57@microsoft.com...
> I recently installed Access 2003 over Access 2000. I built a new query
yesterday to an old database. Now it's simply gone! When I open Access, all
my old queries are there, but the one I built yesterday isn't. What do I do?
When I open the database, it says "Access 2000 File Format." Is it possible
that I built my new query in 2003 file format and that's why it doesn't show
up? Can I recover it? I tried opening the database, then using
tools...options...advanced...to change the default file format to "Access
2003" No good.
>
> Please help...otherwise I've just lost many hours of work!
>
> Thanks,
> Stacy

Relevant Pages

  • Re: DBMS and lisp, etc.
    ... Naively implemented with SQL, again for 10 ... (1 query for the initial orders, 1 query for each order for its ... soon as you upgrade to the SQL database. ... (eq (order-customer orderA) ...
    (comp.lang.lisp)
  • Re: OT: SQL
    ... query processing. ... FROM Employees e, Employees m, Management mgt ... Manager and Employee Salaries. ... The scheme used does not model database files in general, ...
    (sci.logic)
  • Re: access 2003
    ... I removed the parameters from the form query source. ... boxes from the form header, events, code, etc and ran the form query source ... forms queries and the SQL because syntax of the SQL will change randomly. ... the Access 97 database, I wouldn't have thought any expressions would be ...
    (microsoft.public.access.conversion)
  • RE: Import external data - web query
    ... Your reply for my query is very extensive, this is for importing a file from ... The data source I want isn't listed in the Select Data Source dialog box. ... information used to connect to a database. ... Check your driver First, make sure you have the right ODBC driver (Open ...
    (microsoft.public.excel.misc)
  • Re: access 2003
    ... I removed the parameters from the form query source. ... synchronize combo boxes to the detail section or the parameter form query ... forms queries and the SQL because syntax of the SQL will change randomly. ... the Access 97 database, I wouldn't have thought any expressions would ...
    (microsoft.public.access.conversion)