Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Invald results from ODBC

Status
Not open for further replies.
sparrow

sparrow

Programmer
Jun 14, 1999
35
0
0
HK
In our office we are using Access 97 connecting to Sybase 10 ODBC.

If I create a new database and connect to tables and run a query then each returned record is exactly the same. It seems to return the first record found in the database as the result for each record that should be returned.

If one of my colleages creates the database, and then I run the query on my PC it works perfectly.

What is wrong, or missing on my PC ?????



PAul McEwan
 
Sort by date Sort by votes
Access can be buggy. Try a compact and repair or dect and repair under the help menu. This will re-install the corrupted files for access.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

serino
  • Locked
  • Question
Delete From Table
Replies
1
Views
226
Andrzejek
Andrzejek
lameid
  • Locked
  • Question
SELECT FROM Table in Another Access File
Replies
2
Views
303
lameid
lameid
Hanss
  • Locked
  • Question
Query which shows results?
Replies
2
Views
96
dhookom
dhookom
MDGarcia
  • Locked
  • Question
Error Could not delete from specified tables 2
Replies
14
Views
367
MDGarcia
MDGarcia
qqp
  • Locked
  • Question
Query criteria from form
Replies
9
Views
195
qqp
qqp

Part and Inventory Search

Sponsor

Back
Top