Auto click refresh all icon when table values change

[Thasthahir]

Hi ,

Hope you are all good..

Urgent help..

I have created a access database. It has 6 table. have not created ant forms and quires.

Users update data manually because it is shared database. like shared excel
Requirement is , If any one change any value or update any value in any table automatically all the data refresh.
In Home tab-> Refresh all icon should be work.

Any one help.It is in accdp format

Regards,
Mohideen

 

[Thasthahir]

Auto click refresh all icon when table values change

Hi ,

Hope you are all good..

Urgent help..

I have created a access database. It has 6 table. have not created any forms and quires.

Users update data manually because it is shared database. like shared excel
Requirement is , If any one change any value or update any value in any table automatically all the data refresh.
In Home tab-> Refresh all icon should be work.

Any one help.It is in accdp format

Regards,
Mohideen​

 

[xenou]

Generally data is available when it is commited (by other users - you can always see you own data). Would need to know what specific use case you have in mind here - Access should not be used like a spreadsheet so generally users should not simply be viewing table data directly (i.e., simply opening and working directly in tables) as part of a standard end-user workflow.

I am not familiar with accdp formats so maybe that's something I can't answer directly - might have different features.

 

[Thasthahir]

Hi Xenou,

Please note that, Now we have used that access database file . it has 6 table. it is shared file. once i update value i will hit refers all icon in home tab. it will reflect it is working.
Each and every time user using F% button for refresh.More than 20 users using the same. but data reflected. Please check and advise us.

 

[xenou]

Hi, that is correct - refresh all will refresh the data.

 

[stumac]

You cant! But you could have a hidden form that refreshes them on a timer event.

However, I would not recommend continuing with your current approach of 20 users editing one back end file directly, this is asking for corruption issues and if you have 20 users I am guessing that the data is fairly critical for what these people are doing. it sounds like these are more or less being used as a replacement for spreadsheets. Whilst this may seem like an easy way of sharing the data it will probably take you a lot longer to fix than developing a basic front end with forms or queries that return the data the users need and allow them to enter/edit records in a more controlled & robust way.

 

[Thasthahir]

Hi Xenou,

I dont know how to create macro for database.

Could you create a macro for me. for example

 

[Thasthahir]

Hi stumac,

I dont know how to create macro for database.

Could you create a macro for me. for example