Alex & Access

November 9, 2016

MS Access Right-Click Context Menu Creator

Filed under: Access — access @ 11:58 am

Context Menu Creator – useful tool to create Windows Explorer file context menu like Compact, Decompile, Open Exclusively for desired Access file exnetsions.

WindowsExplorer_AccessDatabase_ContextMenu01[1]

November 12, 2015

ADP+ for Access 2013 with SQL Server

Filed under: Access, SQL Server — access @ 12:13 pm

Another way to connect Access and SQL server – ADP+ library from Joakim Dalby, Denmark. Looks like it is build on ADO, and should work the same way as Access ADP. Would be good to know if anybody tried it?

I personally use  linked tables and DAO/pass-through tables, tried to use ADP several times, but every time switched back to mdb.

October 13, 2015

Access UserVoice

Filed under: Access — access @ 8:44 am

Access on UserVoice  – suggest ideas and vote for others feedback. Access team promised to monitor this site 🙂

September 22, 2015

What’s new in Access 2016

Filed under: Access — access @ 1:47 pm

Here are some of the top new features you’ll find in Access 2016

July 16, 2015

July 2015 Access updates

Filed under: Access — access @ 1:18 pm

July 14, 2015, update for Access 2013

Fixes the following issues:

– When you open multiple objects in design view and then try to switch to another view in Access 2013, Access 2013 may become unresponsive.

– When you undo a column deletion operation in table design view in Access 2013, Access 2013 crashes.

– The Conditional Formatting button does not work if the ribbon is collapsed in Access 2013.

– After you import a form or report or you copy and paste an existing form or report in an Access app, the theme colors are changed unexpectedly under the control of the newly created form or report.

July 14, 2015, update for Access 2010

Fixes the following issue:

When you start Microsoft Access 2010 on a computer that has not been restarted for a long time (for example, 24 days), the CPU usage of the MSACCESS.EXE process becomes high. However, applying this update will reintroduce the problem that is addressed by the hotfix KB2899528 for Access 2010 November 11, 2014. As soon as this update is installed, fields that are bound to expressions on forms may not be recalculated when the computer has not been restarted for a long time.

June 11, 2015

How To Migrate Data from Desktop to Access App

Filed under: Access — access @ 10:36 am

Tutorial video from Crystal, Access MVP, helps you to understand migration process to Access App, if you never done this before.

 

June 3, 2015

ADP+ framework for Access

Filed under: Access, SQL Server — access @ 8:53 am

Missed ADP projects? ADP+ can help you. this is a Data Access Layer for updatable form and subform and for report and subreport to have a client-server rapid ap­pli­ca­tion deve­lop­ment framework in Ac­cess 2013 connected to a SQL Server da­ta­ba­se 7.0, 2000, 2005, 2008, 2012, 2014 and the forthcoming SQL Server 2016.

November 17, 2014

Security Update MS14-066 causes major performance problems in Microsoft Access / SQL Server applications

Filed under: Access, SQL Server — access @ 8:51 am
Security Update MS14-066 causes major performance problems in Microsoft Access / SQL Server applications

 

Update: Switching to "SQL Server Native Client 10.0" ODBC driver helps to avoid performance issues, looks like update has effect on default "SQL Server" driver only

June 23, 2014

A better ZoomBox

Filed under: Access — access @ 10:09 am

A better ZoomBox – the improved version of Access Shift+F2 zoom feature by Tom van Stiphout, Access MVP.

May 22, 2014

Access NetView – Extensible Control for Microsoft Access

Filed under: Access — access @ 4:17 pm

NetView control – there are 2 reasons to look at it. First of all this is an Access native control, which you can use in your application, if you need to show multi-dimensional charts, bound to recordsets, or using it drag capabilities. And second reason – learn it source code, what could be useful for creating your own control or applications. Check it out!

Older Posts »

Blog at WordPress.com.