How does your final connection string look like?
Are you connection to a SQL Server or an Access database? If you post your current connection string, we can give you some hints on what security permissions to change. It's different for both type of databases....

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
While typing this post, I was listening to: Special Cases by Massive Attack (Track 4 from the album: 100th Window)

Imar,
I have tried connecting to Access and as well as SQL... pretty close to same results. This happens when I use the GUI (Drag and Drop) to build my page. Anyway... Here was my latest String: (By the way .. Thanks for Y'alls Time)

Provider=Microsoft.Jet.OLEDB.4.0;Password="";User ID=Admin;Data Source=C:\adonetsbs\SampleDBs\nwind.mdb;Mode=Share Deny None;Extended Properties="";Jet OLEDB:System database="";Jet OLEDB:Registry Path="";Jet OLEDB:Database Password="";Jet OLEDB:Engine Type=5;Jet OLEDB:Database Locking Mode=1;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password="";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False

Right. If I were you, I'd try this:

1. Change your connection string to this:
"Provider=Microsoft.Jet.OLEDB.4.0;
Data Source=C:\adonetsbs\SampleDBs\nwind.mdb;Mode;
User ID=Admin;Password="

You don't really need the rest.

2. Make sure that the ASPNET account (or the account you're using when you're using impersonation) has access to the C:\adonetsbs\SampleDBs folder. Granting access to just the database file is not enough, as the account also needs permissions to write the .lck files.

Take a look here: http://Imar.Spaanjaars.Com/QuickDocID.aspx?QUICKDOC=263 for more details how to do this. The first half of the article doesn't apply to you (it's for classic ASP mostly), but be sure to check out the section titled: Changing the Security Settings. This section explains the steps you need to take to grant the necessary permissions.

HtH,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
While typing this post, I was listening to: Ramshackle by Beck (From the album: Odelay)

Imar,

Thanks for your help. The Article was excellent and it took me straight through the problem.

Thanks Again,
Gary Hopson