I have an Access 2k .adp database. It's a good size database. I use SQL 2000 Server for the backend. My boss wants me to convert to Access 2007. I have found out that Access 2007 does not support the .adp format.
The database is used by a healthcare organization. Therefore we track a lot data involving our clients.
Is the accdb the database I want to use?
Is there an "EASY" way to convert the VBA code (many, many, many lines of code)
In the .adp I used Stored Procedures and Views instead of queries. Can the SQL statements for these be pasted into queries in Access 2007?
Any pointers concerning the conversion?
Is Access 2007 stable? Any Service Packs in the foreseeable future?
How many users can open the Access 2007 front end before the system boggs down? Currently, I have about 80 users, but rarely have more than 30 to 35 active at one time. Believe it or not the Access 2K, Sql Server 2000 database works well with 35 users going at one time.
The db size is about 60Mb, there are a lot of reports with graphs. And, most of the forms are not simple. Most have tabs, with multiple sub forms.