Move Queries from one DB to another

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two Access 2002 databases (one test, one production) and last night I created 30+ queries in the test database. Now I need to move them over to the production database. How would I do this? The kicker is that both databases are on a web server so trying to do an export from one to the other gives me "Only XML files can be exported to an Internet address" message.
 
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

When I update a production db I just copy the development db over the
production db. Can you do that? You'd have to use FTP or something
like that. Depends on permissions on the website.

This procedure would be outside the Access environment. IOW, it is a
file transfer action not an Access export/import action.

MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQBbisYechKqOuFEgEQLgGgCfdIjCXWmQczZktAnfaF2bRcclL8sAn2Vs
/3R1QYanam8N4b2oVgxOIsO7
=ncUS
-----END PGP SIGNATURE-----
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Moving queries 4
Multiple make table queries in one? 3
Moving Access databases from my computer to another person 0
transferring mail data from one PC to another one 0
Building a query to export data to another table (diff. field name 2
Make Table Query with path Parameter 1
Problems with Append Query 1
Append and Delete in one step 3

Back
Top