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

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.

Pat,

Have a look at this Web site which may help.
http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='BE%20Update%20Utilit y.mdb'

HTH

Peter Hibbs.


On Mon, 3 Mar 2008 02:54:00 -0800, Pat Backowski
wrote:

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.

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

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Pat Backowski" wrote in message
...
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.

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.

"Douglas J. Steele" wrote:

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

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Pat Backowski" wrote in message
...
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.

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.
--
Dave Hargis, Microsoft Access MVP


"Pat Backowski" wrote:

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.

"Douglas J. Steele" wrote:

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

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Pat Backowski" wrote in message
...
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.

Pat,

You can find code to relink the tables at :-

http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='BE_ReLink.mdb'

HTH

Peter Hibbs.

On Mon, 3 Mar 2008 06:35:01 -0800, Pat Backowski
wrote:

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.

"Douglas J. Steele" wrote:

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

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Pat Backowski" wrote in message
...
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.