AccessBlog.net

News, links, downloads, tips and tricks on Microsoft Access and related

About Me Search
Alex
Name:Alex Dybenko

Location:Moscow, Russia

Monday, March 04, 2019

Access System Tables

64 different system tables were documented  and summarised the properties

Purpose of System Tables
How Access Stores Queries
Using multivalued fields..and why you really shouldn't
How Access manages Relationships
Using Column History in Memo/Long Text fields
Remove deleted objects from MSysObjects

Labels:

Monday, January 07, 2019

VBA Code Examples

Several useful VBA routines, like file/string hashing, file/folder utilities, sorting, etc:

https://en.wikibooks.org/wiki/Wikibooks:Collections/VBA_Code_Examples

Labels:

Wednesday, September 26, 2018

Office 2019 is released

Monday, November 13, 2017

Happy birthday, Microsoft Access!

25 years ago, November 13, 1992, Access 1.0 was relased, and almost the same time I started to work with it! Long life, Mr. Access!

Here some introductionary words from its father, Bill Gates:

https://youtu.be/evMilwVBHAQ?t=11m55s

a859137f-0758-4f4f-9f27-a35f19457918-original[1]

Tuesday, March 28, 2017

Access Web Apps–the end?

We no longer recommend Access Services for new apps. This feature will be retired from Office 365. We will stop creation of new Access-based apps in SharePoint Online starting June 2017 and shut down any remaining apps by April 2018.

Labels: ,

Friday, January 20, 2017

SSE Setup

SSE Setup is a freeware Windows installation creator, looks interesting: works on most Windows OS, 32 and 64 bit, non-admin and UAC-friendly installs, etc. And of course - Easy Access database deployment!

Labels:

Wednesday, November 09, 2016

MS Access Right-Click Context Menu Creator

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]

Labels: