Remote system - How do I move forms, queries etc?

P

Pat Backowski

Hi Everyone,

I manage a customer's 2003 database remotely via a dialup connection.
When I need to send them a new form and/or queries, I export the
new/modified bits into an empty temp database, email them the database, and
then dialup and import the bits into the customer's database.

I'm having a problem losing links in queries where not all tables referenced
in the queries are present in the temp database, but are in the final
database.

Is there a way around this?

Kind Regards,
Pat.
 
D

Douglas J. Steele

All you need do is send them a new version of their front-end, which they
then use to replace their existing front-end.
 
P

Pat Backowski

Hi Douglas,

I started to have one of the "Doh" moments (why didn't I think of that?) and
then realised that the reason I don't do that is having to relink all the
tables when I put the front-end back on their system. Or am I missing
something?

Thanks,
Pat.
 
K

Klatuu

In the form that loads when you start the app, put code in to link the
tables. This is not a bad idea in any case because when you relink, you will
know if there are any problems before the app starts up. I would suggest the
Open event because it can be canceled and the app aborted if there are any
problems.
 
Top