copy a table into the BE database

[crowegreg]

I've just split my DB. Within my existing code in a form, I have a copyobject statement to copy a table. How do I make sure the new table is copied into the BE DB? I think in the copyobject statement I need to code the destinationdatabase. How do I determine the location of the BE DB from within the FE DB?



Also, If I need the table hidden in the BE DB, how do I code that?

Thanks in advance!!

[June7]

What is purpose of this table? Why does it need to be in the backend? Is this a regular event? Why?

Example from my db:

strExtract = "filepath\database.accdb"
CurrentDb.Execute "SELECT * INTO Bituminous IN '" & strExtract & "' FROM ConstructionBIT;"

[crowegreg]

It is an archived table. When a new spreadsheet is imported into a table, I'm needing to create an archived table of the previous import.

[June7]

Did my example help? It will create a new table, not insert records into existing table.

[crowegreg]

VERY COOL!!

Two more questions, once it's within the BE DB, I need to hide the table, and do I need to link the table to the FE DB's?

[June7]

Link if you want to view the table from the front end. I have done that programmatically. Example:
'set table link
Dim tdf As TableDef
Set tdf = CurrentDb.CreateTableDef(Me.tbxTestNum)
tdf.SourceTableName = Me.tbxTestNum
tdf.Connect = "; DATABASE=" & "filepath\BE.accdb"
CurrentDb.TableDefs.Append tdf


For hiding try:
Application.SetHiddenAttribute acTable, "MyTable", True ' will hide the table "MyTable"
Application.SetHiddenAttribute acTable, "MyTable", False ' will unhide the table "MyTable"

[crowegreg]

Thanks, I've been a big help!!

[ssanfu]

So has June!!!

Now that is funny!! Thank you.. I needed a chuckle

[crowegreg]

So has June!!!

Now that is funny!! Thank you.. I needed a chuckle

Sorry about that. You can tell where my head is right now!!