Front-end update

[majid.pervaiz]

Dear friends,

hope this message will find you all to the best of your health.

I have a database which is split (database on server and front-end file on each user workstations), I would like to know if I want to update front-end only and do not want to split database again, is it possible?

Note: I have the original access file without the split also.

appreciate your advice.

 

[sneuberg]

You can update the front-end only only if that's all that needs updating. So if the only changes are in the forms, queries, and reports, etc on the front-end just update and redistribute. On the other hand any changes in the backend tables will have to be done to the backend, including any changes in the relationships. If you add a table to the backend you will also need to link the front-end to it.

 

[majid.pervaiz]

how to do that update in front-end only? if I make accde file from original access file it will contain tables also.

 

[sneuberg]

I don't understand why you would make an accde file from the original that has the tables. Why aren't you making the accde from the front-end without the tables, but just the link tables.

 

[majid.pervaiz]

Sorry Sneuberg, I am not expert user but yet your question shows me a path that we can make accde file of front-end directly which I was not aware of.

many thanks

 

[sneuberg]

Of course you need to keep a copy of the front-end as a accdb file as you can't make changes to the accde.