Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004
    New Zealand
    Provided Answers: 9

    Unanswered: MS Access to SQL

    well I see in 2003 you can create a .adp file

    I imported all my tables in SQL server the created a new Project file .adp

    I have link the table to the Project file
    how do you link comboboxs back to the forms

    in old accress you could just put this in the
    [Forms]![formName]![feildName] in the criteria of the combo box

    how does one do it in a adp file or is this the wrong way of doing it

    do I go back to odbc conection
    hope this help

    See clear as mud

    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008

  2. #2
    Join Date
    Dec 2004
    Madison, WI


    I looked at the option of creating ADP files to SQL Server and decided to go the route of writing my code in MSAccess to use unbound forms (i.e. open the recordset and populate the unbound fields on the form, and then on closing the form, opening the recordset and updating the fields if a checkbox (DataUpdated) is checked when the form is closed. The DataUpdated field is marked to true if an afterupdate event occurs on each or any of the fields.

    I like this method as it seems to work very well in a client-server environment with many users using the same mde's and it also makes it easy to create new fields in SQL Server without having to look at outstanding transactions (which could take a while on large recordsets if the form is bound and open by the user).

    We are experimenting with ADP projects but I'm not 100% convinced that this would be an ideal method for us and there wouldn't be some problems with updating/adding fields in SQL Server.

    Thus, I really like the unbound forms method in mdb/mde's. We have functions to Write/Update/and Delete. I just wanted to give you my feedback on this and another option but I don't know your circumstances.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

  3. #3
    Join Date
    Mar 2003
    The Bottom of The Barrel
    Provided Answers: 1
    Myle, you know better.

    Give more background on what you're doing and what behavior you'd like to see.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts