Results 1 to 8 of 8
  1. #1
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Cheltenham, Gloucestershire, England
    Posts
    214
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Database to Server problems

    When trying to create a database for a standard feedback form I got the following error. Can anybody make sense of this?

    Server error: Unable to retrieve the list of record sources from a database using the connection string:

    DRIVER={Microsoft Access Driver (*.mdb)};DBQ=URL=fpdb/form.mdb.

    The following error message comes from the database driver software; it may appear in a different language depending on how the driver is configured.
    -------------------------------------------------------
    Source: ADO
    Number: -2146824584 (0x800a0e78)

    Many thanks

    Roberta

  2. #2
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Minneapolis, Minnesota, USA
    Posts
    262
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Database to Server problems

    Roberta:

    The folks in Redmond have this to say:

    CAUSE
    This is by design. The error occurs because the permissions in the Winnt folder are too restrictive.

    RESOLUTION
    Give the local Everyone group at least Add and Read permissions on the Winnt folder.

    Note: If you are editing in a subweb and using the Global.asa file in the root Web, the author's user account, as well as any anonymous account in use, must have at least browse access explicitly specified on the root Web.

    MORE INFORMATION
    The Jet Database Engine writes temporary files to the Winnt folder as the account accessing the Web. In the case of Authoring, the account is the logged on user, and in the case of browsing, it is the Iusr_machinename account.
    <font face="Comic Sans MS"><font color=blue>~Shane</font color=blue></font face=comic>

  3. #3
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Cheltenham, Gloucestershire, England
    Posts
    214
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Database to Server problems

    Thanks for your reply. Apologies but I am lacking tech support& have been left with 1/2 the job completed! Where in the WinntFolder do I find permissions?

    I wont be working with sub webs.

    I am trying to set this up for is a group without many resources. I can teach the product but not set things up (bit like driving a car but not being able to put in a new gearbox). So again thanks for your help to date.

  4. #4
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Minneapolis, Minnesota, USA
    Posts
    262
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Database to Server problems

    Roberta:

    Happy to help if I can; goodness knows I've taken enough out of the Lounge! <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

    If you open Windows Explorer and surf to the WINNT folder, right-click on it and choose Properties. Click on the Security tab and you're almost home. On the Security tab is a list of users that currently have permissions of some sort set on the WINNT folder; when you click on one of the users, their permission level is shown below. It sounds like you need to give the local group named Everyone read and write permissions on the WINNT folder; as an aside, I'd check with your network admin if you have one to be sure he/she is hip with that level of access being granted on such an important directory.

    See if that does the trick for you, and post back with your results. Good luck!
    <font face="Comic Sans MS"><font color=blue>~Shane</font color=blue></font face=comic>

  5. #5
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Cheltenham, Gloucestershire, England
    Posts
    214
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Database to Server problems

    Thanks for your trouble. Have gone through Winnt and we seem to be ok in that area - I had a look at MS knowledge base last night and found Q216900 which actually mentioned the error code I got - dont entirely understand the rest mind you but am going to sit down and study it today. We are trying to set this up on 2 pcs at first before we attempt to go live so I can mess all I want (we are creating ghost images as we sort problems out!)

    Again thanks.

    Roberta

  6. #6
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Minneapolis, Minnesota, USA
    Posts
    262
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Database to Server problems

    That KB article gives me the impression that once you install one of the umpteen versions of MDAC, you should be all set. Best of luck!
    <font face="Comic Sans MS"><font color=blue>~Shane</font color=blue></font face=comic>

  7. #7
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Cheltenham, Gloucestershire, England
    Posts
    214
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Database to Server problems

    thanks for all you help - my database is now up and running.

    We would not have managed without your initial suggestions - these things are always about three layers deep!

    A shame you are the other side of the pond or I would buy you a large drink of some variety!

  8. #8
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Minneapolis, Minnesota, USA
    Posts
    262
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Database to Server problems

    Roberta:

    Glad you got everything working; someday soon I may ping you with Macromedia questions! For now, I prefer a good <A target="_blank" HREF=http://www.virtualbeer.com/send/index.shtml>stout</A>. <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>
    <font face="Comic Sans MS"><font color=blue>~Shane</font color=blue></font face=comic>

Posting Permissions

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