maybe this helps?

http://blogs.lessthandot.com/index.php/DataMgmt/DBProgramming/dealing-with-cannot-resolve-collation-co

long time I used Access97 or 2002....but iirc wasnt there some form of "Workgroup Security"...maybe a long shot but have you created any Access security groups?

have you any DTS packages?

big jump to SSIS......although 2000DTS can be used under "legacy" iirc.

maybe worth thinking about

what have you tried so far?

SELECT dbo_ORDER.DATE_ENTERED

FROM dbo_ORDER

WHERE dbo_ORDER.DATE_ENTERED=[Forms]![Form1]![Text1].......set format of textbox to "general date"

..ps in Access remember to tab out of form text box before running query

Sean Lange (1/31/2012)

---

Well you were correct that you wouldn't be able to explain it clearly. 🙂 I certainly got lost three of four time through the explanation. However there is...

take a look at

http://www.sqltreeo.com/

maybe useful to you.......

kravitej9 (1/31/2012)

---

hi,

i need a query for

i have data as

1,3

3,4,5 ...

so from what you have already seen/tested...what doesnt do as you would wish??

further down the "security tab" page are other options

have you tried selecting radio button for "be made using this security context" and entering the the remote login details?

in 2008r2...sorry, havent got 2005 anymore...when creating the linked server there is a "security tab" that allows you you to specify the login to the remote server...have you checked this...

good catch Jared 🙂

Steve / Jared

have removed the inserts from my post.

sorry guys...should have checked / googled before....lesson learnt !!

SQLKnowItAll (1/30/2012)

---

I'm not sure that you are supposed to be posting this kind of real data in a public forum. Moderators, you may want to take a look and...

OK......and this is pure guess work.

taking the 3rd tab on your attached spreadsheet...(seems to relate to your initial posts with...