473,689 Members | 2,839 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Alternative to Access and VBA

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

Oct 24 '07 #1
1 1725
<bg***@yahoo.co mwrote in message
news:11******** **************@ e9g2000prf.goog legroups.com...
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
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.

Oct 24 '07 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
1823
by: f00sion | last post by:
I found a good tutorial of how to supply the objects without having the implementation files on the client. This was working great until I realized that I couldnt use any constructors with server activated objects, so I switched to client activated objects only to run into the next roadblock, doh! can't instantiate abstract classes... here is a simple example of the structure, im sure there is a way to do it to allow instantiation but I am...
13
5823
by: Mark | last post by:
I am looking for a switchboard creator alternative for my MDB. Can anyone help me? Thanks for your help, Mark
1
3300
by: Sebastian C. | last post by:
Hello everyone I just found at the adress below Microsoft Access Run Time. It says that this is Access Run Time :Alternative Version. There is nothing about who can download or install this version. http://www.microsoft.com/downloads/details.aspx?FamilyID=0c8f40ca-9ecc-426a-ac5f-e1f98a6acd73&DisplayLang=en It can be downloaded. I downloaded and install it and it works just
115
14101
by: TheAd | last post by:
At this moment I use MsAccess and i can build about every databound application i want. Who knows about a serious open source alternative? Because Windows will be a client platform for some time, i prefer a solution that (also) supports Windows. On the net I found a number of products that i looked at, but none of them gave me the impression of a serious candidate at this moment (KNoda, Gnome DB Manager, InterBase...). 2 additional...
3
9482
by: C | last post by:
Re: Microsoft Knowledge Base Article - 870669 How to disable the ADODB.Stream object from Internet Explorer You may recently have heard of the vulnarability exposed by Internet Explorer as described in that article: "An ADO stream object contains methods for reading and writing binary files and text files. When an ADO stream object is combined with known security vulnerabilities in Internet Explorer, a Web site could execute scripts...
1
4323
by: maccaroo | last post by:
Hi Does anyone know an alternative way to get the result from a query in access vba? I've got a form with a few labels that need populating. Even if I only need a single value, the only way I can see to get some of the data is by creating a recordset object and populating it, and then extracting the field I need. Here's my code:
16
2961
by: silentlights | last post by:
Hi Guys, I am looking for an alternative means of register access in a microcontroller. Currently my get() function looks like this.. ------------------------ implementation in comm.c ------------------------ /*A simple get() function*/ unsigned char port0_get_char(void) { unsigned char input_c;
13
4230
by: Pamela via AccessMonster.com | last post by:
Hi All; I work for a company which is currently utlizing MS Access on a shared drive where people from all over the country access. Because all are wishing to view a single database maintained solely by us (in Florida), each region cannot have their own individual database on their local servers (otherwise we would have to update several databases as opposed to one central database). We have tried splitting the database, but it is still...
11
5143
by: solarisss | last post by:
I have thousands of files whose exitence needs to be checked. I think fstat is too costly for this. Is there any better way for the same ?
0
9076
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...
1
8783
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,...
0
8786
tracyyun
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...
0
7621
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...
1
6454
isladogs
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...
0
5810
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
4547
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
2219
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
1952
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.