Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
HomeAnnouncementsFree MagazinesWhite PapersSubmit Content
Discussion GroupsASP.NETWindows FormsLanguages.NET FrameworkVisual Studio.NET
Articles.NET FrameworkASP.NETToolsWindows Forms
.NET DirectoryOpen Source ProjectsUser GroupsWeb Resources
Related Topics
Visual Basic 6SQL ServerMS AccessOther DB ProductsMS Server ProductsMore Topics ...

.NET Forum / Languages / C# / October 2007

Tip: Looking for answers? Try searching our database.

Alternative to Access and VBA

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
bg_ie@yahoo.com - 24 Oct 2007 09:26 GMT
Hi there,

My company uses a very buggy and poorly designed msaccess database
which we use to store information from the components we use, to test
results. The database has been added to bit by bit over the years,
offen by students here on practice.

I'd like to present my group with the idea of replacing the database
with a well thought out alternative, but I'm unsure what software to
use to do this - in terms of forms and data storage and retrieval.

I am quite experienced with access now since I have fixed so many
problems in our current database. I am also experienced as a Perl and
C# programmer.

Some of the functions we will require from our current database is the
ability to export data to word, excel and possibly visio also as is
currently possible. Also, it would be nice if there was a possiblity
to add information to the database by component providers and in-field
testers via internet forms. This could be done via ASP. Also, I have
added Python modules which automatically add results to the database
and this works well, while using very strict data validation.

I do believe that we could implement the database in MsAccess but I
hate VBA so much. I often find myself bending over backwards to solve
rather simple tasks. I guess Python and C# have spoiled me...

Anyway, I would be interested in hearing some suggestions as to
alternatives to Access/Jet keeping in mind that we use access forms to
enter our data into the db.

Cheers,

Barry
PvdG42 - 24 Oct 2007 12:36 GMT
> Hi there,
>
[quoted text clipped - 30 lines]
>
> Barry

What I hear you objecting to is Access as a software development tool.
Depending on your storage requirements and the potential number of
concurrent users, you could keep Access as the database and write the
application(s) in C# using ADO.NET. It sounds like the database itself may
need to redesigned by somebody knowledgeable in relational database design,
but unless you have requirements that exceed the capacity of an Access
database, why change?
If you do want to change, SQL Server 2005 Express (free) would be a
reasonable choice.

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...

Oracle MagazineNetwork ComputingComputer WorldBio-IT WorldeWeekInformation WeekInfosecurity
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.