Link to home
Start Free TrialLog in
Avatar of n1875621
n1875621

asked on

ODBC/NT/MSACCESS

I am writing this question in order to get quick knowledge from someone who has more than likely spent hours researching the answers.... But look at the amount of points I am offering, I kinda hope for a good answer.

I have access to and NT server. Lets say I have a database made in MS-access 97 (an .mdb file) and say it contained a table called "address_book" and 3 fields in the table called (name, phone, email).

I upload the mdb file on the net.

how can I (and what library/modules do i need) ....ODBC??
1. Search for a record with "joe Bloggs" in the name field. and print out his email address
2. Delete "anne smith" from the database along with her records
3. Add "john brown" to the database with his email and phone number
4. change "geof daniels" phone number to 333 333 222

thanks..i know the answer may be lengthy. please, I need this answer really quickly....

thanks people.
ASKER CERTIFIED SOLUTION
Avatar of tfabian
tfabian

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of n1875621
n1875621

ASKER

Thanks for the help. It has been a while since I asked that question...I went on programming in perl with a text-file based database. It actually works quite well, its not real slow and I find it reliable....not to mention EASY!! So I will keep the info you have given me for future reference....just a query though, is ASP browser dependant? or will it run on any browser, making it server dependant?

thanks again....john
john@ActiveGS.com.au

the ASP stuff will typically run in any browser.. it puts it's compute / processing load on the server which is hosting the page..the browser has no clue that it's displaying ASP data.. when you ask for a "show source" of an ASP page, it'll show you the full html minus the ASP code.. the only clue that you have that the page is dependant on ASP calls is that it's URL ends in .ASP


good luck