Recordset is not Updatable

Set mydb = Opendatabase("",false,false,"ODBC;DSN=MSSQLSRV;")
Set Data1.Recordset = mydb.OpenRecordset("test_table",dbOpenDynaset)
Now if I check Data1.Recordset.Updatable , it is false. Why ? mydb.Updatable is True. How can I create an updatable recordset on Data1 without setting the Data Control's Connect and Datasource property. I dont want the Data Control to open a connection of its own to the MS SQL Server 6.5 I have also tried Dim rs as Recordset but even rs turns out to be Updatable False.
sudhin031597Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

sudhin031597Author Commented:
Edited text of question
cymbolicCommented:
If accessing SQL server, you should be using RDO from the Enterprise Edition.  Also, Table methods are not well received in an SQL server environment, because everybody else gets locked out, and that's a bad thing.  Finally, you need to step up to unbound controls, and manage the population and updating of resultsets in your own code.  And, you need to get to creating read only resultsets of limited scope (# rows), with update/insert using the execute method, rather than .edit/.update methods, because these as well make the SQL Server lock pages for a computer eternity, and that is also a bad thing!

I recommend you read "Hitchiker's Guide to Visual Basic & SQL (Server) from Microsoft Press, before you go much farther, or at least have it open as a reference.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
sudhin031597Author Commented:
I teach RDO to my students ! I can open an updatable resultset
and any DAO recordset turns out to be read-only. I thought this
could be a well-known bug and somebody could tell me the latest
bug-free version.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic Classic

From novice to tech pro — start learning today.