How can i use VB in networks

Posted on 2000-01-03
Medium Priority
Last Modified: 2010-05-02
there are two
1-how can i became an expert
2-i have a database program VB with ACCESS how can i make my program work under network and can two or more users working in the same file at the same time or not if not how can i do it .

Question by:loay
  • 2

Expert Comment

ID: 2319827
1. All you need to do is answer someelses question! Easy

Accepted Solution

Henny earned 100 total points
ID: 2319833
To become an expert, you must first register (there is a link at the bottom of this page)

If you want to make your program work under network, or multiuser You'd better use MSSQL Server instead of MS Access. I don't think you can do it with Access


Expert Comment

ID: 2319887
Henny - loay would have to already be registered - you can't ask a question unless you are registered!!!
LVL 12

Expert Comment

ID: 2320227
Henny, you're wrong on both counts!

Not only is he registered to be an expert but you CAN use access in multiple user mode on a LAN!

Access is designed to be networked from the ground up. Place the .MDB file in a LAN directory where your users have full priveleges and let them have at it. Unless you're in a very heavy transactional mode there is no special coding required. The Jet engine will manage multiple users just fine with no special efforts on your part (this is where the .LDB file comes in - it tracks each user logged into the database)

Now you can help things along by keeping your edit/update sequences as short as possible. Don't start an edit, say, at form_load and wait until form_unload to do the update. Fill your for with the data and do the edit/update all at once at the end. This will speed operations.

The Jet engine builds an image of the data record in memory and doesn't actually update the database until you fire an UPDATE command. If that command is successful, then your data is safely tucked away in the .MDB.


Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

I’ve seen a number of people looking for examples of how to access web services from VB6.  I’ve been using a test harness I built in VB6 (using many resources I found online) that I use for small projects to work out how to communicate with web serv…
When designing a form there are several BorderStyles to choose from, all of which can be classified as either 'Fixed' or 'Sizable' and I'd guess that 'Fixed Single' or one of the other fixed types is the most popular choice. I assume it's the most p…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

600 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