Problem viewing data

[Eric72]

Hello,

Still trying to get things woeking, but now I got stuck again.
I can't get view my data, each time I get this error:

"Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data."

I tried everything sofar, I have set-up the tutorial from Townsend café, and that is working fine.
But as soon as I use my own database (with connection and recordset) I got the error again.
Funny thing is, when I restore the situation back to the files, connection and recordset from the Tutorial (café Townsend) I get the same error. Only when I shut down dreamweaver, and re-open it, the life data view works.

What can I do?
I assume I have to adjust authorizartion in the IIS, but how?

Last thing I can and will try, is to import my tables into the sample database, but that shouldn't be the way.

How can help me out?

Thanks!

Eric

[Newsgroup_User]

In Windows explorer, go to the Security tab and find the IUSR_computer name
user and add that to your allowed list. Give that user read, execute and
write permissions.

--
Nancy Gill
Adobe Community Expert
Author: Dreamweaver 8 e-book for the DMX Zone
Co-Author: Dreamweaver MX: Instant Troubleshooter (August, 2003)
Technical Editor: DMX 2004: The Complete Reference, DMX 2004: A Beginner''s
Guide, Mastering Macromedia Contribute
Technical Reviewer: Dynamic Dreamweaver MX/DMX: Advanced PHP Web Development

"Eric72" <webforumsuser@macromedia.com> wrote in message
news:eng67j$7v7$1@forums.macromedia.com...
> Hello,
>
> Still trying to get things woeking, but now I got stuck again.
> I can't get view my data, each time I get this error:
>
> "Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC
> Microsoft Access Driver] The Microsoft Jet database engine cannot open the
> file
> '(unknown)'. It is already opened exclusively by another user, or you need
> permission to view its data."
>
> I tried everything sofar, I have set-up the tutorial from Townsend café,
> and
> that is working fine.
> But as soon as I use my own database (with connection and recordset) I got
> the
> error again.
> Funny thing is, when I restore the situation back to the files, connection
> and
> recordset from the Tutorial (café Townsend) I get the same error. Only
> when I
> shut down dreamweaver, and re-open it, the life data view works.
>
> What can I do?
> I assume I have to adjust authorizartion in the IIS, but how?
>
> Last thing I can and will try, is to import my tables into the sample
> database, but that shouldn't be the way.
>
> How can help me out?
>
> Thanks!
>
> Eric
>
>

[Eric72]

Thanks Nancy,
I can't find the IUSR-[username] adjustmens however.
I run Windows XP-Proffesional with IE6, and have at Internet Options (I run a Dutch version, I assume Extra = Tools, it has Internet Options below) a security tab, with only the adjustments for Internet, Intranet, Trusted sites, restricted sites, etc. I can't find the IUSR nowhere.

None the less I have been experimenting a bit more, also searched on google, and I got a bit closer to the solution.
The funny thing now is, that if I press the Live Data View button (or F12, preview in browser) I sometimes get to see the data, but most of the times an error page with ; Provider (0x80004005) Unspecified Error.
The funny thing is that if I close the Live Data view, open outside the program with IE another page, like this forum, and close it again, the Live data view will work one time. So each time I have to open and close another page.
It's almost like it can make the connection once only, and needs to be resetted by opening and closing another page.

What can I do about that, and where do I find the IUSR settings? Are those the same as I can adjust at IIS [username] - [website]?

Best regards,
And many thanks,
Eric