MDB Viewer Plus: free viewer/editor for Access MDBs and ACCDBs

MDB Viewer Plus from AlexNolan.Net is a free viewer/editor for Access MDBs and ACCDBs. Does not require retaiil Acces as it uses Microsoft Data Access Components (MDAC) which is installed as part of Windows.


via Access Extra: MDB Viewer Plus: free viewer/editor for Access MDBs and ACCDBs

Extending text field with SQL

If you need to change field type in Access table – you have to add new field, copy data from old field to new one, delete old and rename new to old. But if field type remains the same and you only need to increase field size – you can do this with simple SQL statement:

ALTER TABLE Customers
ALTER COLUMN CompanyName VARCHAR(50)

MSCOMCTL.ocx problems after August 2012 security patch

Several people reported that they have problems running Access applications after applying latest Microsoft update in August 2012. It appears that MS12-060 security update replaces MSCOMCTL.ocx with new version 6.01.9834, which is not 100% compatible with old versions (again!). The trick is to re-register MSCOMCTL.ocx using regsvr32.exe:

For 64-bit operating systems, type the following:
Regsvr32 "C:\Windows\SysWOW64\MSCOMCTL.OCX"

For 32-bit operating systems, type the following:
Regsvr32 "C:\Windows\System32\MSCOMCTL.OCX"

See KB article 2597986 MS12-060: Description of the security update for Office 2010: August 14, 2012 for more info.

Checkout post comments for more tips!