Professional Web Applications Themes

How do I open a database connection on an access file that currently open ? - ASP.NET General

Hi, I have create a connection to an access database, but before I close the connection, another user cannot run the web application correctly, I got the error Operation is not allowed when the object is open. is it the problem of my connection string ? thanks...

  1. #1

    Default How do I open a database connection on an access file that currently open ?

    Hi,

    I have create a connection to an access database, but before I close the
    connection,
    another user cannot run the web application correctly, I got the error
    Operation is not allowed when the object is open.

    is it the problem of my connection string ?

    thanks


    THY Guest

  2. #2

    Default Re: How do I open a database connection on an access file that currently open ?

    access files accept only one connection (this is a file : when it's open
    it's locked ) you have to use a server like MSSql,MySql,Oracle,...


    Gönen Guest

  3. #3

    Default Re: How do I open a database connection on an access file that currently open ?

    If it is locked, why we still can open the data file using ms access ?

    btw, can we make the page to hold until the database is close then open it ?
    so the user wont get any error if the database currently is opened ...
    is this possible ?


    "Gönen EREN" <edu.tr> wrote in message
    news:phx.gbl... 


    THY Guest

  4. #4

    Default Re: How do I open a database connection on an access file that currently open ?

    I don't know much about mysql ...
    how do I connect mysql with ASP.NET ?

    and can mysql import access ?

    thanks


    "Gönen EREN" <edu.tr> wrote in message
    news:phx.gbl... 
    access... 


    THY Guest

  5. #5

    Default Re: How do I open a database connection on an access file that currently open ?

    no you have to use oledb

    download mysql server and mycc or an alternatif to this mysql front ( last
    two are gui 's)

    then connect using a connection string




    "THY" <com> wrote in message
    news:%phx.gbl... 
    > may 
    > >
    > >[/ref]
    >
    >[/ref]


    Gönen Guest

Similar Threads

  1. Error 500 on second Open to Access Database
    By SteveB in forum ASP Database
    Replies: 1
    Last Post: June 14th, 04:56 AM
  2. Open file, make changes, save file, close, re-open, file contents not changed
    By brock@bergdesign.com in forum Adobe Illustrator Macintosh
    Replies: 7
    Last Post: March 7th, 07:29 PM
  3. Replies: 3
    Last Post: November 30th, 10:14 PM
  4. asp.net ms-access oledb connection open error
    By Mathew in forum ASP.NET General
    Replies: 2
    Last Post: August 15th, 05:37 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139