Problem querying table linked ODBC Database

  • Thread starter Thread starter Michelle
  • Start date Start date
M

Michelle

I linked my computer to a table in my company's ODBC Database that has
amortization schedules for all of our loans. Since each due date for each
loan has a separate record, I choose to use both the loan number field and
the due date field for the primary keys. No loan number should have the same
due date twice in one amortization.

When I open the table, I can see all the records. My problem is that, when I
try to query the table for specific loans, I get an error message that says
"OSBC--call failed." and all of the columns in the datasheet view of the
failed query say "#Name?".

Thanks,

Michelle

Can anyone tell me what I'm doing wrong?
 
Open a new Access blank database, you don't have to name it or anything. Do
file\new and scroll down to ODBC databases, and follow the promts. If your
ODBC connection is working properly, it should show you all the tables on the
sql server and allow you to link to any ones you need. If it doesn't, there
are many possible explainations. If it does, your connection on the current
one is bad.
 
Thank you.

Michelle

golfinray said:
Open a new Access blank database, you don't have to name it or anything. Do
file\new and scroll down to ODBC databases, and follow the promts. If your
ODBC connection is working properly, it should show you all the tables on the
sql server and allow you to link to any ones you need. If it doesn't, there
are many possible explainations. If it does, your connection on the current
one is bad.
Click to expand...
 
Back
Top