program can't access database when running on other computers
hi all,
im having trouble working out on this problem. my program has a data environment to access its database (ms access). it runs fine on my computer, and ive decided to compile it. however when i try to run it on other computer (without ms access), it can't access the database and displays an error message everytime i try to access.
Code:
Run-time error '713':
Application-defined or object-defined error
any help would be greatly appreciated.
thanks!,
marlon
Re: program can't access database when running on other computers
Welcome to the forums. :wave:
What deployment package are you using?
Re: program can't access database when running on other computers
hi, thanks! wow youve got a lot of posts!ü
the package and deployment wizard. ive tried inno before but i dont know how to use it.
Re: program can't access database when running on other computers
Quote:
Originally Posted by aerialpunk
hi, thanks! wow youve got a lot of posts!ü
the package and deployment wizard. ive tried inno before but i dont know how to use it.
Did you bundle your database into the setup package?
What about MDAC?
Re: program can't access database when running on other computers
Quote:
Originally Posted by Hack
Did you bundle your database into the setup package?
What about MDAC?
yes i did that sir. and it runs well in my computer. however, when i install it on another computer, it displays an error message when i try to connect to the database. it shows my forms but everytime i try to connect to the database it shows up an error message. is it because the computer doesn't have an ms access program installed on it?
Re: program can't access database when running on other computers
No. Access isn't necessary for the client. Post some of the code that fails.
Re: program can't access database when running on other computers
Quote:
Originally Posted by dglienna
No. Access isn't necessary for the client. Post some of the code that fails.
here it is sir. everytime i pick a record to display it sends an error message.
VB Code:
Private Sub cboSelectType_Change()
'Enable data grid
DataGrid1.Enabled = True
'Display table on data grid
DataGrid1.DataMember = cboSelectType.Text
End Sub
- my DataGrid1's DataSource is DataEnvironment1.
- my DataEnvironment's Data Link Properties links to Database1.mdb
other than that, i did not use any method or step to connect to the database. please advice me on what to do sir. thanks.
appreciate your help,
marlon
Re: program can't access database when running on other computers
Your probably missing MDAC on the other systems. You can download the "Component Checker" utility from microsoft to verify that the other systems have it and what version.
Re: program can't access database when running on other computers
Quote:
Originally Posted by RobDog888
Your probably missing MDAC on the other systems. You can download the "Component Checker" utility from microsoft to verify that the other systems have it and what version.
im kinda lost sir :confused: what is MDAC? my program runs on my computer but when i try to run it on other computers it crashes everytime i try to connect with the database. ive read some cases like this on the web and what they say is that i have to include msjet40.dll on my project so that it can communicate with the database even without ms access.
Re: program can't access database when running on other computers
MDAC is Microsoft Data Access Components, like ADO 2.x
Oh, I see your using the DataEnvironment1.
Re: program can't access database when running on other computers
Quote:
Originally Posted by RobDog888
MDAC is Microsoft Data Access Components, like ADO 2.x
Oh, I see your using the DataEnvironment1.
Even so, I still think MDAC needs to be installed.
I'm wondering if whatever the DataEnvironment needs to run may not be included in the installation. The error message indicates the inability to find a particular object, and the DataEnvironment would qualify as an object.
Re: program can't access database when running on other computers
Quote:
Originally Posted by Hack
Even so, I still think MDAC needs to be installed.
I'm wondering if whatever the DataEnvironment needs to run may not be included in the installation. The error message indicates the inability to find a particular object, and the DataEnvironment would qualify as an object.
hey thanks guys for your replies :)
i see.. so what youre saying is that possibly, the problem lies in the data environment and not the access? i see.. so i have to find a way to reference the dataEnvironment in the project.. hmmm...
Re: program can't access database when running on other computers
Quote:
Originally Posted by aerialpunk
hey thanks guys for your replies :)
i see.. so what youre saying is that possibly, the problem lies in the data environment and not the access? i see.. so i have to find a way to reference the dataEnvironment in the project.. hmmm...
Have you tried tossing the dataenviroment control and using programming code to do your database work?
Re: program can't access database when running on other computers
Quote:
Originally Posted by Hack
Have you tried tossing the dataenviroment control and using programming code to do your database work?
no not at all. im not good when it comes to database programming so ive just used a data environment to help me. umm, i found out something. when you right click on the data environment, there's an option "publish components". does this have something to do with my problem? but when i try to publish it it will just save it to the local database and from there i dunno what to do next.
