Re: Moving Access queries from a DB to another

Hi Serge
This is probably not what you want to hear, but I tend to stick with MS
Access VBA code to do any metadata changes from one database to another. In
a couple lines of code, you can copy any object from one db to another.
Basically I have an MDE that i distribute with my application that compares
an empty access database with the clients version and adds any new tables,
indexes, fields, relationships, queries, forms, reports etc. You can also
call compacts and repairs.
While you can probably to it with OpenSchema (personally I have not tried
it), I would recommend attempting it in MS Access.
Regards
Dominic

"Serge Myrand" <serge.myrand@xxxxxxxxxxxxxxxxxx> wrote in message
news:4815e55a@xxxxxxxxxxxxxxxxxxxxxxxxx
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: access 2003
    ... I would focus on the queries behind the combo boxes. ... the Access 97 database, I wouldn't have thought any expressions would be ... When you select a customer and a job in the two combo boxes, ...
    (microsoft.public.access.conversion)
  • Re: access 2003
    ... I would focus on the queries behind the combo boxes. ... the Access 97 database, I wouldn't have thought any expressions would be ... When you select a customer and a job in the two combo boxes, ...
    (microsoft.public.access.conversion)
  • Re: Question on conversion to ADP
    ... the money toward developping .NET technologies instead of Access. ... result of passthrough queries read/write instead of read only and also make ... database become corrupted when the users will start making their very own ... of ADP but what they are pushed toward is - how could I say that politely - ...
    (microsoft.public.access.adp.sqlserver)
  • Re: User has group permissions to object, but still denied access.
    ... permissions to those query objects. ... The owners for the other 68 queries can be changed. ... may have been some of the original queries created in the database. ... Regarding the security, the database was converted from an Access 97 ...
    (microsoft.public.access.security)
  • Re: Access/Word 2007 Mail Merge
    ... have thought that they would have occured earlier in the connection process. ... specify DDE, I always get the DDE dialog. ... might be "unusual" about your database, its location, etc. ... This isn't quite what I normally see either: Queries with joins are ...
    (microsoft.public.word.mailmerge.fields)