Problem

Problem

Post by john » Fri, 17 Oct 2003 00:28:57


I am conecting to a SQL2000 database via ODBC on another
machineon a network.

When I run a simple query such as:

SELECT * FROM <table>
where ID = "1"

I get back fields with '#Deleted' in them.

Why is this?

John
 
 
 

Problem

Post by john » Fri, 17 Oct 2003 01:08:48

converted bigint to int in my sql table and it is working
fine now...but any other issues that I would come accross
like this that Access cannot handle?