I can add the table in the backend or the front end, but if I add to the front end, it doesn't update on others computers. If I add it to the backend, it didn't show on the front end either. Probably because it is not linked. How would i link the new table AFTER I already split the databse?
Thanks!
Go to the front-end, add a link to the new table. Not really a programming question thought, consider moving this to superuser.
Hopefully all of your distributed front end files are all the same; otherwise you'll have to create the link individually (And learn a valuable lesson on why they should all be the same by not allowing users to customize.). You need to add the table to the back end, and create the link in the front end and redistribute.
You may want to look into creating some code in your front end that looks to the back end file, and creates links automatically if they do not exist.
In most circumstances the new table should be created in the back end database so the users can share the table data. If you have given each user their own copy of the front end database (which you should do), you can create a link in each of them to the new table in the back end.
A better way is to use Tony Toews' Auto FE Updater. That way you create the link in only the master copy of the front end database. Then the next time each user starts the application, her copy of the front end will be replaced with the updated version. The Auto FE Updater makes it easy to keep the users' copies up to date, and it is free.
Update: To link the table in the front end, go to the External Data section of the Ribbon. Click the Access icon in the Import section of the Ribbon. On the Get External Data dialog, select the radio button for "Link to the data source by creating a linked table". Browse to select the back end database. Then click OK to open the Link Tables dialog, select your new table there, and click OK.
If you want to use code to link the new table, look at Access' help topic for the DoCmd.TransferDatabase Method.