Split Database.

[cvolkers]

Hello all, I am new to your forum.

I have a database in access that I have been slowing working on and building for a couple years. We access this database on many work stations. A short time ago I split the access program, do the database is one file and all the fields and such are on another. This let us open the program on multiple computers. Now the issue I am running into, is the owner of the store would like fieilds added into the database. I can create the tables, but I am having troulbe finding a way to make them or link them to the UI part of the database.

Any help would be great.
Thanks.
Chad

[ajetrumpet]

it should be fairly painless. I would suspect you have to insert them into the tables and then modify the FE file as well. forms would mostly likely be the only thing changed. reports maybe too. what are the difficulties? finding room on the forms and reports for them?

[cvolkers]

Ok, got it. I was keeping both parts of the split database open. Once I closed both, added my fields in the table, then saved and closed. I opened the UI part and the new fields where under add existing fields. Drog drop and place. Works great. The forms and reports are actually not an issue as of yet.

[ajetrumpet]

Great! I'm going to mark this thread solved then