Is it possible to insert data into a query I in access instead of a table – when I select the Server behavior “insert record”, all I can select is tables under Insert into table ??

If I understand your question correctly, you need to build the recordset with the ADVANCED button. This will allow you to setup run-time and default variables which can be placed into your SQL Query that makes the recordset.

Aegis Kleais
New Media Web Developer
(DWMX : IIS5.1 : SQL2K : WXP : ASP[VB/JS])

Could you please write a little more about what you want to do.

Hi,

This is what I want to do.

I am working with sql data base with a front end in access.

In ultraDev I want to insert and update access tabels (linked sql tabels).

I created a query in access containing a number of tabels - it is this query I want to use as a "recordset" in UDev to update and insert records.

The problem is that I cannot select querys in the UDev server behavior "insert reccords".

Is there a way around this ??

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

Goes to show what I know. I had no idea an Access DB and a SQL DB could "link" with one another. A backend in SQL is common (as that it is the mac daddy of databases, aside from the grandaddy, Oracle), but do you by chance mean an ASP frontend? (and not Access) Otherwise, I'm confused. (and that happens more often the naught)

Aegis Kleais
New Media Web Developer
(DWMX : IIS5.1 : SQL2K : WXP : ASP[VB/JS])

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
The problem is that I cannot select querys in the UDev server behavior "insert reccords".
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

If i understand you correct then while definig your recordset in ultradev choose the respective recordset and as a table choose the query table.

Then you will see the columns in the insert behaviour.
I had no problems with that.
So good luck.

Have to admit your posting is a little confusing.
firs of all, if your natural language is french, italian or spanish post your question in any of this and i will asist you as far as posible.

If i got it right in english, i assume you have an acces db with a blank table ready and waitng to recive the inserted infor from your sql db.

your sql table contains info that will be computed, compiled or requested somehow... right

Now create a connection to your acces db, create a recordset and using the insert record choose your recordset.

Then apply your sql statements from the advanced button .

Let me know if i got it al wrong or this is what you were looking for

Everybody should belive in something... I belive i'm having another beer

Maybe I should take a course in explanation <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle> – I found the info I needed elsewhere on this site. I have learned that my question could be simplified to “insert data into multiple tables”

Thanks for the interest in my question!