program can't access database when running on other computers

[aerialpunk]

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.

Run-time error '713':
Application-defined or object-defined error

any help would be greatly appreciated.

thanks!,

marlon

[Hack]

Welcome to the forums. :wave:

What deployment package are you using?

[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.

[Hack]

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?

[aerialpunk]

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?

[dglienna]

No. Access isn't necessary for the client. Post some of the code that fails.

[aerialpunk]

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.


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

[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.

[aerialpunk]

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.

[RobDog888]

MDAC is Microsoft Data Access Components, like ADO 2.x

Oh, I see your using the DataEnvironment1.

[Hack]

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.

[aerialpunk]

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...

[Hack]

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?

[aerialpunk]

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.