by Paul Mather (15 Submissions)
Category: Databases/Data Access/DAO/ADO
Compatability: Visual Basic 3.0
Difficulty: Intermediate
Date Added: Wed 3rd February 2021
Rating: 
(116 Votes)
Have you ever needed to view a database on a computer without MS Access? Here's an alternative. It uses ADO 2.1 to open, view & edit MS Access, SQL server, DSN and Oracle databases. There are also a few features to let you add, rename and delete tables as well as purge based on a Date/Time field. Clearly not a replacement for MS Access, but you can distribute it to help troubleshoot. Automatically registers itself as the default database viewer for .mdb files on systems without a default already set. Otherwise, it becomes a second option when right-clicking. Its Biggest advantage is its all ADO. No DAO at all. Now you're able to modify older versions of Access databases when Access itself requires a conversion!! I recommend distributing MDAC 2.5 even if you have a 2.1 application. Microsoft seems to have fixed some of the install problems with the MDAC 2.1. Please Note that you MUST HAVE the Oracle client installed on your PC to use the Oracle connection!!https://www.microsoft.com/data/download.htm
** Updated 3/21/2000 **Added Password support for Access databases.Please vote!
VBcoders
