Good day.
I have recently modified and Access 2003 application to connect to tables in Oracle via OBDC. I set up a System DNS for this purpose using the driver Oracle in OraHome92. I also linked the Oracle tables and modified all objects to use these linked tables.
This is the first time I do something on a scale like this. The client had encounter a few error messages, but the one that keeps coming back is:
The Microsoft Jet Database engine stopped because you and another user are attempting to change the same data at the same time.
In the old version I have a main form where I put most of the main table's fields. For better maintenance, I created 2 subforms that access the same table, but managing other fields not included on the main form. I figure that Oracle did not like this, so I added a command button on the main form to Save the data, expecting that if the user moves to the subform after saving changes, he will have no problem. No such luck. Also, the problem could happen even when modifying fields in main form.
In the old version one of the references was set to Microsoft DAO and I changed it to ADO, Will the change have an impact on the application? I had no errors, so far on my test app.
Do I need to set up something else on my application?
Do I need to issue a COMMIT?
I do not issue any disconnect command when exiting the app, do I need to do it? How?
Any coding has to be done with VBA. I do not have Visual Basic or VBNet to work with.
Thanks for your help.
I have recently modified and Access 2003 application to connect to tables in Oracle via OBDC. I set up a System DNS for this purpose using the driver Oracle in OraHome92. I also linked the Oracle tables and modified all objects to use these linked tables.
This is the first time I do something on a scale like this. The client had encounter a few error messages, but the one that keeps coming back is:
The Microsoft Jet Database engine stopped because you and another user are attempting to change the same data at the same time.
In the old version I have a main form where I put most of the main table's fields. For better maintenance, I created 2 subforms that access the same table, but managing other fields not included on the main form. I figure that Oracle did not like this, so I added a command button on the main form to Save the data, expecting that if the user moves to the subform after saving changes, he will have no problem. No such luck. Also, the problem could happen even when modifying fields in main form.
In the old version one of the references was set to Microsoft DAO and I changed it to ADO, Will the change have an impact on the application? I had no errors, so far on my test app.
Do I need to set up something else on my application?
Do I need to issue a COMMIT?
I do not issue any disconnect command when exiting the app, do I need to do it? How?
Any coding has to be done with VBA. I do not have Visual Basic or VBNet to work with.
Thanks for your help.
