Thanks, Angela.

You are right, ApptID is an integer (I think my brain was only firing half time)I am passing the value of ApptID in from ADO code. So would...

I think Alamir may have mentioned the same book, but Microsoft Developer's Guide to SQL Server by Mary Chipman and Andy Baron is in my opinion by far the best...

Only one issue to avoid that I have run into: make sure your bit fields in SQL are set to NOT NULL. MS Access cannot handle nulls in bit fields...

Nevermind. I figured out the problem is elsewhere. The code is working okay now. Thanks,

SMK

Steve:

Thanks. I am not stating my question clearly and it's a long shot, anyway. I think what I am after is automation. I want to run one program from another,...

Hmmmm, interesting.

So if I have something like "right" and "left" that I want to designate as R or L instead of 1 and 2, there is no reason not...

Thanks, guys! My data is normalized, I am just trying to put the finishing touches on it so I don't have to make any more changes. I am trying to...

mbarr: I feel your pain because I have also been fighting this issue for a matter of months. What I have found out through MSDN and other sources is that...

Thanks, Antares. I don't have specific question just yet. Just migrating my frontend app from MS Access to developing a middle tier with all the business logic (in ADO.NET, I...

Richard: dynamically creating SQL tables: Do you mean using ADO and creating temporary tables to populate forms on the FE? If so, I'd like to hear more about that as that's...

The fastest solution is as you stated, SQL BE with Access .mdb FE. You will get faster performance in the corporate setting with an Access .adp FE but it requires...

Thanks, Peter. I will check out these leads. I am specifically working on clinical patient records, a very different horse from the billing/payer mindset. The information we (docs) need to...

I don't think you need to deal with ADO if you are just trying to return to the pertinent record. Try this syntax:

Private Sub Form_AfterUpdate()

    Dim iBook As Variant  

    iBook...

My post got cut off somehow. What I was saying is that the

cmd.ActiveConnection = CurrentProject.Connection

works fine in the .mdb apps as well as .adp

I have an .mdb and use that...

Mike: I believe that