[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 330
  • Last Modified:

Multiuser Application using DBASE as database

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
spritep
Asked:
spritep
1 Solution
 
JayMerrittCommented:
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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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