Results 1 to 4 of 4

Thread: Send data to a MS Access mdb

  1. #1

    Thread Starter
    Hyperactive Member Art W.'s Avatar
    Join Date
    Apr 2002
    Location
    In My Own Little World, But that’s OK because they know me there!
    Posts
    271

    Send data to a MS Access mdb

    Hello Everyone:

    I am trying to send data to a MS Access mdb. I have looked up tons of different things but I still cannot find what I need. I am not sure of what the correct name of the operation that I am looking for is? I already have the table saved. I just want to fill one cell in the table for now. The table is not in the same folder as my program. Or would it be better to have it in the same folder, if so how do I access the data as an mdb file?

    What should I search for?

    Thanks

    Art W.
    SLEEP: A Totally Inadequate Substation For Caffeine!

  2. #2

    Thread Starter
    Hyperactive Member Art W.'s Avatar
    Join Date
    Apr 2002
    Location
    In My Own Little World, But that’s OK because they know me there!
    Posts
    271

    Re: Send data to a MS Access mdb

    Hi Again,

    I think I have found a better explanation of what I am looking for. If you were to add a button and added code to it so that it would do the same thing as what happens when you click on the Add and Save buttons on the OutputBindingNavigator toolbar, what do I need to do? I need to be able to control this from another button not from the toolbar.

    Thanks

    Art W.
    SLEEP: A Totally Inadequate Substation For Caffeine!

  3. #3
    Karen Payne MVP kareninstructor's Avatar
    Join Date
    Jun 2008
    Location
    Oregon
    Posts
    6,714

    Re: Send data to a MS Access mdb

    Sorry but the example is in VS2008, the code was actually first created in VS2005 but upgraded to VS2008. Look at the code in Sub cmdCreateUsingADOX_Click and disregard the creation of the MS-Access database code.

  4. #4
    Karen Payne MVP kareninstructor's Avatar
    Join Date
    Jun 2008
    Location
    Oregon
    Posts
    6,714

    Re: Send data to a MS Access mdb

    Quote Originally Posted by Art W. View Post
    Hello Everyone:

    I am trying to send data to a MS Access mdb. I have looked up tons of different things but I still cannot find what I need. I am not sure of what the correct name of the operation that I am looking for is? I already have the table saved. I just want to fill one cell in the table for now. The table is not in the same folder as my program. Or would it be better to have it in the same folder, if so how do I access the data as an mdb file?

    What should I search for?

    Thanks

    Art W.
    In regards to the database location, if the database is not in the executable path of your application then you need to add the path leading to the MDB in the connection string when opening the MDB.

Posting Permissions

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



Click Here to Expand Forum to Full Width