front end, back end issues

[dnstapes]

I'm testing a front end/back end system for my database. I used the database splitter to do this.

Out of curiosity, I made a make table query. The table that was generated ended up in the front end database, not the back end. How do I send the data to the back end while still keeping the link on the front end?

Any suggestions for me in general? The front end/back end thing seems like it will help me out, but I only know a few things about it right now.

Thanks,
Dana

 

[DougP]

Close the Front end and open the backend yourdatabase_be.mdb

click the Tables tab
Right click in the white space an click "Import"

find your Front End and import the new table
close Back end and now re-open front end

Delete the table in the front end
next right click in white space but this time click "Link" not "Import"

Find the _Be.mdb and your table then follow prompts
Now you should see the table back again but this time it has a black arrow in front of it (its linked like the others)

So the conclusion is create all of the tables first before making a Back end
DougP, MCP

Visit my WEB site

http://www.barcodeone.com

to see how Bar-codes can help you be more productive

 

[Databaseguy]

If the make table query is a part of your application (Front End), you'll need to create it in the back end and link it into your front end like you would a table or other object.

 

[tempclerk]

In Access 2000 the make table query has an option to make the table in a different database, and I'm pretty sure in previous versions you could set that up in the query properties.