New query in front-end: " is not a valid name

I have just started using Access 2007, and I am converting from an old, but
very reliable db. I am trying to re-create a query based on two tables. In
design view, I select the first table, but when I select the second table, I
get the following message:

" is not a valid name. Make sure that it does not include invalid
characters or punctuatiion and that it is not too long.

I am using a front-end, and a back-end db. In the back-end, I can create
the query just fine. But if I try to create the same query in the front-end,
I get the above message.

Help, please! :-)

Patti


.

Relevant Pages

  • Re: Front-end db run Parameter query in back-end Access db using ADO?
    ... Realistically, all queries should be in the front-end, not the back-end. ... I have a parameter query in a back-end Access database that I would like ... Can I call this parameter query from a front-end Access database and pass ...
    (microsoft.public.access.queries)
  • Re: Deleting a table in the backend using VBA
    ... You've described "how" you want to do something (delete a back-end table ... in the front-end to clear it out and reload it with the new ... set of data (append query). ... I am trying to delete a table in the backend database using code in the ...
    (microsoft.public.access.modulesdaovba)
  • Re: RWOP queries for back-end secuirty: easy/hard? slow/fast?
    ... raw data directly from the back-end database. ... using RWOP queries in the front end, helps to close this hole somewhat, ... other methods of querying data beyond a straightforward Access query. ... Then you can give the Manager group permissions to rwopPayManager and everyone permission to rwopPayEmployee. ...
    (comp.databases.ms-access)
  • Re: Split Database Difficulties
    ... This query will give you the list of tables in the back end: ... If a table in a back-end database is renamed then it is no longer visible to ... to reimport the back-end into the front-end and then re-split it. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Front-end db run Parameter query in back-end Access db using ADO?
    ... The only reason that I wanted to keep this query in the back-end was because ... having to have the front-end link all the tables. ... active open recordsets against those tables? ...
    (microsoft.public.access.queries)