PC Review


Reply
Thread Tools Rate Thread

Copying tables

 
 
=?Utf-8?B?QW1hdGV1cg==?=
Guest
Posts: n/a
 
      5th Sep 2006
Dear Sirs
I have two Access databases where I copy a table from one to the other
database on the same computer.
The purpose of this is that I need the target database (which is much
smaller than the source database) on my lap-top for marketing purposes.
So, as long as I have the target database table on my computer (where as
well the source database is) everything is fine and I can see the data. As
soon as I transfer the target database to my lap-top all data is gone.
How can I avoid this?
 
Reply With Quote
 
 
 
 
Jeff Boyce
Guest
Posts: n/a
 
      5th Sep 2006
If you "link" from your laptop to the desktop tables, you can run append
and/or update queries against the data in the desktop system, to update the
tables in the laptop system.

When your laptop is not connected to your desktop, the links won't work (but
then, you would have already copied the data you need into your laptop
tables, right?!

Regards

Jeff Boyce
Microsoft Office/Access MVP


"Amateur" <(E-Mail Removed)> wrote in message
news:05F238D5-726B-4371-97C2-(E-Mail Removed)...
> Dear Sirs
> I have two Access databases where I copy a table from one to the other
> database on the same computer.
> The purpose of this is that I need the target database (which is much
> smaller than the source database) on my lap-top for marketing purposes.
> So, as long as I have the target database table on my computer (where as
> well the source database is) everything is fine and I can see the data. As
> soon as I transfer the target database to my lap-top all data is gone.
> How can I avoid this?



 
Reply With Quote
 
=?Utf-8?B?QW1hdGV1cg==?=
Guest
Posts: n/a
 
      6th Sep 2006
Hi Jeff
You are correct, when my laptop is not connected to my desktop, the links
won't work, but the data which was transferred before, is gone as well - that
is my problem and I don't know how to solve that.
In short, as soon as I have the base on my Laptop my tables are emtpy.
Any idea why and how I can avoid that?
Regards
Klaus

"Jeff Boyce" wrote:

> If you "link" from your laptop to the desktop tables, you can run append
> and/or update queries against the data in the desktop system, to update the
> tables in the laptop system.
>
> When your laptop is not connected to your desktop, the links won't work (but
> then, you would have already copied the data you need into your laptop
> tables, right?!
>
> Regards
>
> Jeff Boyce
> Microsoft Office/Access MVP
>
>
> "Amateur" <(E-Mail Removed)> wrote in message
> news:05F238D5-726B-4371-97C2-(E-Mail Removed)...
> > Dear Sirs
> > I have two Access databases where I copy a table from one to the other
> > database on the same computer.
> > The purpose of this is that I need the target database (which is much
> > smaller than the source database) on my lap-top for marketing purposes.
> > So, as long as I have the target database table on my computer (where as
> > well the source database is) everything is fine and I can see the data. As
> > soon as I transfer the target database to my lap-top all data is gone.
> > How can I avoid this?

>
>
>

 
Reply With Quote
 
Jeff Boyce
Guest
Posts: n/a
 
      6th Sep 2006
If the data is gone, then there's a very good chance the data hasn't
actually copied over. I suspect the link, not the actual data, is what's
being seen.

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Amateur" <(E-Mail Removed)> wrote in message
news:AC7C083E-9ADE-4802-B5BB-(E-Mail Removed)...
> Hi Jeff
> You are correct, when my laptop is not connected to my desktop, the links
> won't work, but the data which was transferred before, is gone as well -
> that
> is my problem and I don't know how to solve that.
> In short, as soon as I have the base on my Laptop my tables are emtpy.
> Any idea why and how I can avoid that?
> Regards
> Klaus
>
> "Jeff Boyce" wrote:
>
>> If you "link" from your laptop to the desktop tables, you can run append
>> and/or update queries against the data in the desktop system, to update
>> the
>> tables in the laptop system.
>>
>> When your laptop is not connected to your desktop, the links won't work
>> (but
>> then, you would have already copied the data you need into your laptop
>> tables, right?!
>>
>> Regards
>>
>> Jeff Boyce
>> Microsoft Office/Access MVP
>>
>>
>> "Amateur" <(E-Mail Removed)> wrote in message
>> news:05F238D5-726B-4371-97C2-(E-Mail Removed)...
>> > Dear Sirs
>> > I have two Access databases where I copy a table from one to the other
>> > database on the same computer.
>> > The purpose of this is that I need the target database (which is much
>> > smaller than the source database) on my lap-top for marketing purposes.
>> > So, as long as I have the target database table on my computer (where
>> > as
>> > well the source database is) everything is fine and I can see the data.
>> > As
>> > soon as I transfer the target database to my lap-top all data is gone.
>> > How can I avoid this?

>>
>>
>>



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copying Tables Bob Quintal Microsoft Access Form Coding 8 10th Sep 2007 02:44 AM
copying tables =?Utf-8?B?UGhpbCBSYWlkdA==?= Microsoft Access External Data 2 4th Jan 2007 10:11 PM
Copying Tables Mike Microsoft Access Forms 1 9th Jan 2004 04:38 PM
Copying Tables from one db to another Paul Fenton Microsoft Access 5 24th Nov 2003 06:17 AM
Copying tables Rick Palmer Microsoft VB .NET 2 21st Oct 2003 08:47 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:36 AM.