Visual Basic 6.0 translation

Showing posts with label Track Database path. Show all posts
Showing posts with label Track Database path. Show all posts

Monday, May 16, 2011

VB 6.0 Track Your MS Access DB Path anywhere

Microsoft Visual Basic 6.0 with MS-Access 2003
Track your Database path from anywhere

This Open-source is Free to Distribute and use, you can download it from (MediaFire)
this is an example of how to design a simple app to track down and hunt your MS Access database whenever it's lost or path's changed.
VB6 Track your Database Path from anywhere
 you won't have to worry anymore about database path.
you can always set database as default as if it were originally designed to be.
there is also the software packed and ready to try as a separate software, download from (MediaFire) just to make sure it is what you are looking for .

1) Design :
Check the Open-source-code

2) Files :
Check the Open-source-code

3) Logic :
you need to always detect your ms access database whenever changes its path, for example (you designed a software and the database path changed by the user for some reason , what would you do then?) ... the answer is that you will have to re-place it by yourself .
also let say (you have many MS Access databases and you want to connect to one at a time ....)
Or you wanna design a side-App as Admin Screen to manage your database connection at the user's place .....
Or Detect your MS Access Database in Network
- Add References :
Microsoft Scripting Run-time
Microsoft ADO 2.8

you have 5 buttons :
1) Browse : get the database path & name
2) Connect To Database Now : Connects you to the database you choose in the Browse Button
3) Set As My Default Database : Sets the MS Access Database you just choose as the database that will always connect as the program starts up every time .
4) Disconnect From Database : Disconnects you now from the database you are connected to.
5) Set No Database Connection : Remove the connection to the database for Permanent.
- as the project loads, there will be now database connection detected, so you just click on Browse and choose (Mdb File) Ms Access 2003 DataBase File to connect to anyway you like .
- Change the location of the database and notice that it asks you to pick another one,
- pick database from another location and set it as your default one and notice that it becomes your default connection .
- project depends on Filesystem-object - MS ADO 2.8 - Handling Files .

Visual Basic Online Course

vb6 (63) Application Development (45) Visual Basic Online Course (45) Online Visual Basic Course (44) Visual Basic Help (44) Visual Basic Programming (42) IT Jobs (39) VB6 developer (38) Visual Basic Course (38) Visual Basic 6.0 (26) Microsoft Visual Basic 6.0 (25) VB6.0 (24) Visual Basic Programmers (24) vb 6.0 (24) visual basic programming tutorial (19) Third lesson (16) Source code download for Visual Basic 6.0 (14) Source code for Visual Basic 6.0 (10) visual basic tutorial (9) Visual Basic 6 (5) Visual Basic Courses (5) Lesson 3 (4) VB 0.6 - TreeView control (4) VB 0.6 With TreeView Control (4) VB6 Course (3) Create ActiveX (2) How to automate MS-Access from Visual Basic 6.0 (2) Add controls at runtime (1) Back up your Database (1) Change ActiveX icon (1) Change screen resolution (1) Create FTP (1) Crystal Reports 4.6 (1) Crystl32.ocx could not be loaded (1) DataGrid Columns re-size (1) Date Calculation (1) DateAdd Function (1) DateDiff function (1) FTP (1) Marquee Title Bar (1) Marquee VB 6.0 TitleBar (1) Method 'Action' of object 'CrystalCtrl' Failed (1) Microsoft Access with Visual Basic 6.0 (1) OpenSchema method (1) Save File Using CommonDilog (1) Track Database path (1) VB 0.6 - Registry (1) VB 0.6 With Registry Editor (1) VB 6.0 Access (1) VB 6.0 OOP (1) VB6 Access2003 ADO Like % (1) VB6 Add Date (1) VB6 Add Time (1) VB6 Date calculation (1) VB6 Subtract Date (1) Visual Basic Remote (1) Win7 (1) Windows7 (1) ms access networking details (1) remote Visual Basic DB (1) rounded and transparent forms (1) vb 0.6 style (1) vb 6.0 Remote Database (1)