use ADO with Access.mdb

[Martin]

Hi,
Can I use ADO with a normal access.mdb (not project adp with MS SQL Server)?
I want to bound ADO Recordset to Access form...

Once I can bound a recordset to a form with
set form1.recordset = RS

but than the form is readonly

Thanks

 

[Brendan Reynolds]

Depends on the version of Access. In Access 2000, the form will be read
only, and as far as I know there isn't anything you can do about that. In
Access 2003 this is no longer the case. I'm not sure about Access 2002. The
article at the URL below seems to indicate that the form can be read/write
in Access 2002 ...

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbaac10/html/acproRecordset.asp

If you or your target users are using Access 2002, you'll want to check out
this article as well ...
http://support.microsoft.com/default.aspx?scid=kb;en-us;288276

While you're at the MSDN site, try a search on keywords 'access form
recordset property' - there may be some other articles in the search result
that may be of interest too.

 

[Martin]

Thanks very much
In access 2002 it works.

Martin