We recenlty migrated the backend of our Access 2000 database in SQL Server 2005. The front end is
still in Access 2000. We would like to eventually rebuild this database to make the front end web based
with the data stored in SQL 2005. I have heard that is necessary to rewrite the forms etc using asp.net
to create a web based front end. Is there a program similar to DreamWeaver where you can design
the front end forms while having HTML written automatically as the pages are designed and still maintain
connections to the SQL Server 2005 database? Thanks,
An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs).
Being someone who is always looking for alternatives to "work your data", I came across this …
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data.
A Microsoft Access subform is used to show relevant calcul…