AccessBlog.net

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

About Me Search
Alex
Name:Alex Dybenko

Location:Moscow, Russia

Tuesday, August 28, 2012

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

Labels: ,

Thursday, August 23, 2012

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)

Labels: ,

Tuesday, August 21, 2012

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!

Labels: ,