Hi Kirsten,

The connectionstring looks fine to me.

A few things to check:

1. Are you running your webserver locally? If not, does this path exist on 
the server?
2. Does the IUSR_MachineName account have sufficient rights to the database 
and the folder it resides in?
3. Did you declare and assign all your variables in your code?
4. Did you add Option Explicit on top of the page? This really helps 
producing better code.

If all this doesn't help, please post the code for the entire page.

Cheers,

Imar


At 08:33 PM 2/22/2003 +0000, you wrote:
>Hi Again - thanks to everyone who responded to my connection string
>dilemna!
>
>I took a look at all the possibilities you suggested, but since I am
>following the book and have already checked the errata, I don't think my
>connection problems are coming from the SQL statements or the way my
>variables are declared. According to microsoft support site, it is quite
>possible that my connection string is wrong. But I've tried everything -
>DSN-less, ADO, OLE-DB, etc. NOTHING works - I either get syntax or
>argument-based error messages. I really think I'm making a mistake with
>the connection string itself. Here is what I'm using now:
>
>strConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data
>Source=C:\databases\camerastoredb.mdb;User ID=Admin;Password=""
>
>Is there something wrong with the syntax that anyone can see? I'm running
>on Windows 2000, if that makes a difference. Thanks again in advance for
>any help! :)
>Kirsten