Table design additions after split DB

[jk]

Hello,

I have to add a few fields on one of my tables of my split DB.Front End on
users desktop /Backend on shared folder.What is the procedure to make this
change???How will it affect the DB? Do i add the fields only to the BE on the
shared folder or FE..or both at the same time?
Thanks

 

[Allen Browne]

Just add the fields to the back end.
You will need exclusive access to the table to do that.

 

[jk]

Thanks,

Could you clear up exclusive access.I created the DB and i created a
password prompt so when a user starts it they needs this password.
Thanks

 

[Allen Browne]

If someone else is using the data at the time when you are trying to change
the design of the table, you won't be able to save your changes.

Consequently, it's generally a good idea to make the structural changes when
no one else is trying to use the database.