Of course, the ACCDB and ACCDE both generate an
#Use access runtime 2010 windows#
Shouldn't do if I'm going to deploy a split DB application that will likely have to run under Access 2010 Runtime on Windows XP platforms? What can I do when developing in Access 2010 that I What I would prefer to do with my time isĪvoid these issues as best as possible.
I can probably fix the problems I've encountered in my latest round of testing. To that end, I've enabled ANSI-92 SQL Server compatibility and am generating all of my Access "view" queries using ADO ( The application is ultimately going to be split, with a "real" SQL database back-end that supports native views and triggers. Problem with resolving the content in certain forms is due to table or database size. The test database size is currently at 650MB. I have another simple datasheet form that consistently resolves almost 4M rows under A10RT. The multi-table view that is again causing me grief returns 150 records. In my compiled and uncompiled applications under A10RT. Apparently, just changing the default navigation form was enough to change the behavior of the dependent forms I haven't edited any data, or added/deleted/modified any tables or views. Used to display content that no longer do. Even after reverting to the original navigation form, there are some forms that However, after changing the navigation form format from two horizontal button bars to a top/left button bar configuration, andĪdding some additional table/view forms to the mix, I'm back to some of the same, and some new, problems on the test platform. These solutions resolved the problems I originally encountered when attempting to view the test db content using the A10RT.
#Use access runtime 2010 code#
I have been able to "fix" these "broken" forms using a couple of solutions:ġ) I've simplified a view query of four tables so that it now references one table and an intermediate view of the other three tables Ģ) I've removed "format()" code from a query (a legacy of a previous programming life) and adjusted the output format property in the form. However, when I open the uncompiled ACCDB or compressed and compiled ACCDE on the test platform, the content in some of the elementary forms fails to resolve (I get a blank form). I am able to view the sample contents of all of the tables and views from this navigation form on my development machine. In development, I've used the nifty new Navigation Form to organize my elementary forms of the database tables and views (queries).
I've installed the latest version (.1000) of the Access 2010 Runtime (A10RT) on my Win-XP test platform. Occur after the scheduled delivery date of my application.
#Use access runtime 2010 upgrade#
My client is still running Office 2003 on their XP machines, and any upgrade in hardware and software will My development machine is running 32-bit Office 2010 on 64-bit Windows 7. I am developing a new application using Access 2010. What elements of a development database may be problematic when deploying an application to run under Access 2010 Runtime on previous versions of Windows?
0 kommentar(er)
