ASP,Manage,Access,databases,from,your,browser
Quick Search for:  in language:    
ASP,Manage,Access,databases,from,your,browser
   Code/Articles » |  Newest/Best » |  Community » |  Jobs » |  Other » |  Goto » | 
CategoriesSearch Newest CodeCoding ContestCode of the DayAsk A ProJobsUpload
ASP/ VbScript Stats

 Code: 132,008 lines
 Jobs: 161 postings

 
Sponsored by:

 

You are in:

 
Login


 

 


Latest Code Ticker for ASP/ VbScript.
List Records
By Edito P. Aspra Jr. on 8/26


DSN Less Connection to SQL Server Database
By alpesh shah on 8/26


Click here to see a screenshot of this code!Database Driven Select Menu w/ default select
By Jayson Starkey on 8/26

(Screen Shot)

A Simple guestbook in ASP
By Matthew Meadows on 8/25


Simple GuestBook or Feedback Page Requiring No Database Implementation
By Ken Alabi on 8/25


if i remember, this is a M. Harris code sample
By ask on 8/24


MTS Registration Script
By Igor Krupitsky on 8/23


Click here to see a screenshot of this code!Creating Windows Users with ASP and ADSI
By jamespwalters on 8/23

(Screen Shot)

News Poster (Advanced)
By Martin Kilbryde on 8/22


Click here to put this ticker on your site!


Add this ticker to your desktop!


Daily Code Email
To join the 'Code of the Day' Mailing List click here!





Affiliate Sites



 
 
   

DBmanager.asp : have all the control on your online data.

Print
Email
 
winzip icon
Submitted on: 9/3/2001 9:57:10 PM
By: Simon La Rochelle 
Level: Intermediate
User Rating: By 52 Users
Compatibility:ASP (Active Server Pages)

Users have accessed this code 13572 times.
 
(About the author)
 
     <B>Manage Access™ databases from your browser!</B> FEATURES --> Browse folders -->Create Access databases files on the fly -->Add/Mod/Del tables -->Add/Mod/Del records -->Run DELETE INSERT UPDATE Queries -->Build complex SELECT queries in a snal -->Set user permissions through user levels BENEFITS -->Ideal for server administrators -->Ideal for webmasters -->Ideal for ASP developper -->Create simple Internet data-driven apps -->Controlling your data has never been easier! MORE INFOS -->Screenshots and more at : http://www.simon-larochelle.com/dbmanager/

 
winzip iconDownload code

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 Winzipto 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:
1)Re-scan downloaded files using your personal virus checker before using it.
2)NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.

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...   
1) 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.   
2) 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.   
3) You may link to this code from another website, but ONLY if it is not wrapped in a frame. 
4) You will abide by any additional copyright restrictions which the author may have placed in the code or code's description.
 
Report Bad Submission
Use this form to notify us if this entry should be deleted (i.e contains no code, is a virus, etc.).
Reason:
 
Your Vote!

What do you think of this code(in the Intermediate category)?
(The code with your highest vote will win this month's coding contest!)
Excellent  Good  Average  Below Average  Poor See Voting Log
 
Other User Comments
9/4/2001 4:01:51 AM:MS
Bravo
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
9/4/2001 10:17:51 AM:mask
pas mal en effet :)
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
9/4/2001 10:45:59 AM:twalling
The only question I have for you about 
this great work is which (.tlb and/or 
.dll) files to reference in my project? 
 I still get an error when I try to 
access the dB.  I have the 'MS ADO Ext. 
2.6 for DLL and Security' checked under 
project references.  Is their something 
else I have to do?  Thanks in advance.  
Again...great work!!
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
9/4/2001 10:49:56 AM:Simon
All you need is ADO and ADOX (standard 
with ADO 2.3 an up). If you 
protect/password your db, you'll have 
to modify the code.
Send me (by 
mail) the exact error (with line and 
description) and I'll look for 
it.
Simon
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
9/7/2001 4:10:36 AM:KodeKrash
Good work Simon. Considered wrapping 
this up in a class object? This could 
make it more extensible, allow for 
multiple user accounts and permission 
levels, etc.
Extra points to you for 
clean code.
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
9/13/2001 12:58:44 PM:Rafael Alanis Lopez
TANKS ....
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
9/15/2001 12:13:40 AM:Nobi
For somehow, I got your email & tested 
your code...very cool :) You got my 
vote :)
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
9/15/2001 6:09:27 PM:Simon La Rochelle
Thanx for your comments, some of you 
report to me a few bugs, I'll work on 
them today and upgrade my code.
Simon
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
9/19/2001 8:44:58 AM:Chris
Nice Work!
I have a few 
suggestions:
Move the Mod & Del 
Links to the beginning of each 
row.
It does not handle OLE\Binary 
Fields, maybe add code to ignore 
these.
Does not handle Tables with 
Spaces.
When listing data, memo 
fields should get truncated so the list 
fits the window. 
I only give these 
suggestions to help, normally that is 
what people like, Nice work overall.
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
9/19/2001 12:34:12 PM:Simon
Thanx Chris for your 
suggestion,
I'll update my code to 
handle tables with space and ignore 
OLE/Binary.
Moving Mod/Del to the 
beginning change the code logic and can 
be done if speed is not your priority. 
I'll make some test and look the 
difference.
Some people ask me to 
display Memo entirely, some ask to 
truncate them. I think it should be an 
option if I add a technique to view the 
record (without editing).
Again, 
thanx for your comments.
Simon
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
9/19/2001 12:35:24 PM:Simon
Also, I'll try to let the user skip the 
NULL-OK fields when editing or adding 
record.
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
9/20/2001 9:41:11 AM:Xavier
Moltes gràcies-Many Thanks it's very 
usefull and powerfull. I'd like 
it!!
You have my excelent vote!!
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
9/20/2001 11:28:13 AM:Andy
I am getting this error:
Server object 
error 'ASP 0177 : 8002801d' 
Server.CreateObject Failed 
/dbmanager/DBmanager.asp, line 236 
Library not registered. 
I have 
mdac 2.5 istalled on the server.
Any 
ideas? Thanks
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
9/20/2001 11:42:44 AM:Simon
You need ADOX (eXtention of ADO), I do 
not use Interdev, but I think it will 
correct your problem.
Simon 
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
9/20/2001 11:57:32 AM:Andy
I already have adox installed.
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
9/20/2001 12:10:39 PM:Andy
I guess the problem was created by 
installing Crystal Reports 8.
This is 
a link to the 
fix:
http://support.crystaldecisions.
net/communityCS/FilesAndUpdates/scr8_web
regfix.exe.asp 
Great Work 
Simon!
THANK YOU!
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
9/28/2001 1:34:54 AM:Warface
This is fantastic code. 
Congratulations!!!!!!!!!!!!!!!!!!!!!!!!!
!! 
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
9/28/2001 11:09:54 PM:Simon
I'm working on version 2 : wait for it 
! It will RULE!!!
Simon
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
10/3/2001 7:32:30 PM:Erwin
You are the best ! You wrote the most 
convenient code to manage access 
databases online. Vous avez écrit l'un 
des scripts les plus pratiques pour 
ceux qui utilisent des databases ACCESS 
sur internet.
The script is very light 
and does everything that you want to do 
with the database, I mean 
add,modify,delete - just with your web 
browser. You saved my life since when I 
am on the road, it is sometimes 
difficult to update my 
databases.
Thanks for making it 
available free on the net !
One 
suggestion, can you modify the login so 
it requires windows authentication: 
this will add increase security. I also 
use siteman.asp and the made the same 
modification.
I am on my way to 
write a nice review for you at 
PlanetSourceCode.com 
God bless you 
!
Erwin
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
10/3/2001 7:47:24 PM:Simon
thanx Erwin,
I prefer using a 
personalised authotification to send to 
my team without giving the the windows 
one. But you can change to code easy, 
like in siteman.asp.
I'm working on 
version 2 now. Will be available 
soon.
Simon
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
10/9/2001 6:39:27 AM:nikolce
Excellent Work!
I have a few 
suggestions:
1. Login to the 
database with different privileges 
(someone with permission for looking 
the whole table, and the other with 
restricted looking of the table)
2. 
Reading the default values or Time(), 
Date() from databases when ADD the new 
records in to tables.
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
10/17/2001 12:38:48 PM:Brian Ferry
I am not easily impressed but, this 
impressed me. You put a ton of work 
into this project and it fits a very 
strong need of updating ascess 
databases from a browser. Keep up the 
work!
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
10/25/2001 1:18:59 PM:Simon Svensson
Maybe make a option so all security 
within the script is turned off? That 
way I can allow all my registered users 
access to the script, and the NTFS ACL 
will control the security.
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
11/10/2001 4:50:24 PM:George
It's perfect the only question i have 
is why it doesn't recognize greek fonts 
and shows me some unknown letters ?
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
11/10/2001 4:53:27 PM:george
It's perfect ! but the problem is it 
doesn't recognize greek fonts. It shows 
up some unknown letters. Why is that. 
When i code to show up some text from a 
database, it shows them just fine.
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
11/20/2001 11:16:26 PM:Nikko
this rocks so hard when i first 
navigated ABOVE my web dir I fell out 
of my chair.  I still have a knot on my 
head it rocked so hard.  You rock my 
world you little ASP 
pimp!


nikko
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
11/21/2001 12:50:30 AM:The Author
I receive 10+ email / day asking when 
version 2.0 will be available... Now 
you CAN DOWNLOAD IT AT 
http://www.simon-larochelle.com/dbmanage
r/ 
I've work very hard to make it 
the best Access Manager available. 
DBmanager 2.0 is more than 15,000 lines 
of code! Just let me know what you 
think about it.
Simon
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
11/24/2001 6:07:05 PM:Andrew
I keep getting http 500 internal server 
error?
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
11/24/2001 8:16:10 PM:Andrew
I also have a problem with not being 
able to use the "mod" and "del" on my 
other site?
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
1/17/2002 11:06:01 AM:gon
greeeeat Excelent work Simon!!!
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
1/24/2002 1:54:56 PM:Deryck
MySQL form would be great :)
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
1/26/2002 9:54:26 PM:CH
This is AWESOME code!  Thank you so 
VERY much for sharing!!!!
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
1/31/2002 9:59:28 AM:Mike
I downloaded, but got only GETID.asp 
and no other files.
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
2/5/2002 4:29:41 AM:john smith
Indeed, no DLLs are included in the 
ZIP.. too bad :(
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
2/8/2002 4:55:55 PM:mojo
not only that - but some of us cannot 
register dll files on our servers.  
while I know you pure coders will say 
it is faster, that doesn't do me a bit 
of good.
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
4/3/2002 11:13:31 AM:adam
I guess it aint free no more.
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
4/12/2002 9:01:14 AM:deddy
missing dll file.
where it should be?
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
4/20/2002 5:37:47 AM:Abhi Malani
i love this code
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
7/6/2002 8:53:38 AM:ASPGuru
thanks but no thanks...
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
Add Your Feedback!
Note:Not only will your feedback be posted, but an email will be sent to the code's author in your name.

NOTICE: The author of this code has been kind enough to share it with you.  If you have a criticism, please state it politely or it will be deleted.

For feedback not related to this particular code, please click here.
 
Name:
Comment:

 

Categories | Articles and Tutorials | Advanced Search | Recommended Reading | Upload | Newest Code | Code of the Month | Code of the Day | All Time Hall of Fame | Coding Contest | Search for a job | Post a Job | Ask a Pro Discussion Forum | Live Chat | Feedback | Customize | ASP/ VbScript Home | Site Home | Other Sites | About the Site | Feedback | Link to the Site | Awards | Advertising | Privacy

Copyright© 1997 by Exhedra Solutions, Inc. All Rights Reserved.  By using this site you agree to its Terms and Conditions.  Planet Source Code (tm) and the phrase "Dream It. Code It" (tm) are trademarks of Exhedra Solutions, Inc.