SELECT INTO an external database

Is there a way to select into a table in another database?

I have a db that contains master information on a series of tests. I
want to be able to make a subreplicant of the database that contains
only test information for a particular usergroup.

So, for instance, I use the docmd.transferdatabase to move the
structure of the database over to a newly created database. [Original
database = currentDb, new database = nDb]

Both databases now have a table named "Tests".

Is there a way to perform a select into from the currentDb.Tests table
to nDb.Tests?

(IE: "SELECT * INTO nDb.Tests FROM currentDb.Tests")

I'm familiar with ADO and DAO, but am having no luck coming up with
the proper search terms in order to find anything that is of any help.

(Currently, I am copying the data over and then performing a
nDb.Execute ("DELETE FROM Tests WHERE NOT (testUser="UserName"). I
would like to see if I could generate the database without ever
permitting other user information to enter it. [To appease a few
security concerns that were asked]
I realize I could perform a series of nDb.Execute ("INSERT INTO
Tests") for each record that matches in currentDb.Tests, but that
could be very slow.)

Ta very much.

Steve Albright

.

Relevant Pages

  • Re: Performing a SELECT INTO an external database
    ... I have a db that contains master information on a series of tests. ... want to be able to make a subreplicant of the database that contains ... structure of the database over to a newly created database. ... Why not link to the table from the 2nd database and run an append query? ...
    (comp.databases.ms-access)
  • Performing a SELECT INTO an external database
    ... Is there a way to select into a table in another database? ... I have a db that contains master information on a series of tests. ... I'm familiar with ADO and DAO, but am having no luck coming up with ... the proper search terms in order to find anything that is of any ...
    (comp.databases.ms-access)
  • RE: How to enter data into a table using a combobox
    ... I am having some issues with the NotInList function. ... > you don't need to mess with the database name. ... >> more luck. ...
    (microsoft.public.access.forms)
  • Re: search component using picture alternative text
    ... Its doesn't take luck. ... Here's a tidbit...put HTML comments into the fields of your database ... preventing their display. ...
    (microsoft.public.frontpage.programming)
  • Re: Sharepoint web site gone but database still intact
    ... I still have the config database and the content database in MSDE but the ... no luck, ... "Wayne Atkinson" wrote: ...
    (microsoft.public.sharepoint.windowsservices)