Last post Jul 28, 2009 12:48 AM by impius
Jul 26, 2009 12:58 PM|impius|LINK
I am trying to give users the ability to query my access DB that sits on a shared folder. I have never done anything like this before. I was hoping someone could help me out with some sample code to do the following simple scenario...I think if I can get
this, I should be able to figure out the rest with some research.
my database name is: test.mdb
it is located at: \\A0136-3222\testfolder\
It contains a table called: dd
I have a query within access that I would like to run from the webpage, the SQL in access is:
SELECT dd.DSM, Count(dd.DSM) AS CountOfDSM
GROUP BY dd.DSM;
Thanks a lot for your time!
Jul 26, 2009 02:12 PM|Mikesdotnetting|LINK
Jul 26, 2009 02:22 PM|hans_v|LINK
First, make sure you set the right permissions:
And how to conecct t and retrieve data from Access, read some tutorials:
Jul 28, 2009 12:48 AM|impius|LINK
Thanks for the resources!