[AccessD] Another really dumb question

rusty.hammond at cpiqpc.com rusty.hammond at cpiqpc.com
Wed Apr 2 10:50:05 CDT 2008


You're right, you can't use the Source Database to get to ODBC data sources
(ie SQL), but you can use the one right below it (Source Connect Str).  To
try it out, just copy the connection string from a linked table, remove the
TABLE='' part from the string, and click on the Add Table button, there's
your list of tables and views from the SQL database specified in your
connection string.



-----Original Message-----
From: jwcolby [mailto:jwcolby at colbyconsulting.com]
Sent: Wednesday, April 02, 2008 10:37 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Another really dumb question


That one's cool.  I use the IN "DatabaseName" clause in my libraries to be
able to fill combos and tables of forms stored in the library with data from
the application.  It took me awhile to figure that one out.  And of course
there are limitations such as "it only works with files", i.e. you can't do
this (to my knowledge) with SQL Server tables etc. 


John W. Colby
Colby Consulting
www.ColbyConsulting.com 
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
rusty.hammond at cpiqpc.com
Sent: Wednesday, April 02, 2008 11:22 AM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Another really dumb question

One quick little trick to bypass the linked table if you're going to run an
append query anyway, is from the design view of a query, right click on the
query window and click properties.  Find the Source Database property and
type the path and filename of the mdb you want to copy records from, then
when you go to choose tables to add to your query, the list will show tables
from the source database you specified.



-----Original Message-----
From: Gary Kjos [mailto:garykjos at gmail.com]
Sent: Wednesday, April 02, 2008 10:15 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Another really dumb question


Hi Barbara,

It depends on how many and how selective you need to be. You can copy and
paste individual records in table view. Or you can import an entire table
into another database using File/Get External Data/Import. Or you can attach
or link the table from the database you want to copy from in the database
you want to copy to and create an append query into the table you want the
records added to. that option gives you the ability to select records that
meet criteria as you would do for a report or whatever.

GK

On Wed, Apr 2, 2008 at 9:57 AM, Barbara Mende <barbara at moosehill.com> wrote:
> How do I copy records from one Access database to another?
>
>  Thanks!
>  Barbara
>
>  --
>  AccessD mailing list
>  AccessD at databaseadvisors.com
>  http://databaseadvisors.com/mailman/listinfo/accessd
>  Website: http://www.databaseadvisors.com
>



--
Gary Kjos
garykjos at gmail.com
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

**********************************************************************
WARNING: All e-mail sent to and from this address will be received, scanned
or otherwise recorded by the CPI Qualified Plan Consultants, Inc.
corporate e-mail system and is subject to archival, monitoring or review by,
and/or disclosure to, someone other than the recipient.
**********************************************************************
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

**********************************************************************
WARNING: All e-mail sent to and from this address will be received,
scanned or otherwise recorded by the CPI Qualified Plan Consultants, Inc.
corporate e-mail system and is subject to archival, monitoring or review 
by, and/or disclosure to, someone other than the recipient.
**********************************************************************



More information about the AccessD mailing list