Updating a split database Question

[snoopy4801]

Ok, so I'm a bit "green" when it comes to access....

So with that being said I have a main table in my Back end database that i need to update. What is the best way to do this without messing up the data in the front end.

here is my thought initially: I have all of my data in an excel spreadsheet. I was going to import this into the back-end and rename it as the existing main table so as to "over-write" the existing table. (most of the data is the same, i just added some columns and info in those columns.

Then open the front end and "link" to that table.

Does anybody see any holes in this logic?

 

[pbaldy]

If the application is split, the data is in that back end, not the front. Probably the simplest way to make a change to the table is to get everybody out of the application, open the back end directly, and make the change(s) to the table. You may or may not have to refresh the links to get the front end to see the change, but the data should be fine. You should of course make a copy before doing anything.

 

[Database Challenged]

Hi! I too have a split database. I added a table to the back end but when I refresh the links in the front end, it's not showing up. When I manually copied the table to the front end, I still can't get the links to work.

Any thoughts??





**Nevermind. I got it to work! WOO HOO!**

 

[shieriel]

I also have a split database and i need to merge some old database into this database. What i do is i copied all data into excel and then paste also some other data from my old database and re-import that excel into my database as my new and updated backend table. As of this moment my database is working fine no other problems at all from front to backend