Question Guidance Required in Access 2010

[kbsudhir]

Hi All,

I want to design a Access 2010 database,

1. Which will be accessed by 10 users from different locations.
2. Required data for a user (who is currently logged in) will be displayed in a form using graphs. I will be using a macro to get this done.
3. I will be using a lot of "Group By" query.

Now, I am planning to create a web database & publish the same on my SharePoint. Sharepoint version is 2010.

But if I am not wrong, macros, graphs & group by query is not compatible with web database. If this is true, then how can I allow my team members to access & update this database.... Is there any work around for this issue...?? :banghead::banghead:

Any guidance on this issue is appreciated.

Waiting for guidance.

Regards
Sudhir

 

[Pat Hartman]

Group By queries are not updateable nor are any other queries that aggregate data.

Access Web/Sharepoint databases can ONLY use macros. They cannot use VBA. I don't know if Access web apps have any graphing capability at all.

 

[kbsudhir]

Thanks Pat, idea is to use data from Group By queries to generate the graphs, for that I have to use VBA ... but it seems thats not possible.. ???
:-(

 

[Pat Hartman]

No VBA!!!!!!!!!!!!!!!!! Only macros