This article was previously published under Q236545
Advanced: Requires expert coding, interoperability, and multiuser skills.
Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.
View products that this article applies to.
1. | Create a new Access database named db1.mdb. |
2. | In the new database, create a new module. |
3. | Type the following procedure in the module:
|
4. | Save and close the module. Name the module Module1. |
5. | On the Tools menu, point to SourceSafe, and then click Add Database to SourceSafe. Click Yes in the dialog box that tells you that the database is to be closed. Click OK in each dialog box. Accept all the defaults that Access gives. If you are asked to log in, enter a username, and click OK. When you are asked, click Yes to create the project. |
6. | After the database is added, you see an image of a lock next to the Module1 module. This indicates that the module is checked in. |
7. | Click the module to highlight it. On the Tools menu, point to SourceSafe, and then click Check Out. |
8. | In the Check Out Objects from SourceSafe dialog box, click Module1, and then click OK. A check mark appears next to the Module1 module. This indicates that the module is checked out. |
9. | Click the Module1 module to highlight it, and then click Design. |
10. | The Visual Basic Editor starts. Make no changes in the editor. |
11. | Leave the Visual Basic Editor open, and then return to Access. You can do so by clicking the Access button on the taskbar at the bottom of the screen. |
12. | Click the Module1 module to highlight. Point to SourceSafe on the Tools menu, and then click Check In. |
13. | Return to the Visual Basic Editor. Note that the Module1 module is still open there. |
14. |
Under the procedure that you added in Step 3, type the following new procedure:
|
15. | On the File menu, click Save db1, and then click Close and Return to Microsoft Access. |
16. | On the File menu, click Exit. |
17. | Re-open Db1.mdb, and then double-click the Module1 module. |
18. | When you are asked if you want to check out the module, click Yes. The Visual Basic Editor starts. |
Keywords: KB236545, kbpending, kbbug