Empty error dialog box when testing a Recordset, then get MM_ERROR in Bindings -
11-11-2004
, 06:40 AM
Im having a problem creating a recordset on an Access Database using a
custom connection string.
My connection string is:
"Provider=Microsoft.Jet.OLEDB.4.0; Data
Source=c:\inetpub\wwwroot\test\database\mydb.mdb; Persist Security
Info=False"
and it tests ok and i can see that it has a table in it
then when i create a recordset, i choose my connection, and i can see
the table and the fields it has in it. I chose no filter and no sort,
but when i click Test i get a Macromedia Dreamweaver MX 2004 with no
text in it, just an OK button.
If I OK the recordset dialog, it appears under Bindings with an
MM_ERROR.
Ive added in another database and a new connection for it and that one
works ok so I imagine it could be a problem with my access database,
which incidently is saved in Access 2000.
TIA
Doug |