Solved

How do you edit/rearrange/delete a record in a MS database with FP2000

Posted on 2001-07-04
10
129 Views
Last Modified: 2013-12-24
I just learned how i can create records and view them using the FrontPage database wizards.  Also, the records are created in MS Access.  what i want to do is be able to rearrange the records in the database as well as edit or delete a record.  Does FrontPage 2000 have a way of creating this also or can it only return the database entrys?

Also quick question...does the file upload feature in FrontPage 2002 work only with 2002 extensions or does it work with 2000 also?  uploading images to a database is something else i would like to figure out
0
Comment
Question by:hesperus
  • 8
  • 2
10 Comments
 
LVL 7

Expert Comment

by:ClassyLinks
ID: 6255127
Hi there hesperus & welcome to EE.

What you are going to find with the FP db Wizards is a whole lot of frustrations if you try to do anything complex such as editing/deleting/rearranging records.  Unfortunately, you don't have any flexibility and FP writes all your ASP code itself....you cannot debug it and you cannot change it.  Just take a quick peek at a few of the open questions here and you will see that I am working with other FP users, trying to manipulate the results/code that FP spits out....sometimes without much success.

My best advice?  Learn ASP.  It is really easy to pick up and doing the editing/deleteing etc you are trying to do is part of the basics.  Visit www.ASP101.com for an overview/tutorial.  Then you can post your questions here or in the ASP topic area.

As for uploading images to a db....bad idea.  Much better practice is to load the image into a folder and use the db to point to that image (put the path in the field, not the actual image).  Much less work on the server and it will make your pages faster.

I hope this helps you.  Feel free to post a response to continue this discussion, or ask for clarification on any point.

Thanks for participating in EE.  I know you will find it as useful a resource as I do.

8-)
0
 
LVL 7

Expert Comment

by:ClassyLinks
ID: 6259579
hesperus?  Are you there??
0
 
LVL 7

Expert Comment

by:ClassyLinks
ID: 6264837
hesperus?

Please come back and provide feedback.  EE only works if you reply to the Experts' comments.
0
 
LVL 7

Expert Comment

by:ClassyLinks
ID: 6274202
hesperus...you haven't posted back here in 1 week...please return so that this question does not become abandoned.
0
 
LVL 7

Expert Comment

by:ClassyLinks
ID: 6284171
hesperus....please come back!
0
VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

 
LVL 7

Expert Comment

by:ClassyLinks
ID: 6293931
This question has been open for two weeks without comment from you.

If you do not return I will post this question to CS as abandoned and request grading from a moderator.

Please come back so tha tyou can get resolution to your question.

Thanks.
0
 

Expert Comment

by:teacher_mod
ID: 6310141
monitoring..

teacher_mod
Community Support Moderator
Experts-Exchange
teacher_mod@experts-exchange.com
0
 
LVL 7

Accepted Solution

by:
ClassyLinks earned 75 total points
ID: 6310200
What you are going to find with the FP db Wizards is a whole lot of frustrations if you try to do anything
complex such as editing/deleting/rearranging records.  Unfortunately, you don't have any flexibility
and FP writes all your ASP code itself....you cannot debug it and you cannot change it.  Just take a
quick peek at a few of the open questions here and you will see that I am working with other FP users,
trying to manipulate the results/code that FP spits out....sometimes without much success.

My best advice?  Learn ASP.  It is really easy to pick up and doing the editing/deleteing etc you are
trying to do is part of the basics.  Visit www.ASP101.com for an overview/tutorial.  Then you can post your questions
here or in the ASP topic area.

As for uploading images to a db....bad idea.  Much better practice is to load the image into a folder
and use the db to point to that image (put the path in the field, not the actual image).  Much less
work on the server and it will make your pages faster.

I hope this helps you.  Feel free to post a response to continue this discussion, or ask for clarification
on any point.
0
 

Expert Comment

by:teacher_mod
ID: 6330237
That a long enough wait.  Points awarded.

teacher_mod
Community Support Moderator
Experts-Exchange
teacher_mod@experts-exchange.com

0
 
LVL 7

Expert Comment

by:ClassyLinks
ID: 6330288
Thanks teach.  ;-)
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Turn A Profile Picture Into A Cartoon Using Photoshop And Illustrator This tutorial will teach you how to make a cartoon style image out of a regular picture. I have tried to keep the tutorial as simple as possible. I used Adobe CS4 for this tuto…
Introduction In this tutorial, I'll explain how to create an animated progress meter in a wireframe prototype developed using Axure RP 7.0 - a leading prototyping tool for designing web sites and software. (For more information about Axure and gett…
The purpose of this video is to demonstrate how to properly insert a Vimeo Video into a WordPress site or Blog. This will be demonstrated using a Windows 8 PC. Go to your WordPress login page. This will look like the following: mywebsite.com/wp…
The purpose of this video is to demonstrate how to add AdSense Ads to a WordPress Website, and how to set up WordPress to automatically place Ads in Sidebars. This will be demonstrated using a Windows 8 PC. Log into your AdSense account. : Cli…

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now