Results 1 to 5 of 5

Thread: Database Connection [Resolved]

  1. Apr 3rd, 2005, 08:52 PM #1
    Simply Me
    Simply Me is offline

    Thread Starter
    PowerPoster Simply Me's Avatar
    Join Date
    Aug 2003
    Posts
    2,748

    Database Connection [Resolved]

    Hi! I am trying to connect to my database. The database is in another computer. below is my connection code:
    VB Code:
    1. Set MyConn = New ADODB.Connection

    2. MyConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;data Source=\\NetServer\Dbase\DatLibrary.mdb"

    3. MyConn.Open

    Below is the error:
    Microsoft Jet Database engine cannot open the file '\\NetSever\Dbase\Datlibrary.mdb'. It is already opened exclusively by another user, or you need permission to view its data.
    Last edited by Simply Me; Apr 3rd, 2005 at 10:24 PM.
    To give is always to be NOBLE...
    To received is always to be BLESSED....
    Each day strive to be NOBLE
    Each day strive to be BLESSED

    If this post has helped you. Please take time to rate it.

    >=|+|=< Simply Me >=|+|=<
    ----------------------------------------
    Connection Strings | Number Only in Textbox | Splash Screen with Progress Bar | Printing to 1/2 of perforated bond paper |
    Freeze 2005 DataGridView Column
    Reply With Quote Reply With Quote
  2. Apr 3rd, 2005, 09:28 PM #2
    dglienna
    dglienna is offline
    Banned dglienna's Avatar
    Join Date
    Jun 2004
    Location
    Center of it all
    Posts
    17,901

    Re: Database Connection

    Probably has a password on the DB, or the Server
    Reply With Quote Reply With Quote
  3. Apr 3rd, 2005, 09:57 PM #3
    randem
    randem is offline
    Banned randem's Avatar
    Join Date
    Oct 2002
    Location
    Maui, Hawaii
    Posts
    11,385

    Re: Database Connection

    Simply Me,

    Check the other computer to see if it does have the database open. If not then erase the ldb file on the computer where the database is to unlock it then try again. You may have to reboot to get it to release.
    Last edited by randem; Apr 3rd, 2005 at 11:45 PM.
    Reply With Quote Reply With Quote
  4. Apr 3rd, 2005, 10:01 PM #4
    Simply Me
    Simply Me is offline

    Thread Starter
    PowerPoster Simply Me's Avatar
    Join Date
    Aug 2003
    Posts
    2,748

    Re: Database Connection

    Quote Originally Posted by dglienna
    Probably has a password on the DB, or the Server
    I dont have any password for my DB
    To give is always to be NOBLE...
    To received is always to be BLESSED....
    Each day strive to be NOBLE
    Each day strive to be BLESSED

    If this post has helped you. Please take time to rate it.

    >=|+|=< Simply Me >=|+|=<
    ----------------------------------------
    Connection Strings | Number Only in Textbox | Splash Screen with Progress Bar | Printing to 1/2 of perforated bond paper |
    Freeze 2005 DataGridView Column
    Reply With Quote Reply With Quote
  6. Apr 3rd, 2005, 10:34 PM #5
    Simply Me
    Simply Me is offline

    Thread Starter
    PowerPoster Simply Me's Avatar
    Join Date
    Aug 2003
    Posts
    2,748

    Re: Database Connection [Resolved]

    Got it now. i forgot to share the DB folder.
    To give is always to be NOBLE...
    To received is always to be BLESSED....
    Each day strive to be NOBLE
    Each day strive to be BLESSED

    If this post has helped you. Please take time to rate it.

    >=|+|=< Simply Me >=|+|=<
    ----------------------------------------
    Connection Strings | Number Only in Textbox | Splash Screen with Progress Bar | Printing to 1/2 of perforated bond paper |
    Freeze 2005 DataGridView Column
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width