I have an Access2000 Database that I would like to be able to edit through my website.
I am not a programmer.

I have gone thru the OutFront [Update database] and tried to use the custom query but I don't seem to understand it.
I was hopeing for an add-in or wizard that could help do what I need.

My table contains approx. 32 columns and has 25000 records.

Sorry, My website is not public so I can't show it to you.

Any Help would be greatly appreciated.

Jack

I am sure Spooky has an easier way.

quote:

---

Originally posted by Shirley:
[URL=http://support.microsoft.com/support/kb/articles/q240/0/90.asp?LNG=ENG&SA=ALLKB&FR=0]http://support.microsoft.com/support/kb/articles/q240/0/90.asp?LNG=ENG&SA=ALLKB&FR=0[/U RL]

I am sure Spooky has an easier way.

---

Thank you for the Link. After installing it. It seems to be much the same as in OutFront. I will go through it and see if there are any differences. I was hoping for a wizard that will build it through questions.

Thanks
Jack

quote:

---

Originally posted by jjhill:
Thank you for the Link. After installing it. It seems to be much the same as in OutFront. I will go through it and see if there are any differences. I was hoping for a wizard that will build it through questions.

Thanks
Jack

---

As I stated in my first post above, I am not a programmer. I know how to get to the Custom Query. But, Is there a way to update any or all of the 32 columns?
When you use the Custom Query do you have to list all the fields? Or just the Primary Key Field!

Thanks for any help provided.

Jack

------------------
Spooky
"I am Spooky of Borg. Prepare to be assimilated, babycakes!"
Subscribe to OutFront News
Database / DRW Q & A
The Spooky Login!

quote:

---

Originally posted by Spooky:
Can you explain a little more what you are trying to do? Sometimes, it can be easier to update the actual source, depending what you need to achieve.

---

Spooky,

I have a Database that has 25000 records. Names Address Etc. There are 32 Fields - ID (Key) FirstName, LastName, Address, Telephone, Etc. I would like to be able to upday any one of the 32 fields.
Can this be done?

Thanks for your input.
Jack

quote:

---

Originally posted by Spooky:
Updating singular records like that is certainly achievable. Which part do you think you need help with or what have you tried so far?

---

Spooky,

Thanks for your help.
I have been able to creat a form with Database Results. I can see all records in one form and have created another form with a search on the ID (Key) field. This form when results returned is one record with all fields displayed.

-------
Say I search for 18334 under the ID Field.
Results Returned as follows:
ID = 18334
FirstName = Mary
LastName = Jones
Address = 123 Any Street
City = MyTown
State = AZ
Zip = 72231
Phone = (818)222-1234
CompanyName = XYZ Corp.
CoAddress = 246 Main Street
CoCity = Boston
CoState = MA
CoZip = 02020
CoPhone = (617)999-0000
Etc........

Could it be possible to edit (Update) any one or more of the fields content? What is the nessesary steps to do this.

Thanks
Jack

From the www.outfront.net/spooky/update.htm page :

You would construct a form with 2 boxes called "phone" and "ID"

In the form options, post to Script - specify the DRW page name.

Add this code at step 2 :

UPDATE DISTINCTROW
TABLE
SET Phone ='::Phone::'
WHERE ID=::ID
::

It assumes you know the record number of the phone you wish to change!

------------------
Spooky
"I am Spooky of Borg. Prepare to be assimilated, babycakes!"
Subscribe to OutFront News
Database / DRW Q & A
The Spooky Login!

quote:

---

Originally posted by Spooky:

From the www.outfront.net/spooky/update.htm page :

You would construct a form with 2 boxes called "phone" and "ID"

Thanks Spooky,
I will try it.
Jack

In the form options, post to Script - specify the DRW page name.

Add this code at step 2 :

UPDATE DISTINCTROW
TABLE
SET Phone ='::Phone::'
WHERE ID=::ID
::

It assumes you know the record number of the phone you wish to change!

---

New Problem,
Can you update a Yes/No field?
I have a field called Active and is a Y/N field.
When I added it to my SQL in DRW I would get an error - so I removed it and it worked fine.
Thanks for all your help.
Jack

Server error: Unable to retrieve schema information from the query:

UPDATE Randolph17Plus

SET

RandolphID='1',

FirstName='2',

LastName='3',

Delete='4'

WHERE ID=5

against a database using the connection string

DSN=sbhmain;DRIVER={Microsoft Access Driver (*.mdb)}.

The following error message comes from the database driver software; it may appear in a different language depending on how the driver is configured.
-------------------------------------------------------
[Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.

Source: Microsoft OLE DB Provider for ODBC Drivers
Number: -2147217900 (0x80040e14)

In Access2000 the Delete field is a Yes/No
If I remove it from the list the query works fine.
Thanks for your Help.
Jack