Please help with working code. Access 2002 ADO

[hooks]

Please help with working code. Access 2002 + 2000 ADO

Hey all. I have a sample database that is ADO unbound and unlinked. Could some of you experts please look at the code and let me know how to make it better and faster. The code does work but I know very little about programming and Im sure there are easier ways of doing things.

Im not worried about the buttons. I'm more worried about the recordsets.

I have the form locked until the edit button is pushed.

I have a combo that you can add to the underlying table.

Please give me some suggestions

Thanks Hooks


Extract to C:/ so that the connection will work properly.

 

[hooks]

Bump......

 

[WayneRyan]

Hi Hooks,

Access 2000 can't open your 2K sample.

Wayne

 

[hooks]

If I post all of the code will you look at it. There is a lot of code though.

Thanks

 

[Pat Hartman]

Linking to external tables is faster and more efficient than linking on the fly. When tables are permanently linked, Jet caches information about the table and so at runtime doesn't need to obtain it again.

You have about 500 lines of code to handle this small unbound form. I didn't examine it for completeness so I don't even know if it really does work. Access does a great deal for you behind the scenes and you may not even be aware of it so you may not have replicated it.

If you insist on using an unbound form, at least permanently link the tables you are using. That will save some start up time. The db doesn't seem slow so I don't know what your problem is.

 

[hooks]

I don't have any problems with this database other than I want to learn to do things correctly.

My original goal for this test project was to get it working. Now that it works I want to make it correct if not perfect which I am nowhere near at the moment. I know there are a lot of good programmers on this site and would like to learn from them. Please help me learn to code the correct way.

Thanks again to all that have helped me.