Results 1 to 8 of 8

Thread: Access problems. Again

  1. #1

    Thread Starter
    Fanatic Member pax's Avatar
    Join Date
    Mar 2001
    Location
    Denmark
    Posts
    840

    Access problems. Again

    Hi again.

    Regarding this thread:
    http://www.vbforums.com/showthread.php?threadid=295720

    It's not solved actually. I thougt it was, but then I tried to change some data in dataset and do an update. Then it complained about needing an updateable query.

    Has something changed radically since Framework V1.0?
    Keeping in mind, that this project have worked just fine until now.

    So, does anyone have webapplication where you both read and write to an access DB?
    If so, may I see your connectionsstring, and some screenshots of your IIS settings for the application?

    Thank's.
    I wish I could think of something witty to put in my sig...

    ...Currently using VS2013...

  2. #2
    Fanatic Member venerable bede's Avatar
    Join Date
    Sep 2002
    Location
    The mystic land of Geordies
    Posts
    1,018
    You need to give your user the correct permissions on the folder that contains the Access database.

  3. #3

    Thread Starter
    Fanatic Member pax's Avatar
    Join Date
    Mar 2001
    Location
    Denmark
    Posts
    840
    Hi.

    Thank's.

    But can you please tell me how to do it like I'm 4 years old?

    I'm just running the app from LocalHost, so shouldn't I allready have those permissions?

    I have also tried putting the DB in the same folder as the ASPX files. I also tried to put it in the Bin directory. None worked.

    The only change in system that I can think of is that I have formatted my harddrive in NTFS. Before it was FAT32. I don't know if that means anything or not.

    Thank's again
    I wish I could think of something witty to put in my sig...

    ...Currently using VS2013...

  4. #4
    Fanatic Member venerable bede's Avatar
    Join Date
    Sep 2002
    Location
    The mystic land of Geordies
    Posts
    1,018
    What Operating System do U have ?

  5. #5

    Thread Starter
    Fanatic Member pax's Avatar
    Join Date
    Mar 2001
    Location
    Denmark
    Posts
    840
    Hi.

    I'm using Win XP Pro with SP1, and IIS 5.1 (I think...I'm not at my own PC at the moment)
    I wish I could think of something witty to put in my sig...

    ...Currently using VS2013...

  6. #6
    Fanatic Member venerable bede's Avatar
    Join Date
    Sep 2002
    Location
    The mystic land of Geordies
    Posts
    1,018
    Right click on the folder that has your access database and choose "Properties".

    Click on the sharing tab.
    Click on Permissions.
    Click on Add and choose your ASPNET/USER( something like that ) then give them full rights for testing.

    Hope this helps.

  7. #7

    Thread Starter
    Fanatic Member pax's Avatar
    Join Date
    Mar 2001
    Location
    Denmark
    Posts
    840
    Thank You Thank You Thank You.

    That did it. Who would have thought that a normal fileshare did it?
    Well, maybe everybody else but me.

    But anyway, it works now.
    I wish I could think of something witty to put in my sig...

    ...Currently using VS2013...

  8. #8
    Fanatic Member venerable bede's Avatar
    Join Date
    Sep 2002
    Location
    The mystic land of Geordies
    Posts
    1,018
    Glad I could help.
    Everyone has this problem at one time or another.
    It can be a bit of a pain.

Posting Permissions

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



Click Here to Expand Forum to Full Width