Well, I'm at a complete loss about this one (and extremely frustrated at that!)
I've been using this database reliably now for about a month, and the login screen that opens an ado connection to a sql server and then proceeds to delete all fields in certain access tables and fill them with tables it retrieves through passthrough queries going to the sql server has been working fine. I closed the program and then opened another access client that has all of its tables linked to the same sql tables used in access program #1. I updated a few of the fields in the sql server (via access program #2) (as has been working for about 2 weeks now) closed that program, and then proceeded to open access client (#1). Upon opening and entering my sql authetication user ID & Pass and clicking ok, I get an error message that says:
ODBC- Call Failed. The title of the message is "Elookup Error 3146". Well ELookup is a function that I've been using to lookup the specific value of two different records. One record on the sql server (by using a stored procedure & Passthrough query to retrieve the record first) and one record that is stored on the client. It compares the two dates and if the date in the sql server is greater then the date on the access client it updates the access clients date.
Well, now all of a sudden (after changing nothing programmatically) this has stopped working! What's even stranger is I went to a backed up instance from about a week ago and logged in through that one, it works fine, no error, no problem.
What's the problem??
Start Free Trial
