• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 170
  • Last Modified:

multiple database access

How do I make several programs access one open database. I only know when there is one database and one program. i.e opening the database in that program.

I want a case whereby one program will be able to add records to the database whereas one only reads the records.
The simplest solution will do. I am using Visual Basic 4.0.
0
serameng
Asked:
serameng
1 Solution
 
visual_bCommented:
To open a database for read/Write access use:
Set dbWrite = wksmain.OpenDatabase("dbName.mdb", False)
To open a database for Read Only access use:
Set dbRead = wksmain.OpenDatabase("dbName.mdb", False,True)

is this what you need?
0
 
seramengAuthor Commented:
I am not sure if what you gave me is what I wanted. but i said I need, like 2 or more applications accessing the same database simultaneously or concurrently for both read and write. I hope I made myself clear.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now