Hi i am a university student planning my final year project what i am going to do revolves around RFID.
simply put i am going to read data from a text file input it into a table and then retrieve the associated information from a database which is associated with the text file details.
i wanted to do this in Acces as i am moderatly comfortable with VBA and Access.
My tutor has told my to use other alternatives. Can you propose what you think is the best/simplist for me to understand. and areas you would recommend me to begin studying over the summer to prepare for my project.
Thanks for any help
9  3793 
Depends on how much money you have.
Free options are MySQL, SQLite, and SQL Server Express. Paid options are Oracle, DB2, Sybase, SQL Server, etc. Technically, you could store all your data in a text file if you were so inclined.
But that's just the backend. Access serves a dual purpose as a front end as well. You can use almost any of the programming languages for that. But since you're familiar with VBA, VB.NET may be the easiest for you. You could also go with a web browser as the front end.
@Rabbit
Thanks gor the quick reply, i managed to learn a little MySQL last night so i will use that. You mentioned i could go with a web browser as the front end, by this do you me somthing like phpmyadmin, oracle application express, or wavemaker??
thanks again for your help
If you will bear with me, I would like to ask if your tutor has supplied any arguments for NOT using access?
Im curious because I am often faced with people who do not think to highly of Access but in reality now little about the potential of access.
@TheSmileyCoder
Not as such. i really like Access and have done previous modules in it before. But i think because of that reason he would like to see me push myself a little bit more. i will be attemping to learn a new method over the summer but if i have no luck i think i may have to resort back to Access.
I often feel that some VB programmers think of access as a "lesser" tool.
I personally disagree, and believe that for SOME areas Access is the perfect tool, while sure, for other areas it may be better to code it in VB (or similar).
Compare VB to a bus and Access to a car. You can fit more items and people onto the bus, but its slower and you need a big/truck license to drive it. The car can go faster, and its easier to operate allthoguh you do still need a license. Howerver it is limited to fewer people.
PHP is certainly an option. And it's free. PHP my admin is an interface to administer MySQL databases. But you will also want to pick up HTML, CSS, and javascript if you're going to go the web browser route. You will also need to set up a server and install all the software. It's a lot to do if it's your first time.
you can use MySQL as backend.
Since you are familiar with VB, why dont you use VB.Net or C#.Net.
Im not sure if RFID application can be done in PHP alone. I think you'll need to design Java Applet for your RFID interface. Then embed it to PHP.
regards...
If i was not to go the web browser front what alternative to create the application would you recommend? and thanks again for all who has replied
I think Rexzel's suggestion is a good one.
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Graham |
last post by:
This has to do with class variables and instances variables.
Given the following:
<code>
class _class:
var = 0
#rest of the class
|
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
|
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...
|
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...
|
by: Zlatko Matić |
last post by:
Is it possible to use Access as front-end for POstgreSQL and how ?
What about Access Projects (.adp) and PostgreSQL ?
|
by: Adrian Biljan |
last post by:
Hey all,
I'm trying to create a timer class so I can control when the timer
start and stops. The ideas is to have a form with a start button, and
a stop button.
Start invokes a class method...
|
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...
|
by: Mell via AccessMonster.com |
last post by:
Do you know if there are similar programs through Microsoft or other
platforms compatible via Windows XP that offer a destop application such as
Ms Access that allow easy to learn developing? Ms...
|
by: Verbal Kint |
last post by:
hi.
could you please have a look to the following code:
class cClassA
{
public:
cClassA(void):itsX(0)
{}
void SetX (int val)
{itsX = val;}
|
by: FAQ server |
last post by:
-----------------------------------------------------------------------
FAQ Topic - How do I access a property of an object using
a string?...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
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...
|
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...
|
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...
|
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...
| |
