Sign in to follow this  
Followers 0
aommaster

Databases.. how and where to begin?

6 posts in this topic

Hi guys!

I'm would like to write a program that will store custom blocks of text into a database. Literally like MS Access, I want it to have the ability to recall, edit, delete, add, etc. information to and from the database.

What is the most efficient way for doing this in Autoit? Where do I start? And are there any resources you could direct me to to learn this?

Thanks again for your help :)

Share this post


Link to post
Share on other sites



So you just want to do it locally not have it store/get info from the internet correct?

If so you can store everything in an excel DB and use excel commands to post/get info

Share this post


Link to post
Share on other sites

Yes, I'd like to have it done locally only. Also, I'd rather prefer if the user could not edit the database except through the program because the block of text will be stored in the database such that the program can recognise edittable fields and show them to the user.

Would the excel DB be able to do that? I thought they could be editted by the user.

Thanks again

Share this post


Link to post
Share on other sites

You do not need the excel document open if that's what you are asking. The program can write it to the file directly and the user does not even need to know where the file is saved. It can pull information from it as well.

Share this post


Link to post
Share on other sites

Yeah, I understand that. But I would like the database to be made in such a way that it is not readable by common programs (such as Excel) so as to prevent the user from editting the database, and thus corrupting the whole thing. The format that data will be stored in the database is extremely sensitive to small changes, and I would prefer if users do not edit it.

Share this post


Link to post
Share on other sites

Anyone have any other suggestions?

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0