Visual Basic Project

[Zenax]

Well I am working on a Visual Basic Project that reads a Microsoft Access Database, then enables you to Delete/edit/add records to the database without having to do it directly into the database

Features Hopefully to Add:

1. Change the Directory of the database, perhaps even including online
2. Allow added functionality so that MySQL databases can be used online (ties in with number 1)
3. Have a more User Friendly Interface
4. Have Password Protection so that you need a username and password to access the database editor

Explanation
Number 1:
This is a form where you will be able to change where the Database is currently situated. This will allow users to move it around without having to change it within the properties of the program itself. This will allow for a stand alone exe.

Number 2:
This will hopefully allow people to use different types of database, such as online databases, again adding extra functionality for Users.

Number 3:
This is basically to tidy up around the edges and make it better looking, and a easier to use design.

Number 4:
This will hopefully bring added security to the use of the databases. The usernames and pass will be stored in a seperate MS Database that will have a password on, to prevent access.

Well if you have any features that you think I should be adding etc, then please let me know.

I am currently at the stages of designing the "Edit" features.

Thanks,
Zenax

Edit: As I am kind of new to this, if you have any sites that might be of use, do not be afraid to post them here!

Edit 2: Got a design for a login script but require coding help. Please gimme links to help moi!

 

[Zenax]

Any ideas? anyone?

 

[Mikek]

My reply to your idea.

Well I am working on a Visual Basic Project that reads a Microsoft Access Database, then enables you to Delete/edit/add records to the database without having to do it directly into the database
...

Explanation
Number 1:
This is a form where you will be able to change where the Database is currently situated. This will allow users to move it around without having to change it within the properties of the program itself. This will allow for a stand alone exe.

Good Idea to let the user select extactly what database they want.

Number 2:
This will hopefully allow people to use different types of database, such as online databases, again adding extra functionality for Users.

Keep it simple. Make an initial version with an access database capabilities. Then expand it.

Number 3:
This is basically to tidy up around the edges and make it better looking, and a easier to use design.

To make it user friendly, follow Windows Design Standards.
Try asking someone else to see whether they can use the system ok.

Number 4:
This will hopefully bring added security to the use of the databases. The usernames and pass will be stored in a seperate MS Database that will have a password on, to prevent access.

Is it necessary to have an password to access the editor?
Access and other database software alllows you to store passwords/permission in the database file.

Well if you have any features that you think I should be adding etc, then please let me know.

An ability to do custom queryies of the database file. eg I only want to edit records that have meet a particular condition.

 

[Trixter]

I agree with everything mikek said... but #2 will be tricky as the code for some DBs are diffrent.

One solution is to wright a program that first querys the backend to find what program is used then impliment the correct prosidures to access it.

If i was you id stick to mainly Access for a small DB, SQL for a large one, and mysql for online.

 

[Micro]

What version of VB are you using -- you havent told us and its fairly important ;-)

 

[Zenax]

Sorry, Im using Visual Basic 6.0 to code.

To achieve having different capabilities, then I think an If statement would be used to determine the different databse, then load the right form.

As for custom quieres, I think that might come in the later versions. And since its mostly in the design stages, I can code in ideas where and when I feel they are necessary.

--
Zenax

 

[Micro]

For you when you start SQL -- if you look at VB.Net 2005 Express -- you can use SQL Express 2005 server graphically inside vb. It's much easier

 

[Zenax]

Cheers Micro, I will take a look into that!

so any more ideas that could be coded in? I just started the re-write last night, to include some features, as well as make the coding and design a lot neater than it was before!

As for the different db types, I will design a form that will enable you to choose, what type youo want, then you can go from there. but at the mo only the access version will work!

--
Zenax

EDIT: The reason for the password to the editor is to stop people from making changes direct from the editor! Basically a security thing, but if enough people don't want it, then I might offer a version without the login screen