473,795 Members | 3,331 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

When is a new system required?

76 New Member
I have developed a nice database system that controls almost all aspects of one manufacturing department. I am using microsoft Access as the database (Jet?) and I use forms to enter data. The front end is done all in data access pages hosted on an IIS 5.0 server. This allows all of the sales people to look at their orders. Everything works great, the sales people love it and my job is pretty easy. The problem is that our General Manager loves it also. He wants me to make a much more robust version that will keep track of multiple departments and at least three manufacturing departments. Sales people will actually turn in orders through the internet. My question is about the limitations of Access. I will have about 25 users logged into the DB changing data in the tables at any given time. I'm wondering if I should switch to a different database such as MySQL or MS SQL. I would use one box for the SQL database, one box for the IIS 5.0 webserver, and develop pages in ASP for the front end. Access is sooo easy though. Even though DAPs are no longer supported, I could use the VBScripting knowledge I've learned with ASP. Also, I am a one man team except for a guy that designs web pages so that has to weigh in with the development side of things.
I appreciate any advice you may have.
Thanks,
James
Oct 26 '07 #1
3 1578
MMcCarthy
14,534 Recognized Expert Moderator MVP
Hi James,

Firstly I've moved this to the software development forum where I think its more appropriate.

Secondly there shouldn't be any problems using Access with 25 users. Have a look at this Article on Microsoft Access Specifications. As you can see you can theoretically have 255 concurrent users.

However, if you are at all worried you could base the data (table structures) in MySQL/MS SQL and use odbc to link Access to the SQL back-end. This will allow you to keep Access as a GUI and keep your existing structure and VBA code.

Mary
Oct 26 '07 #2
kcddoorman
76 New Member
That's a relief. I've grown so accustom to using access and data access pages are so easy once you've used them some. I'm a linux guy though and setting up a SQL server would be fun for me.
Thanks McCarthy,
James
Nov 1 '07 #3
MMcCarthy
14,534 Recognized Expert Moderator MVP
That's a relief. I've grown so accustom to using access and data access pages are so easy once you've used them some. I'm a linux guy though and setting up a SQL server would be fun for me.
Thanks McCarthy,
James
You're welcome.
Nov 1 '07 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

3
4742
by: Webdiyer | last post by:
I want to integrate SecurID two-factor authentication system of the RSASecurity.inc into our asp.net application,but I get into trouble when trying to call the API functions of the ACE Agent,I got an error message saying "Cannot marshal parameter #2: Invalid managed/unmanaged type combination (this value type must be paired with Struct)" when calling "AceGetPinParams(iHandle,ref sd_pin)" function,here's my test code: private static...
1
4027
by: Rhy Mednick | last post by:
I'm creating a custom control (inherited from UserControl) that is displayed by other controls on the form. I would like for the control to disappear when the user clicks outside my control the same way a menu does. To do this my control needs to get notified when the user tried to click off of it. The Leave and LostFocus events of the UserControl work most of the time but not always. For example, if they click on a part of the form...
2
8314
by: Jaikumar | last post by:
Hi, 1) I have created one windows application, In the main form ( form1) i have added one usercontrol (usercontrol1), In that user control i am drawing one image. 2) In the UserControl1 i am showing one transparent form (form3) when ever user preseed left mouse button. 3) The form3 has one transparent user control (usercontrol2) that paints circles. That measn the circles will show on top the usercontrol1 image. 4) The form3 border style...
5
2417
by: Dan | last post by:
Hi, I'm going crazy here, please help. I have a parent page that has a user control on it that bubbles up data from a dropdown menu. The drop down menus are populated by a set of radio buttons, each populates the drop downs with unique data. All works well, you check a radio button and the onbubbleevent fires loading the drop downs. A user can then select an item from the drop down and be forwarded (Respose.Redirect) to the appropriate...
8
2771
by: Ray5531 | last post by:
Hi All, I got the following Error when I try to run my ASP.NET app ,hosted by IIS 5.1 in windows xp. Event Type: Error Event Source: ASP.NET 1.1.4322.0 Event Category: None Event ID: 1000 Date: 6/20/2005
1
1664
by: Nathan Sokalski | last post by:
I have a problem that is driving me crazy. I have a User Control composed of three DropDownLists that will be used to select a date. I have everything working except for one thing. When I select a new value from one of the DropDownLists, the code still returns the old value. You will notice that I try to access the SelectedIndex property in DateChanged, which is the eventhandler for all three SelectedIndexChanged events, although I could put...
21
5232
by: StriderBob | last post by:
Situation : FormX is mdi child form containing 2 ListViews ListView1 contains a list of table names and 4 sub items with data about each table. ListView2 contains a list of the columns on each table and 11 sub items with data about each column. When a Row in ListView1 is selected the Data in ListVies2 is loaded to show the correct data. Initially the first row in ListView1 is selected in FormX load
1
1978
by: Michael D. Reed | last post by:
I am using the help class to display a simple help file. I generated the help file using Word and saving it as a single page Web page (.mht extension). I show the help file with the following statement. Help.ShowHelp(Parent:=Me, url:=Me.HELP_URL_PRE & Me.myWorker.HelpFile) How do I get it to go away when the program exits? Now when I quit the program that I called it form the help file is sill displayed. Is there a way to get a handle...
3
2679
by: Phillip N Rounds | last post by:
I'm writing a user control which has two states: Active & InActive. I additionally am required that there to be only one active control per page, and all logic has to be contained within the control. In its inactive state, only a single button appears. If the user clicks on this button, the control becomes active( the rest of the control's functionality becomes visible), and all other instances of this user control on the page should...
11
3268
by: MikeT | last post by:
This may sound very elementary, but can you trap when your object is set to null within the object? I have created a class that registers an event from an object passed in the constructor. When my object is destroyed, I want my object to un-register this event. If I don't then the object would never be destroyed until the object I passed in the constructor is destroyed. I have implemented a Dispose(), Dispose(bool), and ~Finalize...
0
9672
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
10435
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
9037
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
6779
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5436
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5563
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4113
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
3721
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2920
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.