Not a Member Yet,
Click here to Register
How do you like the new design?






ID: 310
Viewed: 2983
Added: Aug 19, 2002
Version:
Snippet uploaded by: snippet
Written By: Clint LaFever
Demo: Sorry, no demo



User Rated at: 0 Stars
Rate This:

Thank you for your vote. Please wait...

It appears you already voted for this snippet

It appears your vote value was empty

Connects to a Access database using DAO

Highlight all by clicking in box
<!---Declaration--->
'------------------------------------------------------------ 
' Author: Clint LaFever [lafeverc@usa.net]
' Purpose: Used to connect to a database using DAO. Most commonly used with Access Databases.
' Parameters: ' Example:
'------------------------------------------------------------
Option Explicit
Public DataBaseName As String
Public UserName As String
Public Password As String
Public db As Database
'DAO Database variable for Local Access Connections

Highlight All
<!---Code--->
Public Function ConnectLocal() As Boolean 
On Error GoTo ConnectLocal_Error
Set db = OpenDatabase(Me.DataBaseName)
ConnectLocal = True
ConnectLocal_Exit:
Exit Function
ConnectLocal_Error:
ConnectLocal = False
Resume ConnectLocal_Exit
End Function
;


No Comments to show

Please completely fill out the form below if you want to review this snippet. All reviews are subject to validation.


Replying to a Comment...


Adding your comment. Please wait...

Thanks for adding your comment!. After further review it will be added.

There was a problem adding your comment. Please try again.

Please complete all the fields in the form before sending.

© 2002 - 2017 snippetlibrary.com All Rights Reserved. Conditions