add queries

  • Thread starter Thread starter bob engler
  • Start date Start date
B

bob engler

I have written several new queries for my test DB. They work and
I need to include them in the DBs ( at least 10 ) in various locations
that all have the tables required. I can export the queries from my
test DB to another one on my PC but how can I do it when they are
not on a common network?

Thanks.....
 
I have written several new queries for my test DB. They work and
I need to include them in the DBs ( at least 10 ) in various locations
that all have the tables required. I can export the queries from my
test DB to another one on my PC but how can I do it when they are
not on a common network?

Thanks.....
Click to expand...

Split the database. Any multiuser database should be run through the
"Database Splitter Wizard" - this puts the Tables in one ("backend")
database, and the queries, forms, reports etc. in a frontend.

With this design you can just send the user a frontend database (by
email, preferably compressed using WinZip) by email.
 
These databases are on seperate servers not connected to a common
network. The client wants to keep them seperate for his different areas.
I need to update the new queries to each DB.
 
These databases are on seperate servers not connected to a common
network. The client wants to keep them seperate for his different areas.
I need to update the new queries to each DB.
Click to expand...

Split it anyway. If each site has a frontend and a backend, you can
safely send them a new frontend; they can just overwrite their current
frontend. The data is safely in the backend and will not be harmed.
 
Back
Top