This has baffeled me, I carn't figure out how to make ultradev update a query.
The DB i am making will search, List & go to a specific record but will not add a record.
When i try to use the 'update record ' function it just will not see the query.

The DB is 4 related tables (job, company, contact, notes) in access 2000 and the query will let me update it in access.

I know that i am missing somthing here, this is a simple DB and sould be able to do this.
Could anyone please point out what i am missing here.

Thanx
<img src=../images/dmxzone/forum/icon_smile_question.gif border=0 align=middle>

Use Command (Stored Procedure) to update/insert/delete table/query without users interaction.


<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
This has baffeled me, I carn't figure out how to make ultradev update a query.
The DB i am making will search, List & go to a specific record but will not add a record.
When i try to use the 'update record ' function it just will not see the query.

The DB is 4 related tables (job, company, contact, notes) in access 2000 and the query will let me update it in access.

I know that i am missing somthing here, this is a simple DB and sould be able to do this.
Could anyone please point out what i am missing here.

Thanx
<img src=../images/dmxzone/forum/icon_smile_question.gif border=0 align=middle>


<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

I too was haveing this issue. You need to make sure the the iusr_"computername" has write access to your directory. By default everyone has full control to an NT box but iusr_"computername" is a guest accout that within IIS only has read.
Hope this helps.

Ok i have got to use stored procedures to do this. Can any one point me to a good tute on how to set them up?