Create A Multi User Application That Connects To Access 2007

Feb 19, 2009

I need to create a multi user VB.Net application that connects to Access 2007 and has 2 forms. How do I go about it?

View 4 Replies


ADVERTISEMENT

Get A VB2008 Multi Thread Application Working That Connects To A Local Server Program Using Sockets?

Sep 30, 2009

I'm trying to get a VB2008 multi thread application working that connects to a local server program using sockets. Server requests for this particular system can be more quickly handled by a number of connections, so I've written some code to run any number of data request threads that I choose. The problem that I'm having is that the data returned from the server is getting mixed up and is often returned to a different thread/socket than the one that requested it. Other than that, it seems to work okay. If I use just one thread, then the system works as it should. Pls. see incuded code, which is heavily edited to remove all the other fruit salad. Is there any way to set up the sockets so that data returned to the socket/thread that requested it?

Module StaticDeclarations
Public WithEvents g_SD As New SocketDataClass(New MainThread.MTCallback(AddressOf MainThread.MTResultCallbackSub))
Public WithEvents g_MT As New MainThread(New SocketDataClass.SDCallback(AddressOf SocketDataClass.SDThreadResultCallbackSub))

[code]....

View 4 Replies

Create A Multi-User Application?

Sep 18, 2009

I am new to programming. I know how to create simple windows app using VB and Sql Server/AccessDB. My question is this: Can my windows app be ran on a LAN or do I have to create a special multi-user app for a LAN? If the answer is yes, can someone please guide me on how to create a LAN/Multi-user app.

View 2 Replies

Create A Multi-user VB Net Application?

Feb 19, 2009

I need to create a multi user VB.Net application that connects to Access 2007 and has 2 forms. How do I go about it? Please give me a start up.

View 6 Replies

Create Program Database Application Using Ms Access 2007?

Jul 2, 2011

I trying to create an application using vb 2010.This application handles booking of airline customers. i am using ms access 2007 where i have created a table that stores customer information and another that stores and updates seats available in different flying classes. Am trying to develop an interactive application in visual basic 2010 where customers can book. i want to add this data to the database in real time and communicate to customers the seats available,prices and so forth. In otherwards the application communicates with database and updates accordingly. Firstly how do i connect to my database? I tried ADO.net but seems better equiped to work with sql server which i have no idea how to use. Is there a tool that can make my interaction with the access seamless

View 1 Replies

Create An Application That Connects To A SQL Database To Populate A Datagrid - Getting An Error 'remote Connection Permissions' ?

Sep 25, 2009

I am using VB 2008 Express and have created an application that connects to a SQL database to populate a datagrid.The application is working properly on my computer but will not on others 'remote connection permissions' error.After some googleing I found that the express version is crippled to only work on local machines that use a database.If I purchase Visual Studio 2008 Standard Edition, import and rebuild my application, will my application be able to run properly on other PC's?

View 7 Replies

Running Access - Application That Has An Ms Access 2007 DataBase Which Runns Great If Access Is Installed

Oct 15, 2011

I have an application that has an Ms Access 2007 DataBase which runns great if access is installed. Is there any code that I can use in vb that I would be able to run access with out installing it.

View 5 Replies

Multi-user Application - Updating All Clients When A User Updates Data (push Vs Pull)?

Aug 26, 2009

I am designing a fairly small application to manage a waiting area for a clinical department. There will be a receptionist who books appointments and updates exisiting appointments to say that a patient has "Arrived". In seperate rooms will be nurses who call patients who have "Arrived" and update the appointment as "In Session" and finally as "Discharged". The appointments are viewed in a flexgrid with nurses across the top and time down the left, patient names are displayed at the relevant times and the cells are shaded a colour to represent the current appointment status ("Booked", "Arrived", "In Session" and "Discharged").

I am using SQL Server as the back-end and Visual Basic 6 (I know) as my front-end.I have been told that there will be 2 or 3 nurses plus the receptionist logged in to the system but I would like to cater for growth.My question is what is the best mechanism to use in order to reflect the status change made by one user on the screens of the other users currently logged in?

I have been thinking about using a timer to refresh the data at a set interval but I do not want to keep hitting the server excessively (although what is considered excessive? we would be talking about a call for data every 60 secs per user). Plus the server could be serving data for many other applications so this is another consideration.Alternatively I have been thinking about sending some kind of message via Winsock to the other users notifying them of data changes as they happen. I don't have a lot of experience with this and am concerned about clients not receiving messages and users seeing old data. It also seems strange to me that once the days appointments have been retrieved from the database that "in theory" a client could go the whole day without having to query the database again to pick up changes - kind of scary.Some information on the data:We would probably be looking at around 100 appointments per day We capture patient name, date of birth, date and time of appointment and appointment status.What is the standard approach / best practice for this kind of scenario?

View 6 Replies

VS 2008 VB Database New User From Access 2007?

Sep 29, 2009

I have decided to quit using Access and trying my hand a VB.I am wanting to create a database with Forms for entering Address's.

View 1 Replies

Create User Interface Like MSWord 2007?

Jan 24, 2010

I'm using VB 2008 Express Edition , i wonder how to make a UI like MSWord 2007 with direct buttons and menu chages as we move middle mouse like this

View 4 Replies

Create A Multi-user Chatroom?

Jun 26, 2011

I am planning to make a multi-user chatroom client. I have got a web hosting, but I don't have the server. I want to know how to create the chatroom from my webhost and what type of method that I would need to connect it?

View 3 Replies

Take Data User Has Input On Form And Put It Into Access 2007?

Mar 11, 2010

i have a access database with two tables, one for customer and one for booking.

I then have a form application i made in VS 2008 which lets a user enter details such as their name phone number ect into text boxes.

All of the information the person enters thoughout the program is shown via labels at the end, all on one form.

Would it be possible to then have a button that when clicked saves all of this information into the access tables into the correct columns, im sure it must be possible i just don't really know where to start.

View 14 Replies

Database - Replacement For Ms Access Db For Multi-LAN User Purpose?

Apr 27, 2012

I have been using access for my applications from over 4 years now. I realize its time to move on now and i need suggestions for a new database. Here are my requirements :should be able to connect it with Vb.net windows form frontend GUI - all database functions such as add/delete/edit/update will be done through the vb.net front-end only.Should be able to place the db on LAN and each client on the LAN can then access the centrally stored db through their individual front-ends.At the most 5-6 users will be reading/writing to the database at the same time , so the database should not crash or slow down Since i come from MS access background, i would like something thats similar to it so that i can learn and adapt to it quickly.Not very important, but i think its worth mentioning. This db will be the main central db for my .net application.My .net application will also be interacting with quickbooks and magento via some apis but ultimately all this data will go to the central db. So just curious, will there be any compataibility issues with the database that you suggest Should handle about 10 tables and around 10k records in each table Should be secure - just that i should be able to lock it up or anyhow prevent it being accessed from anywhere else other than the vb.net front-end.

Lastly, I would prefer it to be free to use if possible but not essential. I realize there are some topics like mysql vs sqllite and on databases, but pls understand i need suggestions for one that will be apt for the purposes i have listed above.

Edit : Just curious - Would i pushing the limits if i still stick to access - i understand access won't be good for multi-user access but i guess 5 users is not much ?

View 3 Replies

Make Multi User Application?

Mar 10, 2009

I have finished coding a VB.Net application that has connection to SQL Express 2008 database. My question is, what steps do I have to take to make this a multi user application.

FYI:There are 3 tables in the database of which two tables contain data to be viewed by the user and one table is to insert records by the user. The former two tables will be edited by the administrator only. So there is no issue of concurrency. But the one table that is used to insert records by all users has to be dealt with.

View 11 Replies

Make A Multi-user Application?

Apr 11, 2009

I want to about a multiuser application that have a server and 2 or 5 client to interect with mssql thorough application. how multiple cleint connect to database in same time.

View 4 Replies

Multi-user Tcp Chat Application?

Jul 29, 2009

I have been trying for years making a network app.I need linked to a video or something, mainly on msdn or some microsoft site, because youtube created videos for coding aren't all that helpful as most of the microsoft made videos.

I need not linked to things like multi-user tcp chat application, as i have looked at these, and even found no code solution, but the no code doesn't allow too much customization and hard to deal with data received to make your own commands send and receive and have events for them.

The multi-user tcp chat application, it doesn't explain anything, just gives you the code for you to look at, and well, it's hard to understand.

I WANT TO MAKE THE PROGRAM BEFORE MORE YEARS PASS BY.

View 1 Replies

VB - Access - Registration Form That Connects To Access Database And Inserts Values In Table

Mar 14, 2011

I'm writing an asp.net page with a simple registration form that connects to my access database and inserts the values in the table. So I have my database, my registration page, everything looks fine in my code, but there's a syntax error I can't seem to figure out. When I go on my webpage and click submit, it says : Syntax error in INSERT INTO instruction.

Here's my code:

<%@Page language="vb" explicit="true" debug="true"%>
<%@Import Namespace="System.Data"%>
<%@Import Namespace="System.Data.OleDb"%>

[CODE]...

View 5 Replies

VS 2005 : Create A Multi-user Chatroom Program?

Jun 25, 2011

how to create a multi-user chatroom program. I don't have the server, but I have got a web hosting. I want to know how I can connect to the chatrooms by connect to my web hosting using with httprequest?And also, I would like to have code to allowed me to send the users private messages, ignore the users and kick/ban the users out of the chatroom.

View 10 Replies

Create Access 2007 Database And Tables At Runtime?

Jun 5, 2011

I have a requirement to create n Access 2007 database & some related tables from my application at runtime.

I used to be able to do this ages ago in VB5 but having difficulties doing it in VS (VB) 2010.

View 1 Replies

DB/Reporting :: Database For Multi-user Application

Jan 28, 2011

i just want some opinnion or suggestions regarding database softwares. we are going to develop a system for 20 or less users, i am planning to use MYSQL community server as our database to lessen the budget for that system, i just want to know if it is ok to use that version.is there a big differece between mysql community server, enterprise server and MS SQL Server in terms of handling data i.e security, speed, etc...

View 2 Replies

Make Multi-user Application (database)?

Dec 7, 2009

how to make an application with a multiple user.

language: VB
resource: Visual Studio 2008 Pro(90-day trial)
Sql express (the packages when u download the VS 2008)

scenario: i will make database located in a server (LAN) and a multiple client that can access the server database to add,modify,delete records.Im not aware that building a multi-user application database is different from a normal one user application database. T_T.i read some guide and other walkthrough on building a database but it became confusing when it doesnt my requirements. coz when i try to open my database(.mdf) to connect from other client (in another station) it says its currently in use and connot connect to it. err. @_@..

View 3 Replies

Manage Concurrency As It Is A Multi User Application?

Mar 2, 2009

give me some example code to insert rows of datagridview into a sql express database table? Also, how do I manage concurrency as it is a multi user application?

View 6 Replies

Create Excel Charts From MS Access 2007 Database Using Program?

Oct 20, 2010

I have a slight problem with something i am working on. I found this module here:

View 2 Replies

Make Program Application Work As Multi-user?

Jul 25, 2007

I am developing a VB.Net application. That application might be working on a LAN. MS Access as a backend will be used.

I have developed many single user applications, but don't know of multi user , LAN, manage DB etc. How do I make the program as Multi user on LAN. Data will be accessed at the same time. How to mange such things.

View 5 Replies

Special Characters - Multi-User TCP Chat Application?

Jan 8, 2010

Someone gave me a link to a Multi-User TCP Chat application once, but, there is a flaw in it, where it wont do special characters, such as Alt+1 will become a different character to the server than the one that was sent. Even I tried to see if the output was usable but it sees it as multiple chars, when it is only 1, and I can't find a link between what it sends and what the character is, so I can't just tell it based on whats sent what the char is, because I see no relation, I would have to type it out for each and every special character.

View 2 Replies

Accessing A Custom Help File For ACCESS 2007 Application

Oct 31, 2008

I developed a custom help system for my ACCESS 2007 application using Help Workshop. I wish to open this .chm file by a command button on a form but does anyone know how to do that?

View 9 Replies

DB/Reporting :: Using SQL 2008 Express With A Multi User .NET Windows Application?

Mar 26, 2009

I'm using SQL 2008 Express with a multi user VB.NET Windows application. Do I have to add each user to the SQL user account? Does NT AuthoritySYSTEM work? I do not know how this works. So far I have NT AuthoritySYSTEM in the Security-Logins of the Server. But do I have to add it also in the database? In the databse Security-User, I have the following:

[Code]...

View 1 Replies

Method To Develop And Deploy A Multi-user Desktop Application?

Sep 17, 2009

I have developed an application using vb.net. This application will run on approximately 15 machines at the main office and also roughly 10 machines spread over 3 different locations. I am using SQL Server Express edition in the backend. I deployed the application on the network using caspol but it is extremely slow. The Company Manager's perception is that because a script will invariably have to be deployed on each client machine to configure CASPOL, that the solution is not viable.

What is the best method to develop and deploy a multi-user desktop application?

View 9 Replies

Multi-user TCP Chat Application Doesnt Append Text

Apr 6, 2011

I've been trying that example application at [url]...

I'm just using the client part to connect to an exiting server application. It works OK up to the point where it appends text into the[code]...

View 2 Replies

Create A .net Windows Application In Multi-language?

Feb 23, 2009

If i want to create a vb.net windows application in multi-language (EnglishArabic). Is there any steps i need to do?I installed the Arabic at my windows XP and I am able to write the labels and the the textbox for example in arabic but is there a way for the controls to shifts automatically?

View 7 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved