VB Programing support Access Database Microsoft Office VB.Net & SQL Server nev@NevVB.com.au Sydney, Australia (02) 9453-0456 Contact Details 28/01/2012
The latest version of Microsoft Access is now available. Access 2010 still has a 2GB database file size limitation – but this is more than enough for most Access applications. Access 2010 requires a minimum of 256 megabytes of RAM.
If any of the new features are incorporated, the database will not run in Access 2007. The error message is "Unrecognized database format".
Trying to find out which incompatible feature has been added is near impossible. Until Microsoft make incompatibility problems easier to find, it is best to develop only in Access 2007.
There do not seem to be any improvements to ADP (using SQL Server as Back-End) since Access 2003. Microsoft Access 2010 still does not implement stored procedures.
It is easy to link efficiently to a SQL Server database, and use ADO for Record retrieval. The future of ADP is rather hazy – especially with the advent of SharePoint Server.
Whenever a Macro (or VBA Function or Procedure) is run, the message "A potential security concern has been identified" appears. To get rid of these messages, the Access database will need to be saved to a Trusted folder.
Place all the database files into the Folder that you have marked as Trusted. You should not get any Security warnings again for the database.