Developing An Access Database That Will Be Shared With Multiple Users?
Aug 22, 2008
I am developing an access database that will be shared with multiple users.I don't want the users to access the database directly so I will have them enter new data on a data access page. The data access page is stored on a Microsoft Share Point web page, and the database is stored on a network drive.Here is my problem: When new data is entered on the web page I need it to trigger a WillChangeRecordset event; however, I have not been successful because the web page does not declare a new instance of a recordset object.At a minimum I need the new data to be processed before the web page appends the new data to the table.
View 3 Replies
ADVERTISEMENT
May 8, 2009
Not sure if this is the right Forum to post this question. If not guide me where to post... I have an Access database that I would like to be able to share with Multiple user cuncurently... I have seen it is being done but I am not sure how? Or may be I should be using SQL Express.
View 1 Replies
Nov 5, 2011
I am developing a Visual Basic .NET application to be used by the staff of a small training centre nearby. The front-end (UI, menus, etc.) will all be in VB .NET, and there will be a back-end database for storing all of the required data, such as student records and meeting information. What I would like to know is if it's possible to use a Microsoft Access database for this purpose, and have it accessible by all the staff in the centre (on the same network) at the same time. For example, would I be able to put the database in a shared network folder, and have a copy of the VB application on each PC that would all be able to read/edit/add to the database?
View 2 Replies
Mar 30, 2012
I've taken over the maintenance of the website (ASP.NET VB) and on one particular page I noticed the below code
Inherits System.Web.UI.Page
Public Shared UserNumber As String
Private Sub Page_Init(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Init
[Code]....
My question is whether the variable UserNumber can be accessed or changed by any other user than the current one?
View 2 Replies
Apr 30, 2012
I know my Question was asked maybe 10000 times before, but i really did not take the chance to search the forum coz i really short of time.
I have *.mdb DataBase with 20 tables each table have more than 10 fields, i'm trying to automate the MDB file from a network like that 5 PCS + One vb.net exe program (5 users) working on the same time on the exe that is connected to the database , my questions are :
1) How much risk is it to put the database into one (shared) folder and connect it to the program ?
2) What is the best way to establish this method ?
3) Is there any alternatives ?
View 4 Replies
Feb 26, 2009
I am on the brink of developping an application for myself and some collegues at work. I will use VB 2005 and SQL server 2000 or 2005.
Here is my question: When I build the connection string do I have to use only 1 database user for all of the users of the application or does each user need to have its own database user in SQL Server?
View 4 Replies
Mar 9, 2010
I need to find a folder that is shared between all users of a PC, every body being able to read/write to that folder and below, without any errors. I think that the folder "C:Documents and SettingsAll UsersShared Folder" would do the trick. How do I find the path to that folder, regardless of the OS used (Xp / Vista / 7) and regardless of the Windows language (With a french Windows, this folder is called "C:Documents and SettingsAll UsersDocuments partag").
View 5 Replies
Dec 29, 2010
I've got a code using SQLClient that loops though all users in a Users table inside each loop i want to preform another search in the UserOrders table, thus doing a count of all orders.
I get this error
HTML
There is already an open DataReader associated with this Command which must be closed first.
Here is my code
vb.net UserLists.Items.Clear()
Dim connection As New SqlClient.SqlConnection(My.Settings.ConnectString)
Dim command As New SqlClient.SqlCommand("SELECT * FROM Users ORDER BY PersonName",
[CODE]...
View 3 Replies
Jul 12, 2010
We currently have some big projects coming up which we will be creating in visual studio using vb.net There will need to be most likely three developers working on different parts of a particular project at any one time.I was just wondering if there is any sort of platform we can use so this is possible as currently each person is using a different copy of the work and then we are transferring this over onto a master copy.
View 5 Replies
Apr 22, 2009
I have a problem here... I'm using SQL Server as may database and developing that database in Visual Studio 2008.my problen is, when I use the STORED PROCEDURE from SQL SERVER it doesn't update/save new data on a the table. here's my coding; This is my stores procedure: when I execute this on on SQL SERVER it worked perfectly.
[Code]...
View 4 Replies
May 19, 2009
i have and application with 140 textboxes and when i click the save update button it gives me a error i'm trying to save all the textboxes in one column, one beneath the other heres my code;
[code]...
and i get a error saying syntax error insert into
View 1 Replies
Jan 20, 2009
I have created a shared add-in in Visual Studio 2008 and using the shared add-in wizard and am coding in VB. When run the add in in Access 2003 I want to check if the user has a database open, so I set a AccessApplication variable to be the application object in the OnConnection procedure and then on a button click I check if AccessApplication.CurrentDB Is Nothing If there is no database open Access will close correctly after the button is clicked. But if a database is open then I have to stop Access in the VS debugger.
[Code]...
View 1 Replies
Mar 14, 2010
I am developing a software using vb.net and SQL server as database it takes the name of my system in connection string and when i try to load my software in other computers it search the same name.how can i define a connection string that takes the name of system on which software is loaded?
View 1 Replies
Apr 18, 2012
I want to develop a translator (e.g. German to English ) with a separate database. What is the best way to do this? The database must be able to record words and phrases with their meaning. The database capacity must be at least 2,000,000 and phrases. Also, what is the best data structure for fastest retrieval of the information.
View 4 Replies
Oct 22, 2010
Im getting this: "Exclusive access could not be obtained because the database is in use.RESTORE DATABASE is terminating abnormally."
First the message told me i must connect to master db to execute the restore but i change it and i got the message above.The parametrized sql statement im using is :
cmd.CommandText = "RESTORE DATABASE aguasdelbosque " +
"FROM DISK = @archivo"
View 2 Replies
Oct 6, 2010
Access database: Inventory
Column 1: Pprice
Column 2: Date
Now what I want to do is on a button click, I want to search the database for a date range, lets say September/01/2010 thru September/30/2010. Then I want to pull all of the Pprice values and add them together to come up with an inventory parts cost for the month.
View 3 Replies
Mar 30, 2010
I'm in the middle of developing a prototype that will connect to the database. The problem I'm having is that I'm seeing more than one ways of retrieving data from the database either by adding databindings or just use a loop to loop through each rows to get a column or two.
I'll try to put this clearer because I'm not sure what I'm asking myself. I have no idea what approach to take. The purpose for the application is to retrieve as well as add, update, and delete data from that database. I wanted to display the retrieved data onto any controls like a textbox and such.
Right now, I'm confused to figure out what's the best way to program: by bindings or just retrievals. Any suggestions?
View 1 Replies
Aug 25, 2010
I have an access table that I'm loading into a dataset, then I'm binding the dataset to a bindingsource. The bindingsource is the datasource for a datagridview. I can use a command builder to update the entire table, but I need to update all the rows (or changed rows) in specific columns. I have a column called "dPrint" which is Boolean. I'm not sure how to use the bindingsource as my datasource in an Update Command. I've tried this:
View 8 Replies
Apr 13, 2009
i 'm develloping an application that uses a sql server database, in my computer where i'm programming i installed the sql server in the same language of the OS, in the tests of the application everything worked fine. Biut after migrating the db to the main server, the values went crazy.. After some research and tests, i saw that the language of the sql server was in english and that was the problem.
My language settings says that the decimal separator is "," and the agrupment digit it's ".", and the sql server works in the other way "." is the decimal separator and the "," it's the agrupment digit. In my code i was using the CDEC to pass the values to the DB, to solve this i removed the cdec and send the parameter as a string (So if i send 2,33 to DB with CDEC i get 233 if i send the 2,33 string i get 2.33). This works for now, but i don't know if in the future i'll have problems...
View 1 Replies
Jul 22, 2011
I need some tips for shared variable to share the information for multiple running application. For example, the value of variable become 1 when a user run the first instance(execution), and become 2 when the user executes the second(in sames OS or through network).
View 3 Replies
Sep 4, 2010
I have a created a class, which contains a sub routine.This sub routine, should ideally be accessable by objects which are not members of the class, so I would like to make the sub, a 'shared sub' (call it Sub1).
Question: I am using many threads and there will be possibly 100s of 1000s of threads all wanting to use Sub1 (which is at present, is not shared).At present Sub1 , is not a shared sub, so every time a thread wishes to use Sub1 , I am creating a (dummy) instance of the class and then applying Sub1, to that instance.
My program works flawlessly using the above technique.Question: If I were to turn Sub1 (which is not currently shared) into a shared sub, and directly had various threads calling Sub1, would there be any issues with locking, ie. would it possible for 2 threads to enter that thread and start overwriting variables, which another thread has written to?
NOTE: there are no shared variables/properties in Sub1 and all variables used in Sub1 are declared within the sub itself.
View 7 Replies
Mar 4, 2012
I am developing a chat application using online connection to a mysql databbase. But i am facing a problem. After 10 minutes, MySQL closes all the chat connections because of the 600 seconds timeout (has been set by the host service i am using). I don't understand why is that happening cause every piece of my code which needs data from the database opens and closes the connection (i mean that it dosn't maintain the connection after the query's execution). If i .close() and .dispose() the connection, it still appears in mysql at sleep mode (it terminates only if i exit the program).
Dim MySQLCon as New MySQLConnection
Dim MySQLCom as New MySQLCom
Dim counter as Short
[code]....
View 2 Replies
Jan 29, 2010
I have an asp.net web app. It has a shared class, and I want to have the connection string the same through out the site. My string is in my web config, but I don't want to type this all over the place:
View 3 Replies
Jul 9, 2009
I have a program that uses sql for the database. The issue im having is when two users attempt to update the same record then the update from second user overwrites the record from the first user. I believe this problem comes from the the way i attempt to preserve existing text in the fields.
My thought on whats going on is: If the form has fields A and B. Both users start with a blank form. User 1 adds a record with an entry in field A. When user 2 goes to update the record with an entry in form B, the program overwrites user 1s field A entry with the blank field A from user 2.
Is there a way to force it to grab the most recent data before it tries to add/update? I thought about resetting the digit combo box to the same digit which would trigger the change event for that field. but the issue with that is it would also wipe out the current entries on the form.
Below is the change event for the digit combobox, the main submit procedure, and the subprocedure for one of the days.
[code]
Private Sub cboDigit_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cboDigit.SelectedIndexChanged, cboOffice.SelectedIndexChanged, dtEndDate.ValueChanged, dtStartDate.ValueChanged
[Code].....
View 1 Replies
Mar 25, 2010
Consider I have a shared function:Public Shared Function CalculateAreaFromRadius(ByVal radius As Double) As Double
[Code]...
If I have two or more threads in the same vb .net app and each of them calls the shared function at the same time with different RADIUS, will they each get their own AREA? I want to know for each call to the function if it is using same local variables or each call creates new instances of local variables?Will the answers to above questions be same If I have multiple (2+) single threaded apps and they all call the function at the same time with different RADIUS value?
View 2 Replies
Feb 21, 2012
I need to add multiple users to active directory in vb.net what would be my best way to do this? Although i see some dotnet classes for them its hard figuring this out for my first time. Mostly what must i be aware of when trying to add them? Multiple opinions on the matter would be fine but I really just wish to add users with basic information like firstname and lastname and maybe to specific group.
View 8 Replies
Jun 28, 2011
I have a form which has a textbox named "textbox1", and a button named "Button 1". Button 1 is meant to be a submission for textbox1 (i.e. when button1 is pressed, the value of textbox1 is saved and remembered). I want the value of textbox1 to be remembered on any computer, but I need it to be update-able too. I tried using settings to do this like so:
Private Sub Form3_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Me.TextBox1.Text = My.Settings.TextBox1
[Code]....
but the problem in doing this is it only works for the current user. When the application is then put on another computer the value is blank.
View 4 Replies
Feb 26, 2011
Iam developing a Windows application using Visual Basic 2008 with a SQL Server database. Throughout the program I give the user as many options as possible and have no problem with either the database or the windows forms. The program does not initially require a Login and I want toprovide the User with the opportunity to add a Login to the system. The default Login form is perfectly satisfactory.
The problem is that I can't figure out how to program the change sothat the Login from isopens the program rather then th form designated as the StartUp form. this forum I am able to prgrammatically change the form but I can't figure out how to make the requirement a permanent factor. I tried using a Constant, but if the User wants to change, you can't change the constant. Its an apparantly simple yes/no situation but if I set a varable to yes and then change it to no the next time the program runs, the change will be lost.
View 6 Replies
Dec 15, 2011
I am developing project in which i am sending emails to multiple user as follows
Dim users(20) As String
users(0) = "xxx@xxx.com"
users(1) ="xxx@xxx.com"
[Code]....
View 1 Replies
Jun 10, 2012
i have a program where the high scores will be saved in a txt file. of course, if the file is already in use, saving the text file won't work. is there an if statement i can do to check if it is in use? or could i check the last access time, and the last modify time and if the modify time happened after the access, i know its closed, and if the access time happened after the last modify time it is still in use?
View 4 Replies
