[RESOLVED] Microsoft Jet Database Engine could not find object databases.-VBForums
Results 1 to 17 of 17

Thread: [RESOLVED] Microsoft Jet Database Engine could not find object databases.

  1. #1

    Thread Starter
    Lively Member
    Join Date
    Nov 2011
    Posts
    74

    Resolved [RESOLVED] Microsoft Jet Database Engine could not find object databases.

    wheever i run a vb application then it gives a msg below upon connecting to aceess database:

    Microsoft Jet Database Engine could not find object 'databases'. Make sure the object exists and that you spell its name and path name correctly.

  2. #2

  3. #3

    Thread Starter
    Lively Member
    Join Date
    Nov 2011
    Posts
    74

    Re: Microsoft Jet Database Engine could not find object databases.

    following lines are used to connect with database through a vb application. used this database severally for inserion and retrieval of data but after some days it gives the error mentioned above.

    Public db As New ADODB.Connection
    Public ers As New ADODB.Recordset

    Private Sub makeConnection()
    db.CursorLocation = adUseClient

    db.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source= " & App.Path & "\PakistanProperty.mdb ;Persist Security Info=False"

    de.Connection1 = db

    End Sub

  4. #4
    Frenzied Member
    Join Date
    Jan 2009
    Location
    Watch Window(Shift+f9)
    Posts
    1,768

    Thumbs up Re: Microsoft Jet Database Engine could not find object databases.

    following lines are used to connect with database through a vb application. used this database severally for inserion and retrieval of data but after some days it gives the error mentioned above.
    Your connection string is wrong .try the following way !

    Code:
    Public db As New ADODB.Connection 
    Public ers As New ADODB.Recordset
    
    Private Sub makeConnection()
    db.CursorLocation = adUseClient
    
    db.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source= " & App.Path & "\" & PakistanProperty.mdb ;Persist Security Info=False
    
    de.Connection1 = db why did you use this line ?
    
    End Sub

  5. #5
    PowerPoster
    Join Date
    May 2002
    Posts
    24,075

    Re: Microsoft Jet Database Engine could not find object databases.

    firoz - first there was nothing wrong with the connection string... in fact, your version only compounds the problem as it leaves half of it out of the string that it needs to be in.
    secondly, that line you questioned, is setting the connection of the DataEnvironment of the app...

    which makes me wonder...

    1) The error in question, doesn't jive with the code provided. Somewhere in your code you've used the object databases... but it's not in the code posted so far... so it's somewhere else.
    2) What's with the use of the DataEnvironment?

    -tg
    * I don't respond to private (PM) requests for help. It's not conducive to the general learning of others.*
    * I also don't respond to friend requests. Save a few bits and don't bother. I'll just end up rejecting anyways.*
    * How to get EFFECTIVE help: The Hitchhiker's Guide to Getting Help at VBF - Removing eels from your hovercraft *
    * How to Use Parameters * Create Disconnected ADO Recordset Clones * Set your VB6 ActiveX Compatibility * Get rid of those pesky VB Line Numbers * I swear I saved my data, where'd it run off to??? *

  6. #6

    Thread Starter
    Lively Member
    Join Date
    Nov 2011
    Posts
    74

    Re: Microsoft Jet Database Engine could not find object databases.

    kindly note that the error only comes during execution after deployment but not during coding.

  7. #7

  8. #8

    Thread Starter
    Lively Member
    Join Date
    Nov 2011
    Posts
    74

    Re: Microsoft Jet Database Engine could not find object databases.

    through inno 5.0 bcoz it cudnt deploy in win 7 through package and deployment tool. first i create setup in vb by package and deploy tool and then make another setup in inno 5.0 by giving its exe path and other files in the support folder and then create its script.
    thanx.

  9. #9
    PowerPoster RhinoBull's Avatar
    Join Date
    Mar 2004
    Location
    New Amsterdam
    Posts
    24,133

    Re: Microsoft Jet Database Engine could not find object databases.

    There might be something wrong with your distribution package however since I'm not familiar with INNO I would recommend checking this with someone at Application Deployment forum.

  10. #10

    Thread Starter
    Lively Member
    Join Date
    Nov 2011
    Posts
    74

    Re: Microsoft Jet Database Engine could not find object databases.

    well i use inno for win 7 bcoz the application even not installed by "Run as admin". the database was built by access 2003/07 but now i m using access 2010 so cud be a version conflict. any sugestion.

  11. #11
    PowerPoster
    Join Date
    Jul 2006
    Location
    Maldon, Essex. UK
    Posts
    6,259

    Re: Microsoft Jet Database Engine could not find object databases.

    This may be a silly question, but have you checked that the Database has been installed into the same folder as the program?

  12. #12

    Thread Starter
    Lively Member
    Join Date
    Nov 2011
    Posts
    74

    Re: Microsoft Jet Database Engine could not find object databases.

    Doogle kindly read thread carefully and ys the database is in the same folder. Now i place a database that was copied earlier for its backup and it work fine. but whenever i ammend the database by adding new column and even data during coding it doesnt work after installation of setup.

  13. #13
    PowerPoster
    Join Date
    Jul 2006
    Location
    Maldon, Essex. UK
    Posts
    6,259

    Re: Microsoft Jet Database Engine could not find object databases.

    Quote Originally Posted by yasrab View Post
    Doogle kindly read thread carefully
    I think I have. There's no mention that you'd checked that anywhere.

    The question boils down to what the Object "databases" is. So where in your code do you define and use 'databases' ?

  14. #14
    PowerPoster
    Join Date
    May 2002
    Posts
    24,075

    Re: Microsoft Jet Database Engine could not find object databases.

    Which. is. exactly. what. I. thought. I. was. asking. back. in. post. #5...

    -tg
    * I don't respond to private (PM) requests for help. It's not conducive to the general learning of others.*
    * I also don't respond to friend requests. Save a few bits and don't bother. I'll just end up rejecting anyways.*
    * How to get EFFECTIVE help: The Hitchhiker's Guide to Getting Help at VBF - Removing eels from your hovercraft *
    * How to Use Parameters * Create Disconnected ADO Recordset Clones * Set your VB6 ActiveX Compatibility * Get rid of those pesky VB Line Numbers * I swear I saved my data, where'd it run off to??? *

  15. #15

    Thread Starter
    Lively Member
    Join Date
    Nov 2011
    Posts
    74

    Re: Microsoft Jet Database Engine could not find object databases.

    there is no object 'databases' in the code. i also found during search that error like the microsoft jet database engine could not find the object 'msysdb' and i think it doesnt mean that the object 'msysdb' was rightly used in the code.
    Last edited by yasrab; Jan 8th, 2012 at 11:40 PM.

  16. #16
    PowerPoster
    Join Date
    Jul 2006
    Location
    Maldon, Essex. UK
    Posts
    6,259

    Re: Microsoft Jet Database Engine could not find object databases.

    Haing Googled around for the error message it seems that this message indicates that the Database is corrupted. You could try a 'Compact and Repair' on it.

  17. #17

    Thread Starter
    Lively Member
    Join Date
    Nov 2011
    Posts
    74

    Re: Microsoft Jet Database Engine could not find object databases.

    thanks i have recovered database by repair tool.

Posting Permissions

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



Featured


Click Here to Expand Forum to Full Width

Survey posted by VBForums.