Using DIW with Access

H

Hudnall

I've Used the Database Interface Wizard to create several forms with an
Access database, including a database editor form. The form lists ALL
records in the db then allows you to click on one of them to edit, etc.

Our db is a "HelpDesk" and is very large and the techs have to scroll thru
every record to find their tickets that are not complted. I would like to
have the editor only list records with a criteria of "not completed helpdesk
tickets" -- I already have a query for this in the actualy Access db.
However, the db editor specifically says if you edit the form thru DWI, it
will cease to work correctly and sure enough, when I point the DWI to the db
query instead of the db table, it ceases to work!

Is there any way around this?

Thanks.

C. Hudnall
 
J

Jim Buyens

Rerun the DIW from scratch.

However, you may have trouble inserting, updating, and
deleting records through a query. Be sure to test this.

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------
 
H

Hudnall

When running the DIW, there are no options to choose a query. It only lists
the tables in the Access DB to choose from.
 
J

Jim Buyens

Hudnall said:
When running the DIW, there are no options to choose a query. It only lists
the tables in the Access DB to choose from.
Click to expand...

OK, well, that's probably because not all database systems can update
through queries. You run into problem with things like required fields
that aren't part of the query.

In that case, you would probably need to program the applciation in
ASP or ASP.NET.

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------
 
Top