Post reply

inserting records into an adp microsoft access project

  • July 17, 2007 at 5:45 pm

    #73332

    I wanted to find out if I have a Microsoft Access adp project and I want to add in records into the tables which are linked to sql server 2000, does access 2003 allow you to do this and if so how?

    What I'm trying to accomplish is to have a user enter information into a form, click a submit button where it inserts each record into one of the sql server tables.

    Any help would be greatful.

    Eric

  • July 17, 2007 at 11:32 pm

    #720261

    Use ADO as your app model: define a connection and an updateable recordset objects.

  • July 18, 2007 at 7:51 am

    #720366

    The answer to your question is yes.  Just create a new access project and point to your SQL 2000.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply