Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Microsoft Access problem

  • 13-12-2004 12:19pm
    #1
    [Deleted User]
    Posts: 0 ✭


    Hey all,

    When running a visual basic application to access a MS Access database, the following error appears:

    The microsoft jet database engine cannot find the input table or query
    'table'. Make sure that it exists and that its name is spelled correctly.
    Source microsoft jet database engine.
    number -2147217865

    Usually this means that the table doesn't exist, that's fair enough.
    But it's appearing even though the table DOES exist, so I'm thinking maybe the database becomes corrupted, although i'm sure other errors would appear in that case.

    Or does Access mess up if an application remains connected to it for long periods of time?

    Any thoughts/tips/suggestions on how to solve the above?
    Thanks, any help would be great


Comments

  • #2
    jessy
    Registered Users, Registered Users 2 Posts: 950 ✭✭✭jessy


    Are you writing/Dev the VB app thats causeing the error?

    A required field is missing, if you’re doing an update on the DB or modifying it in some way.

    You need to check for NULL values.


Advertisement