-
Dec 31st, 2011, 07:52 AM
#1
Thread Starter
Lively Member
[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.
-
Dec 31st, 2011, 10:48 AM
#2
Re: Microsoft Jet Database Engine could not find object databases.
How do you connect to your database? Please show us actual connection string.
-
Jan 3rd, 2012, 01:10 AM
#3
Thread Starter
Lively Member
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
-
Jan 3rd, 2012, 03:05 PM
#4
Frenzied Member
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
-
Jan 3rd, 2012, 04:09 PM
#5
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
-
Jan 4th, 2012, 04:26 AM
#6
Thread Starter
Lively Member
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.
-
Jan 4th, 2012, 11:10 AM
#7
Re: Microsoft Jet Database Engine could not find object databases.
How did you deploy your entire app?
-
Jan 5th, 2012, 06:55 AM
#8
Thread Starter
Lively Member
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.
-
Jan 5th, 2012, 08:14 AM
#9
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.
-
Jan 7th, 2012, 12:52 AM
#10
Thread Starter
Lively Member
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.
-
Jan 7th, 2012, 01:17 AM
#11
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?
-
Jan 7th, 2012, 04:36 AM
#12
Thread Starter
Lively Member
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.
-
Jan 7th, 2012, 04:40 AM
#13
Re: Microsoft Jet Database Engine could not find object databases.
Originally Posted by yasrab
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' ?
-
Jan 7th, 2012, 11:53 AM
#14
Re: Microsoft Jet Database Engine could not find object databases.
Which. is. exactly. what. I. thought. I. was. asking. back. in. post. #5...
-tg
-
Jan 9th, 2012, 12:33 AM
#15
Thread Starter
Lively Member
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 9th, 2012 at 12:40 AM.
-
Jan 9th, 2012, 12:52 AM
#16
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.
-
Jan 11th, 2012, 02:14 AM
#17
Thread Starter
Lively Member
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|