Incorrect syntax near 'COLLATE'

30 Sep 2005 3:41 PM

SteveInBeloit

Hi,
I have an ACCESS ADP project that hooks to an SQL database. I have been
working on in may weeks 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?

30 Sep 2005 3:49 PM

carion1

Try refreshing the linked tables.

--

Derek Davis
ddavi***@gmail.com

Show quote

"SteveInBeloit" <SteveInBel***@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 weeks 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?
>
>

30 Sep 2005 4:38 PM

SteveInBeloit

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

Show quote

"carion1" wrote:

> Try refreshing the linked tables.
>
> --
>

30 Sep 2005 8:02 PM

SteveInBeloit

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 weeks and there
have been no changes to the code. I did set replication up for this database
and successfully used in yesterday. So with ACCESS out of the picture, still
having problems. Also updated to SP4 recently.

Show quote

"SteveInBeloit" wrote:

> Hi,
> I have an ACCESS ADP project that hooks to an SQL database. I have been
> working on in may weeks 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?
>
>