max.wanadoo at gmail.com
max.wanadoo at gmail.com
Thu Dec 6 01:22:59 CST 2007
Mark, this is really weird. With one of my tables I can create the DAPs and edit/write etc both using table and query. With another table I cannot edit/write. I can see no difference between them. I can do anything to either table. I can do anything to either query. But for some reason the DAPs will work with one table/query and not the other. Just don't know, sorry. I have never used these before. If you do figure it out, I would appreciate knowing what the answer was. Thanks Max -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark A Matte Sent: Wednesday, December 05, 2007 10:07 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] HTML page updating Access db So far I have got the DAP to display the data I need...I now realize I cannot update this data??? If I build the page directly from the table...I can edit the data, but if I build it from a query I cannot? Any guidence...I've pulled most of the hair out!!!! Thanks Again, Mark A. Matte > From: max.wanadoo at gmail.com > To: accessd at databaseadvisors.com > Date: Wed, 5 Dec 2007 18:06:03 +0000 > Subject: Re: [AccessD] HTML page updating Access db > > Or one query filter by username. > Max > > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark A > Matte > Sent: Wednesday, December 05, 2007 5:59 PM > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] HTML page updating Access db > > > I'm not sure I'm following... would I need a seperate query and page > for each user? > > Thanks, > > Mark > > >> From: max.wanadoo at gmail.com >> To: accessd at databaseadvisors.com >> Date: Wed, 5 Dec 2007 17:45:27 +0000 >> Subject: Re: [AccessD] HTML page updating Access db >> >> Why not use a query? >> Max >> >> >> -----Original Message----- >> From: accessd-bounces at databaseadvisors.com >> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark A >> Matte >> Sent: Wednesday, December 05, 2007 5:30 PM >> To: Access Developers discussion and problem solving >> Subject: Re: [AccessD] HTML page updating Access db >> >> >> WOW>..I have never used data access pages...looks good so far. For >> WOW>this >> example...I need 3 different people to view only their data...how can >> I filter the DAP?...can I use API calls in them to get the user name? >> >> Thanks, >> >> Mark >> >> >> >>> From: max.wanadoo at gmail.com >>> To: accessd at databaseadvisors.com >>> Date: Wed, 5 Dec 2007 16:38:23 +0000 >>> Subject: Re: [AccessD] HTML page updating Access db >>> >>> Would Data Access Pages do the trick? >>> Max >>> >>> >>> -----Original Message----- >>> From: accessd-bounces at databaseadvisors.com >>> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark A >>> Matte >>> Sent: Wednesday, December 05, 2007 4:25 PM >>> To: Access Developers discussion and problem solving >>> Subject: Re: [AccessD] HTML page updating Access db >>> >>> >>> Thanks Everyone for the feedback. I was hoping to just have this >>> temporary fix on a shared drive. as mentioned below...ASP requires >>> IIS...is there a way to update data in a db without IIS? Client side >> instead of server? >>> >>> Thanks, >>> >>> Mark >>> >>> >>>> Date: Tue, 4 Dec 2007 17:16:39 -0800 >>>> From: accessd at shaw.ca >>>> To: accessd at databaseadvisors.com >>>> Subject: Re: [AccessD] HTML page updating Access db >>>> >>>> Mark: >>>> >>>> To update it from a web site you will need to know something about >>>> a web language or two (like ASP/ASP.Net), Have access to an IIS web >>>> server so you can set everything but after the initial fan-fair it >>>> is fairly straight forward. >>>> >>>> Jim >>>> >>>> -----Original Message----- >>>> From: accessd-bounces at databaseadvisors.com >>>> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark A >>>> Matte >>>> Sent: Tuesday, December 04, 2007 11:23 AM >>>> To: Access Developers discussion and problem solving >>>> Subject: [AccessD] HTML page updating Access db >>>> >>>> >>>> Hello All, >>>> >>>> I need a down and dirty...doesn't have to be pretty...solution...we >>>> need about 15 people to run through some records...and change about >>>> 4 fields in each record(the change depends on individual >>>> conversation...cannot automate). >>>> >>>> These users do NOT have MS Access(where data currently resides). I >>>> know >>>> (barely) how to link to this data and display it in HTML...but I >>>> don't know how to update it from HTML...any suggestions on crash >>>> course web sites...or anyone have an example? >>>> >>>> Thanks, >>>> >>>> Mark A. Matte >>>> _________________________________________________________________ >>>> Share life as it happens with the new Windows Live.Download today >>>> it's >>> FREE! >>>> http://www.windowslive.com/share.html?ocid=TXT_TAGLM_Wave2_sharelif >>>> e >>>> _ >>>> 1 >>>> 12007 >>>> -- >>>> AccessD mailing list >>>> AccessD at databaseadvisors.com >>>> http://databaseadvisors.com/mailman/listinfo/accessd >>>> Website: http://www.databaseadvisors.com >>>> >>>> -- >>>> AccessD mailing list >>>> AccessD at databaseadvisors.com >>>> http://databaseadvisors.com/mailman/listinfo/accessd >>>> Website: http://www.databaseadvisors.com >>> >>> _________________________________________________________________ >>> Put your friends on the big screen with Windows VistaR + Windows LiveT. >>> http://www.microsoft.com/windows/shop/specialoffers.mspx?ocid=TXT_TA >>> G >>> L >>> M_CPC_ >>> MediaCtr_bigscreen_102007 >>> -- >>> AccessD mailing list >>> AccessD at databaseadvisors.com >>> http://databaseadvisors.com/mailman/listinfo/accessd >>> Website: http://www.databaseadvisors.com >>> >>> -- >>> AccessD mailing list >>> AccessD at databaseadvisors.com >>> http://databaseadvisors.com/mailman/listinfo/accessd >>> Website: http://www.databaseadvisors.com >> >> _________________________________________________________________ >> Connect and share in new ways with Windows Live. >> http://www.windowslive.com/connect.html?ocid=TXT_TAGLM_Wave2_newways_ >> 1 >> 12007 >> -- >> AccessD mailing list >> AccessD at databaseadvisors.com >> http://databaseadvisors.com/mailman/listinfo/accessd >> Website: http://www.databaseadvisors.com >> >> -- >> AccessD mailing list >> AccessD at databaseadvisors.com >> http://databaseadvisors.com/mailman/listinfo/accessd >> Website: http://www.databaseadvisors.com > > _________________________________________________________________ > Share life as it happens with the new Windows Live.Download today it's FREE! > http://www.windowslive.com/share.html?ocid=TXT_TAGLM_Wave2_sharelife_1 > 12007 > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com _________________________________________________________________ Put your friends on the big screen with Windows VistaR + Windows LiveT. http://www.microsoft.com/windows/shop/specialoffers.mspx?ocid=TXT_TAGLM_CPC_ MediaCtr_bigscreen_102007 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com