Adding to previously split database

[jamiesuperman420]

Hello!! I designed a database for a company and installed it, which included splitting the database since upwards of 20 people use it at a time. They recently asked me to add a new feature but MS Access won't let me alter the original table because the database was split.

Can I localize the database on MY computer, then split it, then replace everything on THEIR computers without losing information?? Is there a better way of going about this?? I'm having a terrible time with relationships (in Access... and real life, I suppose).

Thank you in advance!!

 

[georgedwilkinson]

MS Access won't let me alter the original table because the database was split.

I'm not even sure how that is possible. What were the symptoms?

I always though the process was straight-forward:
1. Modify the table in the backend
2. Modify a copy of the front end to work with the modified table
3. Propagate the new front end out to all the users

 

[boblarson]

What changes do you need to make? If you are adding fields to the backend or tables to the backend, you can use my backend auto updater (free) to make remote changes to their backend database. That way you don't need to do it on their version. Then you send them a copy of the new frontend which would have the links to the database changed to include the newer table changes. You can set up relinking using this code from MVP Armen Stein.