Jump to content
Sign in to follow this  
aommaster

Databases.. how and where to begin?

Recommended Posts

aommaster

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
TheTex

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
aommaster

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
TheTex

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
aommaster

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
aommaster

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  

×