|
| |
|
|
Eli
Posts: 2659
From: ... er ...
Status: offline
 |
Updating fields - 12/7/2001 8:01:08
I know that this question has been asked 1000 times but I couldn't find the thread.
How do I update a databse field without having to upload the whole database.
Can I build a access page that willl allow me to update whilst online?
thanks
"... treat me like a child.."
|
|
|
|
garyj
Posts: 38
Joined: 12/13/2001
From:
Status: offline
|
RE: Updating fields - 12/13/2001 17:49:11
I'm not sure if I have the same question as Micah or not. I want to add and delete the fields themselves, NOT records in the fields. The 2 links given by rdouglass refer to records.
I am new to DB's, do not know SQL, and had a hard time following the info in the links -- so if that's the way, please step me through it as simply as possible.
Thanks.
| |
|
|
|
garyj
Posts: 38
Joined: 12/13/2001
From:
Status: offline
|
RE: Updating fields - 12/14/2001 8:49:27
I'm surprised FrontPage doesn't have a mechanism for making these changes; seems like a common task.
I'm not online yet (still in the design phase) -- is your suggestion still the way to go?
I've tinkered with editing in MS Access directly and the fields seem to update correctly when I come back to FrontPage. Will this work or is it a recipe for disaster?
On a related topic, I found the field types (text, memo, number, etc.) to be rather limiting when I created the DB using the DB Interface Wizard, but discovered many more field types in Access. If I change a field type in Access to one not in the Interface Wizard, will it still work? (I'm aware of data conversion issues.)
One concern is a 'file upload' field I've added using Access (field type=OLE). Not having many choices, I originally made this a text field when creating the DB. I've added a file upload element to the form and mapped the field name to the DB column, and all looks well, but is FrontPage still going to read this as a text field?
| |
|
|
|
garyj
Posts: 38
Joined: 12/13/2001
From:
Status: offline
|
RE: Updating fields - 12/14/2001 10:36:49
Addendum to the preceding post: I just realized that what I called 'field type' above is called 'column type' by FrontPage.
| |
|
|
|
Spooky
Posts: 26606
Joined: 11/11/1998
From: Middle Earth
Status: offline
|
RE: Updating fields - 12/14/2001 14:58:10
FP will still use the column types ok, its only the initial save to database form that uses minimal column types.
DONT use OLE fields!!!
If you need to save an image or "BLOB", use a text type and save a path reference to the actual file.
Access will soon explode if you save files into it......
§þððk¥
Database / DRW Q & A
VP-ASP Shopping cart
| |
|
|
|
garyj
Posts: 38
Joined: 12/13/2001
From:
Status: offline
|
RE: Updating fields - 12/14/2001 17:05:56
I'll change the column type to 'text', but I'm not sure how to implement your suggestion. I assume I use a custom script to send the image to a folder, and the path (plus all the other form data) to the DB. What's the script (or where do I learn to write it), and how do I know what file name the form will assign to the image so that I can reference it in the path (remember every uploaded image will need a distinct name).
Thanks -- you guys are great!
| |
|
|
|
garyj
Posts: 38
Joined: 12/13/2001
From:
Status: offline
|
RE: Updating fields - 12/15/2001 17:19:59
still looking for a response to my last post....
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
