I am having a problem with an MS Access .mde returning an error stating 'OLE Object Error' when I am attempting to return and update a value from an MS Access mdb table on the Server.
This is driving me mad because I can't trap the error in the mdb because it occurs only after compile to .mde.
Anyone have any similar experiences and a possible remedy?
Side note: The original Data Layer was MS SQL Server 7, but the customer didn't want to invest in the Server upgrade so I down sized it to MS Access and converted the app to a Thick Client design. App works perfect when it was with MSSQL.
Thanks in advance!
This is driving me mad because I can't trap the error in the mdb because it occurs only after compile to .mde.
Anyone have any similar experiences and a possible remedy?
Side note: The original Data Layer was MS SQL Server 7, but the customer didn't want to invest in the Server upgrade so I down sized it to MS Access and converted the app to a Thick Client design. App works perfect when it was with MSSQL.
Thanks in advance!