CREATE TABLE query

G

Guest

I am trying to write a create table query to create a new table on the back
end of a split database. I can easily create the table on the machine running
the front end of the database. What is the best way to achieve this. Many
thanks in advance
 
M

Michel Walsh

Hi,


Open a database object on the backend. Take a look at
DBEngine.Workspaces(0).OpenDatabase. Operations defined with reference with
that object would happen ... on that database. If you need ADO rather than
DAO, open a connection object.



Hoping it may help,
Vanderghast, Access MVP
 

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

Make table query, how does it get to back end database 2
Storing Query Into Table - Using the Stored query 1
make table query 3
Linking tables without knowing UNC path 4
CREATE TABLE... 3
Query performance Access 2007 1
Make-table query with around 2 ml records taking too long 0
Make Table Query in NEW ACCESS file 1

Top