Access Read only FE

[reez88]

Hi,

I have to design a system where FE users will only read data from a backend table through a form. They will not be updating/insering new data.

All data in the backend table needs to be deleted and populated with new data thrice a day.

What would be the best way to achive this?
There shouldn't be any data outage when the BE tabel is being loaded with new data.

I made a demo FE and a BE and tried to use the form to view data while running updating the backend (running two queries 1. Delete all data from table 2. Append new data to table) , but the form shows as #deleted till the update is done. Is there any way to avoid this?

I thought I will have and extra field and flag the old data, then insert new data and then delete all flagged data. Is this the right way to go ahead?

Many Thanks.

 

[boblarson]

Hi,

I have to design a system where FE users will only read data from a backend table through a form. They will not be updating/insering new data.

Give them forms based on a non-updatable query. You can use a snapshot type if you want or you can just create the query so it is non-updatable by using the Grouping, etc.

All data in the backend table needs to be deleted and populated with new data thrice a day.

What would be the best way to achive this?

Running delete and append queries.

There shouldn't be any data outage when the BE tabel is being loaded with new data.

I made a demo FE and a BE and tried to use the form to view data while running updating the backend (running two queries 1. Delete all data from table 2. Append new data to table) , but the form shows as #deleted till the update is done. Is there any way to avoid this?

No, there isn't. But you can have the frontend on a timer do a requery so it doesn't last too long.

I thought I will have and extra field and flag the old data, then insert new data and then delete all flagged data. Is this the right way to go ahead?

That would probably help the length of time it is unavailable but you will find that it will still cause the #Deleted to appear because the forms would need to be requeried.