[AccessD] HTML page updating Access db

Mark A Matte markamatte at hotmail.com
Wed Dec 5 16:06:36 CST 2007


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_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_TAG
>>> 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_112007
> --
> 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 Vista® + Windows Live™.
http://www.microsoft.com/windows/shop/specialoffers.mspx?ocid=TXT_TAGLM_CPC_MediaCtr_bigscreen_102007



More information about the AccessD mailing list