Thanks, Sloan!  (got your name right this time - sorry about that!)

The difference with my application is that when my main form loads,...

THanks, Steve - no, I only display one record on my form at a time, so I only need to be able to edit one at a time.

But I need...

Thanks for all the replies, everyone!  I've started migrating my recordset creation, insertion, etc, into stored procedures, but am having some issues.

I use my main recordset to populate my form, and...

Thanks again, everyone!

I will start by creating stored procedures - most of you just mention for inserts, deletes, and updates.  Would you also use SP for simply selecting data to...

Thanks, sholliday!  I'm really learning a lot here...and lerning that I have a lot to do.

Most of your suggestions I htink I can...

Thank you everyone for your replies!

I read the article that Jonathon posted "Performance Tuning Tips...

Hmmm, no I didn't check that.  I guess I should make sure the right fields are indexed - I'm off to figure out how to do that haha!

Thanks!

Christy

Thanks again, Michelle!  From what I can figure, it shouldn't affect much to have users insert directly into the server database - a couple of things, but I can rewrite the...

Hi Michelle,

Thanks for your reply!  I'm not sure if I should allow each user to connect directly to the server database or not.  Here's my reasoning...

In designing the application, it was...

Thanks for the tip, Patrick. Somebody else also mentioned this to me, and I'm going to look into it right now. THey said that since I always connect...

Thanks, Alamir!

I think I will use ADO and Access first, and try to get that up and running. Baby steps first. 🙂

Thank you SO much for all your help -...

Ok, Alamir, I think I understand now. I had intended to try and make my ADO code work with my Access database first, but I guess that's really creating...

Thanks so much, Alamir!

Ok, so let me make sure I have this straight. I will do some more research into the upsizing wizard - I have Access XP (2002)...

Thanks, Alamir. 🙂 No, I didn't want to do it in one step - I still plan to do it in three steps, I just figured that the best...

Well, the thing is - I don't want to take the simplest route, I want to take the most stable route, with a result that will last a while. ...