Solved

Multiuser Application using DBASE as database

Posted on 1998-08-24
1
306 Views
Last Modified: 2013-11-24
Any body can help me.

I want to developed a multiuser application with Dbase as database, i just want to know how can i lock the record in the Dbase database like in Clipper. Can u give me a sample code. What i really want is to make a program that will allow 10 simultaneous user to add, edit the Dbase Database simultanoeusly.

any comments or suggestion.

thanks in advance.

spritep
0
Comment
Question by:spritep
1 Comment
 
LVL 1

Accepted Solution

by:
JayMerritt earned 100 total points
ID: 1430793
VB will utilize the JET engine to translate the DBF files.  The term VB and Access (JET) use is ISAM file.

JET will handle all of the record locking for you.

The following is some code I pulled out of an archive from a VB 3 app.  Once the table is open, then you can manipulate it with the standard DAO methods like .AddNew, .Edit, .Update.


 Dim xdb As Database
 Dim tbl As Table

 Set xdb = OpenDatabase("C:\dBase\Data", False, False, "FoxPro 2.5;")
 Set tbl = xdb.OpenTable("MyFile.dbf")


0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
Technology opened people to different means of presenting information, but PowerPoint remains to be above competition. Know why PPT still works today.
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…

707 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now