Make-table from front end to back end

  • Thread starter Thread starter SAC
  • Start date Start date
S

SAC

I'd like to run a make-table query from the front_end and make the table on
the back_end.

Is there a syntax to do this?

Thanks.
 
SAC said:
I'd like to run a make-table query from the front_end and make the table on
the back_end.

Is there a syntax to do this?
Click to expand...


Two ways.

1. Use the IN phrase in the query's FROM clause:
SELECT f1, f2, . . .
INTO table IN "path to BE mdb"
FROM whatever
the run the query in whatever way you prefer.

2. Open the other database and use that db object to
Execute the query:

Dim dbBE As DAO.Database
Dim strSQL As String
Set dbBE = OpenDatabase("path to BE mdb")
strSQL = "SELECT f1, f2, . . . " _
& "INTO table " _
& "FROM whatever"
dbBE.Execute strSQL, dbFailOnError
Set dbBE = Nothing
 
Thanks!

Marshall Barton said:
Two ways.

1. Use the IN phrase in the query's FROM clause:
SELECT f1, f2, . . .
INTO table IN "path to BE mdb"
FROM whatever
the run the query in whatever way you prefer.

2. Open the other database and use that db object to
Execute the query:

Dim dbBE As DAO.Database
Dim strSQL As String
Set dbBE = OpenDatabase("path to BE mdb")
strSQL = "SELECT f1, f2, . . . " _
& "INTO table " _
& "FROM whatever"
dbBE.Execute strSQL, dbFailOnError
Set dbBE = Nothing
Click to expand...
 
Back
Top