I am creating a dynamical access from UDev to an access-database. For that I am often experimenting and completing my database and so I often need to add some more fields in access. BUT: in the recordsets of UDev I see only the old databasefields of the old database. So I have to delete the databaseconnetctions in UDev for ALL ASP-pages and create them new.

THAT IS DISTURBING MY NERVES!

Is there a way to automaticaly actualise the connected fields in a databaseconnection if they change or if new fields are added?

Thank you for your help.


PeMu


PeMu

If you create a recordset on the page using an SQL SELECT statement something like:

SELECT * FROM YourDatabaseTable

The * is a wildcard and will retrieve all the fields from the database table, regardless of how many there are. However you will still have to drag new fields from the Data Bindings window on to the page in order to display them.

Regards

Owen.

Multiple Parameter UD4 / Access 2000 Database Search Tutorial:
www.tdsf.co.uk/tdsfdemo

I know, I know, but in the data binding window the new added fields of the access database are not shown. They are only visible, when I delete and regenerate the database-connection. Only then the fieldnames are refreshed.


PeMu

PeMu

OK, OK, keep your hair on.<img src=../images/dmxzone/forum/icon_smile_big.gif border=0 align=middle>

I'm afraid there isn't really a way around this, what you are trying to do doesn't really fit within the standard set of requirements for an ASP page.

So unless anyone has a really slick solution you're going to get used to having your nerves disturbed.

Owen.

Just doubleclick on that recordset and click OK after that. In other words open and close recordset.

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
I am creating a dynamical access from UDev to an access-database. For that I am often experimenting and completing my database and so I often need to add some more fields in access. BUT: in the recordsets of UDev I see only the old databasefields of the old database. So I have to delete the databaseconnetctions in UDev for ALL ASP-pages and create them new.

THAT IS DISTURBING MY NERVES!

Is there a way to automaticaly actualise the connected fields in a databaseconnection if they change or if new fields are added?

Thank you for your help.


PeMu


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

<img src=../images/dmxzone/forum/icon_smile_big.gif border=0 align=middle> Thanks to all replies! <img src=../images/dmxzone/forum/icon_smile_big.gif border=0 align=middle>

Your method, vfarcic, works fine.
I'm now sleeping better...<img src=../images/dmxzone/forum/icon_smile_wink.gif border=0 align=middle>

PeMu

PeMu