473,218 Members | 1,445 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,218 software developers and data experts.

Software selection help Visual & Database

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.
Apr 17 '07 #1
1 1627
iburyak
1,017 Expert 512MB
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.com/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… :)
Apr 17 '07 #2

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

Similar topics

4
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...
4
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 &...
5
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;...
1
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...
11
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...
11
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...
2
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...
3
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...
3
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...
1
isladogs
by: isladogs | last post by:
The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...
0
by: veera ravala | last post by:
ServiceNow is a powerful cloud-based platform that offers a wide range of services to help organizations manage their workflows, operations, and IT services more efficiently. At its core, ServiceNow...
0
by: VivesProcSPL | last post by:
Obviously, one of the original purposes of SQL is to make data query processing easy. The language uses many English-like terms and syntax in an effort to make it easy to learn, particularly for...
0
by: jianzs | last post by:
Introduction Cloud-native applications are conventionally identified as those designed and nurtured on cloud infrastructure. Such applications, rooted in cloud technologies, skillfully benefit from...
0
by: mar23 | last post by:
Here's the situation. I have a form called frmDiceInventory with subform called subfrmDice. The subform's control source is linked to a query called qryDiceInventory. I've been trying to pick up the...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
2
by: jimatqsi | last post by:
The boss wants the word "CONFIDENTIAL" overlaying certain reports. He wants it large, slanted across the page, on every page, very light gray, outlined letters, not block letters. I thought Word Art...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...

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.