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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

HELP: Updates After Splitting 2
Changing Front End Back End Connection Through VBA 1
Copying back-end files from the front-end. 4
SQL Back-end / Access Front-end using linked tables???? 1
front end and back end 4
main form has back-end table data source 3
Access Form Refresh 1
Relationships - Multiple Back End Files 4

Back
Top