Hi all

Whats the best way for updating a realational access database ??

I have a problem updating ( because of mutiple tables )

Do i have to update one table at a time or is there a way to let Udev handle the update ??

I hand coded an update routine that updates in more tables but I wonder if there is a more easy way to do this

THX in advance for your replies

Bash

GREAT site Waldo !!!

The normal way you go is update one table at the time.
However there are some cases that you want to do a mass update. Then you usually write directly an SQL statement or make a SP (Stored Procedure) containing all the updates. However Access is not very good at that - you should consider moving to MS SQL Server.

Greetings,
George Petrov
UDzone.com

Bash,
I think that your own routine is the best. To answer your question: UD can't update multiple tables. It's on my wish list for UD 5 <img src=icon_smile.gif border=0 align=middle>

Waldo Smeets - www.UDzone.com Webmaster
------------------------------------------
www.UDzone.com : A Dreamweaver, Dreamweaver
Ultradev and Fireworks site by developers
for developers.
------------------------------------------

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
Bash,
I think that your own routine is the best. To answer your question: UD can't update multiple tables. It's on my wish list for UD 5 <img src=icon_smile.gif border=0 align=middle>

Waldo Smeets - www.UDzone.com Webmaster
------------------------------------------
www.UDzone.com : A Dreamweaver, Dreamweaver
Ultradev and Fireworks site by developers
for developers.
------------------------------------------
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

Thx for your replies Guys

Bash