To control another database you need to do it entirely in VBA.  This is how you open another .accdb file and add a table to it:

    Dim db As DAO.Database
    Set db = DBEngine.Workspaces(0).OpenDatabase("C:\My Documents\MyDB.accdb")
    db.Execute "CREATE TABLE MyNewTable (ID AUTOINCREMENT PRIMARY KEY, FIELD1 TEXT(255), FIELD2 SMALLINT, FIELD3 INT, FIELD4 DATE);"
    db.Close

This will create a table named "MyNewTable" in the specified database, with an autonumber primary key field, a short text field, an integer field, a long integer field, and a date/time field.

This method is often used in environments outside of Access, such as Word VBA or Excel VBA.

"CREATE TABLE" is a special query type that creates a table from scratch.  Not to be confused with a "make table" query.  Notice the differences in nomenclature: autonumber is called AUTOINCREMENT, integer is SMALLINT, and so on.

Many thanks Kevin.
Appreciate your help.

Hi Kevin
As it happens, the table I want to back up is the one with the most fields (53).
is it possible to create a time stamped backup on the other Database of this one table without having to define all the fields as you have shown me above?

Again thanks for your help.

Another way to transfer a table is to export it.  You can do it manually by going to External Tables -> Access, and follow the wizard.  To do it automatically with VBA, you run this in the database you want to transfer from:

     DoCmd.TransferDatabase acExport, "Microsoft Access", "C:\My Documents\MyDestinationDB.accdb", acTable, "MyOriginalTableName", "MyDestinationTableName", False

I believe Richard has a video on this, but I don't know which one.  The "False" at the end is important; that means both the table's structure and data will be exported; "True" will only export the structure.

Regarding "time stamp", maybe you can put it in the name of the backup table.  E.g. "MyDestinationTable - backed up on 9-16-23".

Kevin

This is exactly what I needed.
It worked like a charm.

Cant thank you enough