mdac 2.5 and upgrade issues

M

MTsang987

Hi,

I have an application that has a form and 3 subforms. After all of the
computers except one were upgraded from mdac 2.5 to mdac 2.7, it does not
work. The only computer that it works on has mdac 2.5.

The application is configured using the menu File --> Connection, with the
connection set to a SQL backend database.

The main purpose of this form is to enter an Order. The Orders table is a
one to many relationship with the OrdersItems table. The recordsour of the
subform is a view on the OrdersItems table (the view contains a join with the
products table to get the product description and product type, etc.).

On the computer that has mdac 2.5, the OrdersItems subform opens with an
editable blank row in the OrdersItems subform. On the computer that has mdac
2.7, the OrderItems subform does not have anly rows, and the code behind the
subform does not allow the productID to be set.

Any help would be appreciated on how to solve this problem.


M.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top