|
| 
| Submitted on: 3/18/2002 10:37:59 AM
By: Andy T.
Level: Intermediate
User Rating:
By 17 Users
Compatibility:ASP (Active Server Pages), HTML, VbScript (browser/client side)
Users have accessed this code 4665 times.
|
(About the author) |
| | | This will allow you to edit a collection of Access database's table data online. The bulk of the working code was originally submitted by Cakkie, and I added some new features, like secure login, the ability to select any database/table in a predefined directory, query tool, paging, result set count, and a new CSS style schema. I tested it a bit, but please report any bugs that may occour. View the ReadMe.txt file for setup instructions.
| |
|
| |
|
Download 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 langauges 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 |
|
| |
| Your Vote! |
|
See Voting Log |
| |
| Other User Comments |
3/18/2002 10:39:30 PM:Lewis Moten
This is pretty cool, but only set for
being in a directory off of the root
directory. It worked ok after I
changed the path to the database and
include files.
|
3/19/2002 12:09:20 AM:Andy T.
Whoops, missed that one, but I fixed
it. Thanks for the feedback.
|
3/19/2002 12:38:29 PM:Andy T.
3/19/02
Updated the project to allow
password entry for protected databases.
Special thanks to Ian for the fix.
|
3/24/2002 4:23:33 PM:Wolter
Hmm, very very nice.
However, I
changed the code a little bit so that
it would return to a proper page after
I press the logoff button.
I made a
new CONST GotoAfterLogoff =
"http://www.websitename" in the ADO.asp
page that holds the website to return
to, and changed the code in the
LOGIN.asp to
"Response.Redirect(GotoAfterLogoff)".
|
3/26/2002 5:52:43 PM:Robert Santorelli
My db file is off the root.
Im going
nuts trying to configure
this,
Suggestions?
|
3/26/2002 7:58:08 PM:Andy T.
Make sure you change the path to your
database directory. If your database
is directly on the root folder change
the path variable in ado.asp to
Server.MapPath("/"). I just tested
this and it worked fine, contact me if
the problem persists.
|
3/29/2002 12:04:42 PM:edy
I set de databases in e folder "db" on
de root of my web site.
Db1.mdb ,
db2.mdb bet in de dropdown selection I
see noting
Some screen shots
www.nvt.be/dbedit
Suggestions? Tnx
|
3/29/2002 2:14:35 PM:Andy T.
Edy was having a problem with line 98
from "default.asp", this line specifies
the filter criteria for the files.
Since his system labeled MS Access
databases different from the method
that I used, the databases were not
found. This was fixed by entering his
system's Access type name into line 98
as a filter criteria.
|
4/25/2002 1:16:54 PM:Chris
I'm a beginner, but after changing
paths I see empty screen after loading
login.asp page... anyone will help..?
|
4/29/2002 8:27:03 AM:The Sam
I think it would be a kick to try to
port this code for databases besides
Access. I'll see what I can do, and get
back to you.
|
4/29/2002 10:43:35 PM:Travis
I'm trying to set up this whole thing
to work and I'm running into problems,
I have everything set up I believe. I
can get into my database and go into a
table, and adding a record works fine,
however I can't edit it? I get this
when the update is
pushed:
3001
Arguments are of the
wrong type, are out of acceptable
range, or are in conflict with one
another.
Any ideas to how to fix
this or what I'm doing wrong? Thanks!
|
4/30/2002 8:20:25 AM:Andy T.
Without trying to recreate the error, I
would say you either have an
incorrectly formatted date field or
other field that is being loaded with
an inproper data type, for example a
string in an integer field.
|
5/6/2002 6:49:47 AM:Francesco
SECURITY WARNING!!!!!!!!
The simplest
security test .....
Change the sql
authentication string. if you enter
username:' or ''='
password:' or
''='
pppuuupuffffff!!!!!!!!
good
bye username and password!!!!
Bye
|
5/6/2002 9:18:59 AM:Andy T.
I uploaded the fix, the login will not
accept any single quotes (') anymore.
|
5/15/2002 4:40:52 PM:Marius
I have a database with more dan one
table. In the table secetion i see the
Columns from all the tables. is it
posible to see only the ones from the
selected table.
|
5/15/2002 5:04:20 PM:Andy T.
Either the field name issue has been
there the entire time and nobody cared,
or it happened on my last bug fix.
Either way, the error is now fixed and
the field names will be specific to an
individual table.
|
5/17/2002 3:35:55 AM:kent
I am a beginner adn I got the same
problem as Edy --nothing inside the
dropdown selection. What is "his
system's Access type name". My access
is version 2000. Could you tell me how
to do in more detail? Thans in advance.
|
5/17/2002 8:43:00 AM:Andy T.
Couple Ways:
1. Right click on any
Access db and select properties, look
under "Type of File" (Win 2K)
2.
Insert Response.Write(objFile.Type &
"<br>") after line 96 in default.asp.
Run the page and look for the Access
type.
|
5/17/2002 8:54:07 AM:Andy T.
...cont'd.....
3. Instead of
checking type on line 96, check for
extension of the file like this:
If
Right(objFile.Name, 4) = ".mdb"
Then
....should replace....
If
objFile.Type = "Microsoft Access
Application" Or objFile.Type = "MDB
File" Then
|
5/18/2002 4:20:04 AM:Kent
I got it. Thank you. My Access type is
same as your setting: MSMicrosoft
Access Application. But I still can not
find any files in the dropdown
selection though I have access files in
the root directory and set <br>Const
DB_FOLDER_PATH = "/" <br>
in the
ado.asp. Any further
suggestions?
Thank you in advance.
|
5/20/2002 8:35:13 AM:Andy T.
Honestly, I'm having a tough time
recreating your issue. It may be a
security issue with the IUSR_Machine
account's rights to read the file or
directory contents. Personally I would
try using Response.Write statements in
various loops to determine what the
program is or is not finding in the
root, then go from there.
|
6/4/2002 12:51:19 AM:JOE
Hi.. I would like to ask for the Readme
file that you wrote
"Just change the
"DB_FOLDER_PATH" value in ado.asp to
your database directory."
What does
this mean? I had put the all your asp
folder to
C:\Inetpub\wwwroot\JOE\ASP
The
database you created are in
C:\Inetpub\wwwroot\JOE\ASP\database\Si
teSearch.mdb
Just wonder what shoudl
i do?
It seems that i cnanot run the
asp smoothly..
Thanks
|
6/4/2002 8:51:10 AM:Andy T.
Well, generally in site development
using Access databases, a common
directory is used to store all database
files. You need to point this
constant's path to that directory, or
whichever database you want to edit.
Also make sure your path to the
dbeditor.mdb file is correct.
|
|
| 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.
|
|
