Problem on backend database

[marvin67]

I created a new table on my front end database, my problem is i do not know how to put this new table on my backend database to be able to see the new table as linked. I try to run database splitter to do this and point to the my backend database but when I asked to replace the existing backend database, it wipes off all the content on the tables on the backend. Luckilly we do a back up everyday so I was able to restore my database.

Is there a way to this? Thanks in advance.

 

[ByteMyzer]

1) Open the back-end database.

2) From the Menu Bar, select File > Get External Data > Import.

3) Select the front-end database as the file from which you wish to import, and press the Import button.

4) Click on the Tables tab, and select the table you wish to import from the front-end database, and press the OK button.

5) Close the back-end database.

6) Open the front-end database.

7) From the Menu Bar, select File > Get External Data > Link Tables.

8) Select the back-end database as the file from which you wish to link, and press the link button.

9) Select the table you wish to link from the back-end database, and press the OK button.


Of course, if you'd rather have a custom function to do the work for you, here's one:

Public Sub TableSplit(dbFront As String, dbBack As String, tblName As String)
    Dim dbs As Database
    Set dbs = OpenDatabase(dbFront)

    DoCmd.TransferDatabase acExport, "Microsoft Access", dbBack, acTable, tblName, tblName, False
    dbs.TableDefs.DELETE tblName
    DoCmd.TransferDatabase acLink, "Microsoft Access", dbBack, acTable, tblName, tblName

    Set dbs = Nothing
End Sub

Call it with something like:

Call TableSplit("C:\FrontEnd.mdb","C:\BackEnd.mdb","MyTable")


There you go.