Mark A Matte
markamatte at hotmail.com
Thu Dec 6 10:03:37 CST 2007
I found this: http://support.microsoft.com/kb/201990 Says we might have this type of problem if there isn't a PRIMARY KEY in the recordsource...works for me. Thanks, Mark > From: max.wanadoo at gmail.com > To: accessd at databaseadvisors.com > Date: Thu, 6 Dec 2007 07:22:59 +0000 > Subject: Re: [AccessD] HTML page updating Access db > > 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 > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com _________________________________________________________________ You keep typing, we keep giving. Download Messenger and join the i’m Initiative now. http://im.live.com/messenger/im/home/?source=TAGLM