I am trying to create a web service, that calls a dll that uses MS
Access, Jet engine and DAO. When the dll tries to open the database, I
get error message "Could not lock file".
There is no ldb-file, i.e. the database should not be locked.
I have tried to give the mdb-file authorities to ASPNET and the
IUSR_machine account, but still it doesn't work. I have tried to
access the same database by ADO .NET and that works.
I know that we should convert from DAO to ADO .NET but it is not
possible right now because of deadlines, budgets and so on.
Re: Knowledge Base Help Not working ...Database is a DAO object. ... both Access 2000 and 2002 use ADO....Microsoft DAO 3.6 Object Library, ... For example, to ensure that you get a DAO recordset, you'll need to ... (microsoft.public.access.formscoding)
Re: ADO and the Find method ... You cannot compare DAO and ADO....database, which has OLEDB provider. ... >>>> Opening of the whole table was not a good design anytime.... (microsoft.public.vb.database.ado)
Re: Crosstab query error 3104 ... Thankfully very few compile errors had to ... I have both DAO & ADO references checked but DAO is higher so it is taking ... Thanks - I inherited the original database & am gradually working through ... then perhaps you've removed the reference to ADO.... (microsoft.public.access.queries)
Re: Database variable change from 97 to 2003 ... Access 2003 has references set to both DAO... and ADO and, perhaps unfortunately, the ADO reference is set higher in ... use Dim rcd As ADODB.Recordset) ... > modules, however, I get errors on the database variable... (microsoft.public.access.modulesdaovba)
Re: Creating tables ... Frederico has recommended you to replace the solution with an ADO one. ...DAO is "Data Access Objects". ... direct interface to the database engine and it is being implemented in open ...SQL Server with stored procedures and triggers, ... (comp.lang.cobol)
