[Webinar] Streamline your web hosting managementRegister Today


ODBC - CRecordset - CRecordview

Posted on 2000-01-06
Medium Priority
Last Modified: 2013-11-20
Environment : MS Access , Visual C++

Views : CRecordview

Interface : ODBC

Question :

I have a peer to peer network, which means that i have two computers that is able to communicate with each other.
In other words client to client communication. For example i am able to use winchat to communicate with another person using the PC name.

Requirement :

I have an application that uses access as a database and the front end application is created using app wizard.
Is it possible for me to perform a task
on the  database which is stored in another computer. I am currently using ODBC as my interface. How is it done?



Question by:eugene007
  • 2

Accepted Solution

inpras earned 20 total points
ID: 2331121
While selecting UR datasource for UR DSN during ODBC configuration, U c an select the file which is present in the network thats all, and U can use the some functions of database to work with.

Go to ODBC configure a new dsn while selectin the file as datasource select the file U want which is present in network.

Hope this helps

Author Comment

ID: 2331241
Hi inpras....if lets say my database in stores in a local hard disk of another computer...how do i handle this type of situation?



Expert Comment

ID: 2334502
Hi eugene007
Same way as U on UR disk
Only thing is U have to map the network drive to which UR connecting.

Like say
I have a LAN and I want to connect to a databse say b.mdb on a machine B's d: drive

then I will do the following
1. map B machines drive d:
2. Coneect to it through ODBC by selecting source
3. Name a DSN to it

and all other processes are same as if UR accessing to the database of UR hard disk

Hope I am clear this time

Featured Post

[Webinar] Improve your customer journey

A positive customer journey is important in attracting and retaining business. To improve this experience, you can use Google Maps APIs to increase checkout conversions, boost user engagement, and optimize order fulfillment. Learn how in this webinar presented by Dito.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Here is how to use MFC's automatic Radio Button handling in your dialog boxes and forms.  Beginner programmers usually start with a OnClick handler for each radio button and that's just not the right way to go.  MFC has a very cool system for handli…
Introduction: Finishing the grid – keyboard support for arrow keys to manoeuvre, entering the numbers.  The PreTranslateMessage function is to be used to intercept and respond to keyboard events. Continuing from the fourth article about sudoku. …
This video will show you how to get GIT to work in Eclipse.   It will walk you through how to install the EGit plugin in eclipse and how to checkout an existing repository.
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.
Suggested Courses

607 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question