All geek questions in one place

SQL Server 2008r2 & # 8596; the best version of MS Access for the interface

I am improving the performance of my back-end from Access 2003 to SQL Server 2008 R2. My pilot migration attempt was successful, but it looks like the Access 2003 interface will not work well. (I can create my own links if I convert it to a .adp project, but then I can’t change the interface, so it goes back to .mdb, which uses (slow) ODBC links.)

Apparently, I should upgrade my clients to a newer version of Access. Can someone help me decide between Access 2007 and 2010?

Web delivery will probably not be desirable, and SQL Server 2008 R2 will be 32-bit. Finally, I could say that my fear of change is probably greater than my thirst for power ... so that all things are equal, I would take a smaller step until 2007.

+3
source share
1 answer

I tried 2007, briefly and in 2010 in more detail. I prefer 2010.

You can try: http://office.microsoft.com/en-us/try/try-office-2010-FX101868838.aspx

2010 , , (http://blogs.msdn.com/b/access/archive/2009/08/13/access-2010-data-macros -similar-to-triggers.aspx) sharepoint (http://www.youtube.com/watch?v=AU4mH0jPntI).

0

Source: https://habr.com/ru/post/1770197/

More articles:


All Articles