[AccessD] sql help please (Related question to thread.)

Joe,

Why don't you try exporting the data from the suspect table to, say,
an Excel file or a CSV file, rename the existing table, and then
import the data back into Access.  Check the table structure that
results and re-create your key field and adjust the field properties. 
Then try the query again.

Regards,

Steve Erbach
Scientific Marketing
Neenah, WI
www.swerbach.com
Security Page: www.swerbach.com/security
Blog:  http://TheTownCrank.blogspot.com


On 2/5/06, Joe Hecht <jmhecht at earthlink.net> wrote:
> Is it possible a table con look fine but somehow be corrupt
> and be killing the query?
>
>
>
> I am rebuilding my beast but the one same table keeps
> killing it?
>
>
>
>
>
> Joe Hecht
>
> jmhecht at earthlink.net
>
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


--