Moving Access queries from a DB to another

Hello,

I need to move several Queries from an Access 2000 db to another one. Using
OpenSchema, I can get the list of existing views, but I do not want to have
to read all the fields and to use CREATE VIEW to recreate all queries. I
look for something that allow me to copy the SQL text from one db to
another. Is that possible? Any hint will be appreciated.

thank you in advance
serge


.

Relevant Pages

  • Re: Moving Access queries from a DB to another
    ... I do about the same thing than you using OpenSchema, ... Access VBA code to do any metadata changes from one database to another. ... an empty access database with the clients version and adds any new tables, ... I need to move several Queries from an Access 2000 db to another one. ...
    (borland.public.delphi.database.ado)
  • Re: How to list all queries only of a database in a combobox.
    ... Hint: you could find this out for yourself if you change the WHERE clause to ... rather than allenbrowne at mvps dot org. ... > i got idea from other post to list all tables & queries of a database ...
    (microsoft.public.access.forms)
  • Re: sms 2.0 xp sp2 factory enumeration failure RPC server unavaila
    ... > HTH, ... >> MMC ...
    (microsoft.public.sms.admin)
  • Re: How to pass bind variable value into a view
    ... The hint should not be in your create statement, but in your select from the view, so something like: ... Furthermore, if you alias your viewname in the query, you should use the same alias, so not the actual viewname in your hint, like ... Views were dynamically generated by the program, so all we could do was hint the queries this way. ...
    (comp.databases.oracle.server)
  • Re: Oracle does not choose proper Index
    ... One important thing I forgot to metion is that both queries have ... FIRST_ROWS hint. ... Prev by Date: ...
    (comp.databases.oracle.server)