Use the Search function on the Visual Basic Edit menu to locate all references in the project to the Microsoft Jet OLE DB Provider version 3.51 and update 3.51 to 4.0.
In Visual Basic 6.0 only, update ADO connection strings to support Access 2000. Note From Nevyn: you have to click on the new title of Access 2000 in the VB work environment to actually produce the Click event code.ģ. Open the frmMDI code module and select the mnuDBNMDB2K_Click event procedure in the drop-down list. Enter Access 2000 as the Caption and mnuDBNMDB2K as the Name. Click the Insert button, and then click the RIGHT ARROW button to make the new, blank entry a subitem under the Microsoft Access heading. In order to insert the new menu item after the existing entry for Access Version 7.0 MDB files, select the following entry: dBase. In the Menu Editor window, scroll down in the existing menu items to File / New / Microsoft Access.Ĥ. From the Tools menu, open the Menu Editor.ģ. Open the main form, frmMDI, in the design environment.Ģ. Add a new menu item and code to allow creating a new Access 2000 database.ġ. If you don’t do this right the program will not compile.Ģ. So…go back into the References, click on the DAO 3.6 which is at the bottom of the list in position number 7, and use the up button on priority to move it into position. It has to be in the same position as the original DAO 3.51. Note From Nevyn: Sounds simple huh?….but do you know what they mean by “move the DAO 3.6 reference above the ADO library reference in the list” ? Well it means that when you select the DAO 3.6 and click ok it goes to the bottom of the list. If you are using Visual Basic 6.0, be sure to move the DAO 3.6 reference above the ADO library reference in the list. Deselect the existing reference to Microsoft Data Access Objects 3.51, and then locate and select Microsoft Data Access Objects 3.60. On the Project menu, open the list of References.ģ. Open Visdata.vbp in the Visual Basic design environment.Ģ. (This step alone is sufficient to allow you to open and work with Access 2000 files.)ġ. Update the DAO Reference from DAO 3.51 to DAO 3.60. It was a little discouraging not to have any response to my inquiry.Īdapting VISDATA to work with Microsoft Access 2000 format databases requires changing only one project reference, adding one menu item, and adding one line of code to process the new menu item.ġ. If possible I will ask the forum administrator if it can be uploaded to Vbcity. You can email me at onmouseover="window.status='Click here to Send Email' return true " onmouseout="window.status='' return true ">email me and request visdata.zip.
VISIDATA HISTOGRAM ZIP FILE
Now I have made a zip file of this project for those who do not want to go through all this. I did not find anyplace to download, but I managed to use the instructions to complete the task.
0 kommentar(er)
