Hi All

I have developed a program that was actually based on MS Access as the Database
backend. And I use the ADO cursortype as adOpenDynamic. However, my program
now needs to be able to access SQL Server as well but when I run my program
to add a new record inside Access, I receive an Error stating that the cursor
type is Read-Only.

Can someone advise me, if I need to develop a program that access both the
SQL server as well as MS Access, what is the cursortype should be for that
matter.

I understand that adOpenDynamic would allow you to view other update, addition
of records made by other users. What does this mean actually? Once your recordset
is defined, how is it that you are able to determine any new entry from other
users?


rgds,
Saiful