Pour info : darklord22, je ne sais pas si tu sais, mais avec access 2000, tu peux créer des pages WEB d'accès au données.
Cà ressemble à çà :
Code :
- <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
- <HTML XMLNS:o="urn:schemas-microsoft-com:office:office"
- XMLNS:x="urn:schemas-microsoft-com:office:excel"
- XMLNS:a="urn:schemas-microsoft-com:office:access"
- XMLNS:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882"><HEAD><LINK
- href="./Page1_fichiers/filelist.xml" rel=File-List
- type=text/xml><TITLE>p_phone</TITLE>
- <META content=Access.Application name=ProgId>
- <META name=VBSForEventHandlers VALUE="TRUE">
- <META content="text/html; charset=windows-1252" http-equiv=Content-Type>
- <STYLE id=MSODAPDEFAULTS type=text/css rel="stylesheet">.mstheme-label {
- FONT-FAMILY: Tahoma; FONT-SIZE: 8pt
- }
- TEXTAREA {
- FONT-FAMILY: Tahoma; FONT-SIZE: 8pt
- }
- .msoboundhtml {
- FONT-FAMILY: Tahoma; FONT-SIZE: 8pt
- }
- HR {
- COLOR: black
- }
- SELECT {
- FONT-FAMILY: Tahoma; FONT-SIZE: 8pt
- }
- INPUT {
- FONT-FAMILY: Tahoma; FONT-SIZE: 8pt
- }
- BODY {
- FONT-FAMILY: Tahoma; FONT-SIZE: 10pt
- }
- MARQUEE {
- FONT-FAMILY: Tahoma; FONT-SIZE: 8pt
- }
- LEGEND {
- FONT-FAMILY: Tahoma; FONT-SIZE: 8pt
- }
- .msoHyperlinkDisplayText {
- FONT-FAMILY: Tahoma; FONT-SIZE: 8pt
- }
- BUTTON {
- FONT-FAMILY: Tahoma; FONT-SIZE: 8pt
- }
- .MsoShowDesignGrid {
- BEHAVIOR: url(#DEFAULT#MsoShowDesignGrid)
- }
- </STYLE>
- <OBJECT classid=CLSID:0002E530-0000-0000-C000-000000000046
- codeBase=file:msowc.cab id=MSODSC><PARAM NAME="XMLData" VALUE="<xml xmlns:a="urn:schemas-microsoft-com:office:access">
<a:DataSourceControl>
<a:OWCVersion>9.0.0.3821</a:OWCVersion>
<a:ConnectionString>Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=C:\Documents and Settings\fsurleau\Mes documents\bd1.mdb;Mode=Share Deny None;Jet OLEDB:System database="";Jet OLEDB:Database Password=""</a:ConnectionString>
<a:MaxRecords>10000</a:MaxRecords>
<a:GridX>10</a:GridX>
<a:GridY>10</a:GridY>
<a:ElementExtension>
<a:ElementID>phoneDéplacement</a:ElementID>
<a:ConsumesRecordset/>
</a:ElementExtension>
<a:ElementExtension>
<a:ElementID>nom</a:ElementID>
<a:ControlSource>nom</a:ControlSource>
<a:ChildLabel>nom_Étiquette</a:ChildLabel>
</a:ElementExtension>
<a:ElementExtension>
<a:ElementID>prenom</a:ElementID>
<a:ControlSource>prenom</a:ControlSource>
<a:ChildLabel>prenom_Étiquette</a:ChildLabel>
</a:ElementExtension>
<a:ElementExtension>
<a:ElementID>id</a:ElementID>
<a:ControlSource>id</a:ControlSource>
<a:ChildLabel>id_Étiquette</a:ChildLabel>
</a:ElementExtension>
<a:ElementExtension>
<a:ElementID>tel</a:ElementID>
<a:ControlSource>tel</a:ControlSource>
<a:ChildLabel>tel_Étiquette</a:ChildLabel>
</a:ElementExtension>
<a:GroupLevel>
<a:RecordSource>phone</a:RecordSource>
<a:DefaultSort>[nom] ASC, [prenom] ASC</a:DefaultSort>
<a:HeaderElementId>En-têtephone</a:HeaderElementId>
<a:FooterElementId></a:FooterElementId>
<a:CaptionElementId></a:CaptionElementId>
<a:RecordNavigationElementId>SectionDéplacementphone</a:RecordNavigationElementId>
<a:DataPageSize>1</a:DataPageSize>
</a:GroupLevel>
<a:Datamodel version="0816">
<a:SchemaRowsource id="phone" type="dscTable">
<a:SchemaField id="id" datatype="3" size="0" iskey="1"/>
<a:SchemaField id="nom" datatype="202" size="50"/>
<a:SchemaField id="prenom" datatype="202" size="50"/>
<a:SchemaField id="tel" datatype="202" size="50"/>
</a:SchemaRowsource>
<a:RecordsetDef id="phone">
<a:PageField id="id"/>
<a:PageField id="nom"/>
<a:PageField id="prenom"/>
<a:PageField id="tel"/>
</a:RecordsetDef>
</a:Datamodel>
</a:DataSourceControl>
</xml>'""></OBJECT>
- <META content="MSHTML 5.00.3103.1000" name=GENERATOR><!--[if gte mso 9]><xml>
- <o:DocumentProperties>
- <o:Author>FSURLEAU</o:Author>
- <o:LastAuthor>FSURLEAU</o:LastAuthor>
- <o:Revision>1</o:Revision>
- <o:TotalTime>0</o:TotalTime>
- <o:Created>2002-01-25T12:10:57Z</o:Created>
- <o:LastSaved>2002-01-25T12:11:30Z</o:LastSaved>
- <o:Company>ATOS ORIGIN</o:Company>
- <o:Version>9.3821</o:Version>
- </o:DocumentProperties>
- <o:OfficeDocumentSettings>
- <o:DownloadComponents/>
- <o:LocationOfComponents HRef="file:msowc.cab"/>
- </o:OfficeDocumentSettings>
- </xml><![endif]--></HEAD>
- <BODY bottomMargin=48 leftMargin=24 link=#800080 rightMargin=24
- style="OVERFLOW: auto" topMargin=24 vLink=#800080>
- <CENTER>
- <H1 id=TexteEnTête style="FONT-WEIGHT: normal">Téléphones </H1></CENTER>
- <P> </P>
- <DIV class=MicrosoftAccessBanner id=En-têtephoneBanner
- style="BACKGROUND-COLOR: buttonface; BORDER-BOTTOM: buttonhighlight 2px outset; BORDER-LEFT: buttonhighlight 2px outset; BORDER-RIGHT: buttonhighlight 2px outset; BORDER-TOP: buttonhighlight 2px outset; DISPLAY: none; FONT-FAMILY: Tahoma; FONT-SIZE: 8pt; FONT-WEIGHT: normal; HEIGHT: 0.507cm; OVERFLOW: hidden; PADDING-LEFT: 1px; WIDTH: 410px">En-tête:
- phone</DIV>
- <DIV class=MSOShowDesignGrid id=En-têtephone
- style="BACKGROUND-COLOR: transparent; HEIGHT: 2.065cm; OVERFLOW: hidden; POSITION: relative; VISIBILITY: hidden; WIDTH: 410px"><SPAN
- class=MSTheme-Label id=nom_Étiquette
- style="HEIGHT: 0.45cm; LEFT: 0.053cm; OVERFLOW: visible; PADDING-LEFT: 1px; POSITION: absolute; TOP: 0.053cm; WIDTH: 2.751cm"
- title=nom>nom</SPAN><TEXTAREA id=nom style="HEIGHT: 0.45cm; LEFT: 2.804cm; OVERFLOW: hidden; POSITION: absolute; TOP: 0.053cm; WIDTH: 4.074cm" tabIndex=1 title=nom></TEXTAREA><SPAN
- class=MSTheme-Label id=prenom_Étiquette
- style="HEIGHT: 0.45cm; LEFT: 0.053cm; OVERFLOW: visible; PADDING-LEFT: 1px; POSITION: absolute; TOP: 0.556cm; WIDTH: 2.751cm"
- title=prenom>prenom</SPAN><TEXTAREA id=prenom style="HEIGHT: 0.45cm; LEFT: 2.804cm; OVERFLOW: hidden; POSITION: absolute; TOP: 0.556cm; WIDTH: 4.074cm" tabIndex=2 title=prenom></TEXTAREA><SPAN
- class=MSTheme-Label id=id_Étiquette
- style="HEIGHT: 0.45cm; LEFT: 0.053cm; OVERFLOW: visible; PADDING-LEFT: 1px; POSITION: absolute; TOP: 1.113cm; WIDTH: 2.751cm"
- title=id>id</SPAN><TEXTAREA id=id style="HEIGHT: 0.45cm; LEFT: 2.804cm; OVERFLOW: hidden; POSITION: absolute; TOP: 1.113cm; WIDTH: 4.074cm" tabIndex=3 title=id></TEXTAREA><SPAN
- class=MSTheme-Label id=tel_Étiquette
- style="HEIGHT: 0.45cm; LEFT: 0.053cm; OVERFLOW: visible; PADDING-LEFT: 1px; POSITION: absolute; TOP: 1.562cm; WIDTH: 2.751cm"
- title=tel>tel</SPAN><TEXTAREA id=tel style="HEIGHT: 0.45cm; LEFT: 2.804cm; OVERFLOW: hidden; POSITION: absolute; TOP: 1.562cm; WIDTH: 4.074cm" tabIndex=4 title=tel></TEXTAREA></DIV>
- <DIV class=MicrosoftAccessBanner id=SectionDéplacementphoneBanner
- style="BACKGROUND-COLOR: buttonface; BORDER-BOTTOM: buttonhighlight 2px outset; BORDER-LEFT: buttonhighlight 2px outset; BORDER-RIGHT: buttonhighlight 2px outset; BORDER-TOP: buttonhighlight 2px outset; DISPLAY: none; FONT-FAMILY: Tahoma; FONT-SIZE: 8pt; FONT-WEIGHT: normal; HEIGHT: 0.2in; OVERFLOW: hidden; PADDING-LEFT: 1px; WIDTH: 410px">SectionDéplacement:
- phone</DIV>
- <DIV class=MSOShowDesignGrid id=SectionDéplacementphone
- style="BACKGROUND-COLOR: transparent; HEIGHT: 35px; OVERFLOW: hidden; POSITION: relative; VISIBILITY: hidden; WIDTH: 410px">
- <OBJECT classid=CLSID:0002E531-0000-0000-C000-000000000046
- codeBase=file:msowc.cab id=phoneDéplacement
- style="LEFT: 8px; POSITION: absolute; TOP: 5px; WIDTH: 402px"><PARAM NAME="_State" VALUE=""><PARAM NAME="RecordSource" VALUE="phone"><PARAM NAME="RecordsetLabel" VALUE="phone |0 de |2;phone |0-|1 de |2"><PARAM NAME="ShowFirstButton" VALUE="-1"><PARAM NAME="ShowPrevButton" VALUE="-1"><PARAM NAME="ShowNextButton" VALUE="-1"><PARAM NAME="ShowLastButton" VALUE="-1"><PARAM NAME="ShowNewButton" VALUE="-1"><PARAM NAME="ShowDelButton" VALUE="-1"><PARAM NAME="ShowSaveButton" VALUE="-1"><PARAM NAME="ShowUndoButton" VALUE="-1"><PARAM NAME="ShowSortAscendingButton" VALUE="-1"><PARAM NAME="ShowSortDecendingButton" VALUE="-1"><PARAM NAME="ShowApplyFilterButton" VALUE="-1"><PARAM NAME="ShowToggleFilterButton" VALUE="-1"><PARAM NAME="ShowHelpButton" VALUE="-1"><PARAM NAME="ShowLabel" VALUE="-1"><PARAM NAME="FontName" VALUE="Tahoma"></OBJECT></DIV>
- <P> </P></BODY></HTML>
|
C'est pas beau hein !
Maintenant, j'y connais rien. J'ai fais un test en local qui fonctionne. Je suppose que sur un réseau local çà doit pouvoir fonctionner, mais j'en sais pas plus.
Transformer des Formulaires en Pages WEB "Access 2000, je sais pas si c'est possible.
Quand à le faire sur une version "Executable" ? ? ?
---------------
Laissez l'Etat dans les toilettes où vous l'avez trouvé.