[AccessD] HTML page updating Access db

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




More information about the AccessD mailing list