Using Visual Basic ADODC to connect with MS Access Database (.mdb)

The ADODC or Active Data Objects Data Control is a method added in Visual Basic 6.0. It allows a programmer to put controls, such as labels, text boxes, list boxes and other display controls, on a form and connect them to the Data Control, which then connects to a database. This provides considerably more power to the developer in creating and maintaining databases.

Connecting Adodc from your MS Access database is quite complicated, but if you'll going to follow this steps carefully, it's very easy... ツ

1st. Right click your ADODC object and click ADODC Properties.

2nd. Property Pages Window will appear. Click the Build button.

3rd. Data Link Properties Window will appear. Choose Microsoft Jet 4.0 OLE DB Provider.
(This provider is used if your database is from Microsoft Access .mdb file.)
...and click Next button.
NOTE: Your database must be save as .mdb file format.
If you are using MS Access 2007 or higher, just Save As your database in MS Access 2003
for it to become .mdb file.
.accdb is the file name extension of 2007 which is not compatible with Visual Basic 6 ADODC.

4th. Browse your MS Access database from your computer.
In the sample, the address of the database is
D:\Files\VB6\myDatabase.mdb.
The file name of the database is myDatabase.mdb.

TIP:You can erase D:\Files\VB6\ in the text field so that you have no problem if you'll going to transfer your Application or your database to another area/computer. (It is very helpful, i swear! ツ)

5th. Click Test Connection Button. Test connection succeeded must appear and click OK button.
If error message appear, just try again browsing your database file.

6th. In the Property Pages Window, Click the RecordSource Tab.
In Command Type, choose 2 - adCmdTable.
Then in Table or Stored Procedure Name, choose the table you'll going to use.
The sample table name in the image is Customers.
Click Apply and OK button simultaneously.

...and that's it!... your MS Access database is now connected to your Visual Basic Application using ADODC... ツ

If you have questions or clarifications, don't hesitate to post a comment below... ツ

Read More Here...

Cannot Create Windows Folder Named Con

According to this rather breathless little message, which circulates via email and online, it is not possible to create a folder named “CON” on a Microsoft Windows based computer. The message claims that not even Bill Gates or the whole Microsoft “Team” can explain why this might be so.
It is in fact perfectly true that you cannot create a folder named “CON”, nor can you rename an existing folder to “CON”. However, there is no mystery surrounding this restriction whatsoever. The “team” at Microsoft, and a great many others besides, know perfectly well why you cannot name a folder “CON”. “CON” and a number of other character strings are in fact reserved names that go back to the days of DOS and cannot be used to name folders or files. Other reserved names are:

• PRN
• AUX
• NUL
• LPT1
• COM1
• Potential drive letter - A: to Z:
• A number of others

If you try to name a folder using one of these reserved names, the name will automatically revert to the default, generally “New Folder”. Moreover, if you try to use a reserved name to name a file such as a Notepad or Microsoft Word document you will generally receive an error message similar to the following:

Depending on exactly how you save the file, you may instead receive a warning message advising that a file with that name already exists. However, even if you choose “Yes” to overwrite the existing file, you will still not be allowed* to save the file.
While there is no mystery about this issue, it might have saved user confusion if Windows displayed an explanatory error message when attempting to create a folder with a reserved name as well..

SOURCE: My Other Blog

Read More Here...

Download Internet Explorer 8 (IE) Add-On Feature Pack (K968771) for Windows 7 E and N Editions

If the Microsoft’s proposed web browser ballot screen option to allow end-users to choose and install any additional web browsers on Windows 7 is not accepted by European Commission, Windows 7 E and Windows 7 N, another SKU that has already lack of Windows Media Player and related technologies, both will have Internet Explorer 8 (IE8) removed. Windows 7 N and Windows 7 E RTM, which available for every editions, are special SKUs of Windows 7 that available to consumers in countries belong European Economic Area (EEA) only.

Note: Windows 7 E will not be released. Instead, normal Windows 7 will now be released to Europe

The main problem after installing Windows 7 E or Windows 7 N is that how end-user can download a web browser, when there is no browser to start with. Microsoft does plan to provide several ways to download web browser to install on Windows 7 E, and one of them is KB968771 Internet Explorer 8 Feature Pack add-on for Windows 7 E and N editions.

The KB968711 IE8 Feature Pack for Windows 7 E or N editions is likely to be distributed via Windows Update

to installed Windows 7 E or N systems

in Europe. For users who want a backup copy of the KB968771 IE Feature Pack for Windows 7 E and N editions that have IE8 removed, can download the KB968711 standalone update package for future use.

Download IE Feature Pack for Windows 7 N and E

32-bit (x86) version: Windows6.1-KB968771-x86.msu

Size: 28,2 MB (29,645,025 bytes)
CRC32: F6D75924
MD5: 058A858E7DC59EEC5FF0F9B410524A23
SHA-1: 7CF64FAE9E52FDD3A47268D88789F27BEF3CA4B2

64-bit (x64) version: Windows6.1-KB968771-x64.msu

Size: 40.8 MB (42,852,424 bytes)
CRC32: 3B6563E0
MD5: 3A299F3F14D71167B124839743A796A9
SHA-1: 5708B692EF2A48794C639BAA8FA5E254F4844244

The downloaded KB968771 MSU QFE (Quick Fix Engineering) update packages are official Internet Explorer 8 add-on packs for Windows 7 RTM x86 and x64 E or N versions. Most people do not need to download these package if you install your system using full functionality Windows 7 RTM retail ISO or Windows 7 RTM OEM ISO, as IE 8 already included on those systems.

Read More Here...