Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 MS Access
 where clause for an Access autonumber field does not work

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-12-05 : 08:50:35
grant writes "My SQL statement that is searching for a specific record in an Access database based on an autonumber value does not seem to work. The SQL statement is contained within some VBScript code and the 'Where' clause uses a variable from a query string. Is these some datatype conflict?"

robvolk
Most Valuable Yak

15732 Posts

Posted - 2001-12-05 : 09:10:32
Can you provide the table structure and the code you're using?

Go to Top of Page
   

- Advertisement -