Opens MSAccess 97 and 2000, works with databases with passwords. it allows the user to add, edit, delete modify RECORDS from any access database, also added defrag database function. Please Vote. :D
Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. Afterdownloading it, you will need a program like Winzip to decompress it.Virus note:All files are scanned once-a-day by Planet Source Code for viruses, but new viruses come
out every day, so no prevention program can catch 100% of them. For your own safety, please:
Re-scan downloaded files using your personal virus checker before using it.
NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.
Scan the source code with Minnow's Project Scanner
If you don't have a virus scanner, you can get one at many places on the net
including:McAfee.com
Terms of Agreement:
By using this code, you agree to the following terms...
You may use
this code in your own programs (and may compile it into a program and distribute it in compiled format for languages that allow it) freely and with no charge.
You MAY NOT redistribute this code (for example to a web site) without written permission from the original author. Failure to do so is a violation of copyright laws.
You may link to this code from another website, but ONLY if it is not wrapped in a frame.
You will abide by any additional copyright restrictions which the author may have placed in the code or code's description.
Do you really mean adding, deleting & modifying records to a database means editing the database! (If this comment was disrespectful, please report it.)
9/9/2003 3:52:52 AM:
the program is nice, needs a little tweek in the interface, but still good enough. :) (If this comment was disrespectful, please report it.)
9/9/2003 10:42:29 AM:
i give you 5 globes, because i need your code for my project! (If this comment was disrespectful, please report it.)
Nice idea, please work on adding tables in Access Databases.5 gloves from me and try that!!! (If this comment was disrespectful, please report it.)
12/21/2003 9:14:08 AM:
Finally, a project in which you can delete records related to another table. But I don't understand how it works, lol, you could'nt email me back and explain the delete method could you? Really appriciate it, cheers. (If this comment was disrespectful, please report it.)
2/23/2004 9:32:44 PM:
Great work! Yup, small project but amazing features. Anyway, ;) how do the add records works? Pls kindly email me at kcmokyn@tm.net.my. Thanks alot! (If this comment was disrespectful, please report it.)
3/31/2004 8:51:43 PM:
Great! I was stumped in converting my mdb from Access 97 to 2000. Changed my Project Reference to be like yours - and Viola - IT WORKS! thanks (If this comment was disrespectful, please report it.)
4/4/2004 12:08:11 AM:
5 what i needed at this point thank you.
(If this comment was disrespectful, please report it.)
where as this is some great code the user interface is a little interesting. Any reason that you didn't just use a flex grid or something along those lines??? ***** though for the great code. (If this comment was disrespectful, please report it.)
6/1/2004 3:58:30 AM:
My goodness ya'll, if you want to know how the add, delete etc functions work,..... DBL CLICK THE CONTROL ON THE FORM and find something having to do with what your looking for (If this comment was disrespectful, please report it.)
8/16/2004 3:27:36 AM:
im new to programming,i have a question. how can i put a passwrod to my MS access and let my VB open it. coz i need to put a security on my database. (If this comment was disrespectful, please report it.)
You can add password to your database in Access by clicking on tools from the drop down menu and then security, then "set database password." you can open it using code in VB by specifying the password on your connection string.
example in ADO is ===
clConn.Open "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\mydb.mdb" & ";Mode=ReadWrite|Share Deny None;Persist Security Info=False" & ";Jet OLEDB:Database Password=" & MyPassword MyPassword being a variable that contains the password. clConn being declared as Adodb.connection
Example opening in DAO is=== Set Db = OpenDatabase(DbFileName, False, False, ";pwd=" & DbPass)
Db being declared as a database, Dbfilename, as string containg the path of the database and DbPass a variable containing the password.
(If this comment was disrespectful, please report it.)
Everything works great but the Adding feature isn't that clear. look over it again and could you re explain how to add a record (lets say you have 3 fields) ID, Name, Number
(If this comment was disrespectful, please report it.)
to add a record, you just type in the data you would want to go into the field, and then click next. when the command next becomes disabled then you have to click save. if your copy of the code doesn't automatically change the command button's caption to save when the last field is reached then try downloading the code again. i made a small blunder with the previous code regarding adding records, and i have uploaded the new one. thanks to Bulut for bringing this to my attention. =) (If this comment was disrespectful, please report it.)
1/20/2005 3:03:59 AM:
Sir, I am unable to download this code! Please help (If this comment was disrespectful, please report it.)
1/31/2005 5:28:37 AM:
Sorry! The downloading of the code is not working. Please let me know how to download the code (If this comment was disrespectful, please report it.)
5/5/2005 8:39:51 PM:
i need this code for my project,,,so i rate this as an exelent level,,,,,,,,,i think so!!!!!!!!!!! good----good----good---- (If this comment was disrespectful, please report it.)
6/9/2005 3:32:24 AM:
Hey dude, great job.Can u help me to create one but as Excel Database Editor instead?I need that urgently !Hope to hear a favourable reply from u!Thanks dude! (If this comment was disrespectful, please report it.)
Just wanted to say thanks, actually for the comment with the passworded database...haven't been able to find the line for doing that ever and now I can finally have a protected database and open it in VB, thanks much! (If this comment was disrespectful, please report it.)
simple but excellent cheers (If this comment was disrespectful, please report it.)
Add Your Feedback
Your feedback will be posted below and an email sent to
the author. Please remember that the author was kind enough to
share this with you, so any criticisms must be stated politely, or they
will be deleted. (For feedback not related to this particular code, please
click here instead.)
By 49 Users
Download code
9/7/2003 12:50:09 PM: 
