cannot open the file '(unknown)'

i can't find anythingwrong with the permissions.
tell me if you think this is significant:-

when i select my dsn i choose the 'use local dsn' radio button - when i test it it says it's successful. (though it doesn't work later)

if instead i choose 'use dsn on testing server' (the testing server is on my current machine) and click test i get the same error as i get when i preview.

Hi,

After the "The Microsoft Jet database engine cannot open the file
'(unknown)'." does it then say "File already in use" or something similar?
If you open an ASP/VB page in DW, that has a link to your database
(Recordsets), it can sometime cause the temp yourdatabase.ldb to be created.
When you shut the page down, for some reason DW doesn't remove the ldb which
means that when you test the page under localhost it will not open because
the database is "already in use".

The only way to solve this is to close DW and re-open. Tedious I know, but
this is something that has been a problem since UD4 and I'm not sure if it's
been fixed yet.

Check for the existence of an .ldb file...that'll be your problem I'm sure.

HTH
Nath.

"funkster" <webforumsuser@macromedia.com> wrote in message
news:eb73g7$92l$1@forums.macromedia.com...
> Hi,
> I am getting an error when I try to test an asp page (vb) with a recordest
> in
> it.
> > When I double-click the recordset in dreamweaver and click test it works
> > fine
> though.
> I haven't got the db open elsewhere and don't think it's read-only, so I
> can't
> work it out.
> Help!
> Thanks, Mark.
>