Incorrect syntax near 'COLLATE'

Hi,
I have an ACCESS ADP project that hooks to an SQL database. I have been
working on in may ws and it is ready to go. While testing yesterday, I
found that when I know try to open a table from ACCESS, I get the above erro
r
message. I can still see it OK in EM. Today, when I call one of my Stored
procs from ACCESS code, I get this message also. So I get it when trying to
open all tables, and so far when I call one stored Proc. I have done severa
l
searches on it, and they all talk about using DTS to import tables. This
isn't the case. I am not using COLLATE in my SQL.
Any thoughts?Try refreshing the linked tables.
Derek Davis
ddavis76@.gmail.com
"SteveInBeloit" <SteveInBeloit@.discussions.microsoft.com> wrote in message
news:8F0BDC8F-4BFF-4AE3-A4ED-DC172B041475@.microsoft.com...
> Hi,
> I have an ACCESS ADP project that hooks to an SQL database. I have been
> working on in may ws and it is ready to go. While testing yesterday, I
> found that when I know try to open a table from ACCESS, I get the above
> error
> message. I can still see it OK in EM. Today, when I call one of my
> Stored
> procs from ACCESS code, I get this message also. So I get it when trying
> to
> open all tables, and so far when I call one stored Proc. I have done
> several
> searches on it, and they all talk about using DTS to import tables. This
> isn't the case. I am not using COLLATE in my SQL.
> Any thoughts?
>|||Hi,
It is an ACCESS Data Project. You don't really link to tables like in an
.mdb. Unless I misunderstood you. I did disconnect from the SQL database
and reconnect.
Steve
"carion1" wrote:

> Try refreshing the linked tables.
> --
>|||More info.
When I try to run the stored proc via QA in debug I get the same message on
the first fetch in the proc. Worked fine the last couple ws and there
have been no changes to the code. I did set replication up for this databas
e
and successfully used in yesterday. So with ACCESS out of the picture, stil
l
having problems. Also updated to SP4 recently.
"SteveInBeloit" wrote:

> Hi,
> I have an ACCESS ADP project that hooks to an SQL database. I have been
> working on in may ws and it is ready to go. While testing yesterday, I
> found that when I know try to open a table from ACCESS, I get the above er
ror
> message. I can still see it OK in EM. Today, when I call one of my Store
d
> procs from ACCESS code, I get this message also. So I get it when trying
to
> open all tables, and so far when I call one stored Proc. I have done seve
ral
> searches on it, and they all talk about using DTS to import tables. This
> isn't the case. I am not using COLLATE in my SQL.
> Any thoughts?
>