• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 168
  • 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.
1 Solution
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?
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.
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

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

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