All right be kind, this is my first question on a forum. I need help on selecting the right software to purchase.
I have a database set up using Access, 6 users. It is split into Tables and Applications, no more then 65MB of data in the tables right now.
I have 2 college courses in Visual Basic 6 and have written VBA code in Access and AutoCad. I work for a steel fabricator and the database is written to track material usage, purchase orders, time, and the like. We are using a simple peer to peer workgroup setup; I do not want to go to a server system.
I want a database structure for storage of data only and I want write Visual Basic applications to access this data for entry, processing, and reporting. Using Access 2002 I do not have the control over user inputs that I want. Plus once the application is written, I do not want other user to make changes to it.
I am looking at Visual Studio 2005 Standard edition, using Visual Basic.
What Database Structure would be the best to use, not running on a server system? I would like ho have up to 12 users running different applications on the same data.
Do I even need to purchase a database or will Basic have everything I need?
SQL server 2005 Standard edition allows up to 4 computers at one time; by connecting, retrieving data or writing data then disconnecting, this should be no problem for 12 users.
Pleas help me get started on the right track.
1  1666   iburyak 1,017
Recognized Expert Top Contributor
SQL Server 2005 is a very powerful tool which can handle thousands of users at a time and process millions of records in seconds.
Not sure about operating system requirements thou. I thought it should be Server.
It is a good piece of technology to put your hands on but needs a lot to learn to work with it, so keep it in mind.
Access is user friendly, easy to use not as powerful as SQL but can handle multiple users and has VBA which is built in front end application development tool.
I am not sure if Visual Studio 2005 Standard edition has database connection functionality which is most important. You have to check this out. I know that it doesn’t have Crystal Reports.
See comparison link on what SQL Standard edition versus Enterprise.
http://www.microsoft.c om/sql/prodinfo/features/compare-features.mspx
If you are looking for good enough cheap, easy to use technology Access is a way to go.
Several users are not an issue for any database otherwise why it would be created in a first place.
You don’t have to listen to me at all… :)
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: Wade Eyre |
last post by:
Folks, I have a quick question that I would very much appreciate some
feedback on. We are a not for profit charity organization that has decided
to develop a software in-house to manage our volunteers. We have SQL and
that makes the most sense from a database solution but we have some issues
surrounding the choice of the development language. Some have suggested
100% java while others say Visual Basic. The head of our team has suggested...
|
by: TC |
last post by:
Hello All,
I apology for posting to many groups but I wasn't sure which group would be
best targeted with my question.
I have inherited an ASP.Net application that requires some maintenance & bug
fixes. I have been asked to also download a copy of the remote SQL Server
database that it uses on the background for potential maintenance and
changes as well.
|
by: Microsoft |
last post by:
Hi,
I have Visual Basic .net 2003 (Standard Edition) & SQL Server 2000 Developer Edition. When trying to create a connection in the server explorer from the .net IDE I get a number of problems;
a.. Under the "Connection" tab, under "1. Select or enter a server name:" when I either select the drop down box or click the refresh button I get an error dialog saying "Error enumerating data servers. Enumerator reports Unspecified error'". The...
|
by: Tim Silva |
last post by:
SDX Modeling, Simulation and Numerical Computing Environment
for science and engineering has now been released.
Major features include:
* A unified simulation environment for modeling virtually any type of
continuous-time (ode), discrete-time (digital), hybrid or multi-rate
dynamic system.
* A flexible "open system" architecture that allows for the creation
of application specific modeling functions or a hook up to external
|
by: arnuld |
last post by:
hello all,
1st of all, i searched last 12 years archives of comp.lang.c++
because i have some problems. i got some help but not satisfied as i
did not get solution specific to my problem. In the end, searching
archives is a boring & very time-comsuming task BUT it really helps.
actually i have posted this question onto some other newsgroup too but
i am posting it here too because C++ has fascinated me. here is my
question:
| | |
by: itamtodd |
last post by:
I am in the process of developing a small program that I will be trying
to sell to different institutions. The program is written in VB and
uses an Access database.
Now how do I go about selling people a license for my software? And
also how do I protect my software from just being ripped off, i.e.
Encrypt it?
Thanks
|
by: makennedy |
last post by:
Hi Experts,
Please help, I am a newbie to ASP.NET 2.0 may be I am doing something wrong or there may be a bug somewhere.
Basically I have a TreeView Control which I have created programmatically. And I want to bind the selection of a TreeNode (which is a record) from the database) to a DetailsView which shows the datatable record for the selected TreeView node in the Details View.
I am using IDE : Visual Web Developer 2005 Express; OS=...
|
by: =?Utf-8?B?UGF1bA==?= |
last post by:
I was just wondering if anyone knows if vs2005 standard edition will work for
this. I would like to build some windows applications that will have Crystal
reports as an output and interface with SQL express. I need low cost
software as am on a budget and noticed that vs2005 standard edition is only
$226.00. Also I would need to build an MSI (install file) with this that
would include the SQL express database (I think it is free), the...
|
by: Venturini |
last post by:
I am trying to put together a web page where the customer makes choices of products and is then given a total. I am extremely new to Javascript and have managed to get as far as I have from web searches for scripts and html and adapted them.
I need to know the principles of how to disable certain options based on other selections within the form. I have attached my script and html below to help.
For example of a customer selects (BASIC...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| | |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
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...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
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...
|
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
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
