Results 1 to 10 of 10

Thread: Access Database Error!!!!!

  1. #1

    Thread Starter
    Lively Member milen's Avatar
    Join Date
    May 2006
    Posts
    116

    Lightbulb Access Database Error!!!!!

    Hii Evrey body
    i Have A probleme in my database ,when i click in add button and write the information (in textbox's) without minimized my app form it's work and save it to the database, but when i minimized my form to copying and paste it to textbox's it's not work and don't save it, i guess it's probleme of timeout but i put this code in my form_load.
    ----------------------------------
    Adodc1.ConnectionTimeout = 0
    Adodc1.CommandTimeout = 0
    ----------------------------------
    so it's not work , please corecct this code to me or give me a solution
    Thnk's
    Milen
    All This Life ,Just To THINK
    http://www.micronet-dz.com/

  2. #2
    Don't Panic! Ecniv's Avatar
    Join Date
    Nov 2000
    Location
    Amsterdam...
    Posts
    5,343

    Re: Access Database Error!!!!!

    So when you add the data in the text boxes and save it (uh when?) it works, but if you minimise your form, to copy data then paste it into your form text boxes the record is not saved or a blank record is saved?

    Or do you put the data in the text boxes but then it doesn't save?

    You probably need to send a .update or .save method on your data controls.

    Good luck

    BOFH Now, BOFH Past, Information on duplicates

    Feeling like a fly on the inside of a closed window (Thunk!)
    If I post a lot, it is because I am bored at work! ;D Or stuck...
    * Anything I post can be only my opinion. Advice etc is up to you to persue...

  3. #3
    VB Guru ganeshmoorthy's Avatar
    Join Date
    Dec 2005
    Location
    Sharjah, United Arab Emirates
    Posts
    3,031

    Re: Access Database Error!!!!!

    could you post your code for saving the record, so that we can analyse and help you better...
    If an answer to your question has been helpful, then please, Rate it!

    Have done Projects in Access and Member management systems using BioMetric devices, Smart cards and BarCodes.


  4. #4
    Member
    Join Date
    Mar 2007
    Posts
    61

    Re: Access Database Error!!!!!

    yes what ganeshmoorthy is saying right.. u please post the code

  5. #5
    Fanatic Member Dnereb's Avatar
    Join Date
    Aug 2005
    Location
    Netherlands
    Posts
    863

    Re: Access Database Error!!!!!

    Did you try a reasonable Timeout period like 5 seconds instead of expecting instant data transfer?
    why can't programmers keep and 31 Oct and 25 dec apart. Why Rating is Useful
    for every question you ask provide an answer on another thread.

  6. #6

    Thread Starter
    Lively Member milen's Avatar
    Join Date
    May 2006
    Posts
    116

    Re: Access Database Error!!!!!

    Sorry, For my late i was studing in the university
    This is my save code guys
    -----------------------------------------------------
    If MsgBoxEx2.Result = mbYes Then
    Adodc1.Recordset.Update
    Adodc1.Refresh
    ARButton10.Enabled = False
    ARButton7.Enabled = False
    ARButton9.Enabled = True
    ARButton5.Enabled = True
    ARButton8.Enabled = True
    c(2).Caption = Adodc1.Recordset.RecordCount
    MsgBoxEx3.Show
    Call Command3_Click
    End If
    ------------------------------------------------
    All This Life ,Just To THINK
    http://www.micronet-dz.com/

  7. #7

    Thread Starter
    Lively Member milen's Avatar
    Join Date
    May 2006
    Posts
    116

    Re: Access Database Error!!!!!

    Is there any answer guy's PLz
    All This Life ,Just To THINK
    http://www.micronet-dz.com/

  8. #8
    VB Guru ganeshmoorthy's Avatar
    Join Date
    Dec 2005
    Location
    Sharjah, United Arab Emirates
    Posts
    3,031

    Re: Access Database Error!!!!!

    where are you assigning values to the recordset...are they bound controls..
    If an answer to your question has been helpful, then please, Rate it!

    Have done Projects in Access and Member management systems using BioMetric devices, Smart cards and BarCodes.


  9. #9

    Thread Starter
    Lively Member milen's Avatar
    Join Date
    May 2006
    Posts
    116

    Re: Access Database Error!!!!!

    No Bound controls, i set automateclly option of saving
    All This Life ,Just To THINK
    http://www.micronet-dz.com/

  10. #10
    Don't Panic! Ecniv's Avatar
    Join Date
    Nov 2000
    Location
    Amsterdam...
    Posts
    5,343

    Re: Access Database Error!!!!!

    Adodc1 suggests a bound control

    BOFH Now, BOFH Past, Information on duplicates

    Feeling like a fly on the inside of a closed window (Thunk!)
    If I post a lot, it is because I am bored at work! ;D Or stuck...
    * Anything I post can be only my opinion. Advice etc is up to you to persue...

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