If IT managers are to EVER consider Access & VBA as a worthwhile part of the enterprise development picture, then serious attention needs to be made to allow for source control of Access apps - BOTH for desktop and AWA "sides". Macros need a MUCH better (XML) editor and source control options too. Hell, for "lite"/quick & dirty approaches, why isnt' there a way to have Access create its own "source control database" on the fly? After all, Jet/Ace is a database engine, right? so why not make it able to create its own source control database and store code.macro changes there? (as well as working with "real" source control systems, of course). The problem with Access/Excel/VBA source control was NOT that it "wasn't used enough" it was that it was too hard to make it usable. Make it MUCH easier to install/configure and use, and it will be used!

In losing Desktop Jet ULS security (which was poorly implemented anyway), the security baby was thrown out with the bath water. It needs to be brought back! Integrate security groups with Active directory, and store the security within an internally encrypted section of the database file, using a key separate from the database password/encryption key. This security needs to include such things as permission to create a new database, permission to copy/export data, table access and field-level access controls, permission to cut/paste data. These security options should be able to be respected across WAN/Sharepoint/AWA scenarios as well as desktop/thick client access scenarios. (that part may be too tall an order, but it's worth asking for, at least). Like the Data macros, these security settings would need to be respected and enforced at the DATABASE ENGINE level (inside Ace).

we would like to have following limitations to be lift from upcoming versions:

Limitations:
1>Tabs within tabs should be possible
2> passthrough query's connection string limited to 255 char can you lift that too so we can add long SSL certificate locations?

New functions:
1> Global Error capturing especially odbc errors like lost connections
2> Resizing form & resize components.
3> Can tabs have an option whether its contents are loaded upon entering tab.
4> Allow CSS formatting for forms or any global style sheet. Or at least allow us to create more sections in the (theme colors)
5> allow developers to compile with "no navigation pane, no bypassing shift key" (don't allow to enable without the original project.)
6> Drag and Drop function at least in list box.
7> ability to lock down tables/items being imported from other OLE apps. (preferably with an encrypted password)

> Visual ribbon creator
> object view for code module to see functions, procedures.

New controls:
1> Progressbar
2> Menu that can be placed anywhere
3> Right click menu that can be placed on a section(header/detail/footer).
4> Proper date picker
5> Group box (no activex please)
6> better charts

thank you: