Viewing 15 posts - 2,026 through 2,040 (of 2,452 total)
maybe this helps?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
February 3, 2012 at 1:43 pm
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?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
February 3, 2012 at 1:01 pm
have you any DTS packages?
big jump to SSIS......although 2000DTS can be used under "legacy" iirc.
maybe worth thinking about
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
February 3, 2012 at 7:55 am
what have you tried so far?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
February 2, 2012 at 1:35 pm
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
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 31, 2012 at 2:04 pm
Sean Lange (1/31/2012)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 31, 2012 at 1:04 pm
take a look at
maybe useful to you.......
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 31, 2012 at 12:51 pm
kravitej9 (1/31/2012)
i need a query for
i have data as
1,3
3,4,5 ...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 31, 2012 at 5:23 am
so from what you have already seen/tested...what doesnt do as you would wish??
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 30, 2012 at 3:30 pm
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?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 30, 2012 at 3:16 pm
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 30, 2012 at 2:40 pm
SQLKnowItAll (1/30/2012)
Also, a quick google search will show you that this is data from Lawrence Memorial Hospital of Medford, MA. 😎
good catch Jared 🙂
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 30, 2012 at 1:21 pm
Steve / Jared
have removed the inserts from my post.
sorry guys...should have checked / googled before....lesson learnt !!
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 30, 2012 at 1:20 pm
SQLKnowItAll (1/30/2012)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 30, 2012 at 12:56 pm
hbanerje (1/30/2012)
I have acually attached the data in the spread sheet.
OK......and this is pure guess work.
taking the 3rd tab on your attached spreadsheet...(seems to relate to your initial posts with...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 30, 2012 at 12:23 pm
Viewing 15 posts - 2,026 through 2,040 (of 2,452 total)