Question about Microsoft Office Standard for PC

3 Answers

Connectivity between HTML page and Ms-Access

I want to inser t tha data in Ms-Access with the HTML page . i create a page that is ... field are ...name and paaword and this information are stored in data base with the help of Submit button.......

Posted by on

  • 7 more comments 
  • Anonymous Nov 20, 2008

    i dnt knw how we can join access with html

  • Anonymous Dec 01, 2008

    How can I create submit button in HTML or ACCESS for the Visual Basic project? I have project frontend with VB and I want backend with either Html or Access.

  • sumititpro Jan 12, 2009

    i am not able 2 connect my access database with HTML

  • sumititpro Jan 12, 2009

    could we connect HTML and excel spread sheet plz help me if u anybody have done this..

  • prasanthi89 Feb 05, 2009

    I writing a prog for house tax maintenance.. i dono how to connect the MS access database with the html.. its very urgent.... plss help..

  • amjad92 Mar 28, 2009

    web form pages field wise connectuvity with access and how to a login password and id

  • deepu_sonia Apr 01, 2009

    Respected sir/madam i am creating a form wth headings First name Last name,emailid,***-male/female,country region i want to store this information when i fill this form. in ms access

  • prav_111 Apr 23, 2009

    I want to learn that how can i connect my HTML page with my DATABASE created in MS ACCESS so that i can fill my table in HTML page directly

  • Anonymous May 12, 2009

    connectivity between HTML page and Ms-Access

×

3 Answers

  • Level 1:

    An expert who has achieved level 1.

    Corporal:

    An expert that has over 10 points.

    Mayor:

    An expert whose answer got voted for 2 times.

  • Contributor
  • 1 Answer

<HTML>
<BODY>
<%
Set MyConn = Server.CreateObject("ADODB.Connection")
MdbFilePath = Server.MapPath("sample.mdb")
MyConn.Open "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & MdbFilePath & ";"
SQL_query = "SELECT * FROM Friends"
Set RS = MyConn.Execute(SQL_query)
WHILE NOT RS.EOF
%>
<LI><%=RS("Name")%>: <A HREF="<%=RS("Link")%>">Homepage</A>
<%
RS.MoveNext
WEND
%>
</BODY>
</HTML>

Posted on Apr 22, 2009

  • Level 1:

    An expert who has achieved level 1.

    Hot-Shot:

    An expert who has answered 20 questions.

    Corporal:

    An expert that has over 10 points.

    Mayor:

    An expert whose answer got voted for 2 times.

  • Contributor
  • 57 Answers

You can do this using lower version of Ms Access like 2000 or 2002 version but not in Access 2007. you can create a page at ms access as your data form to insert data to ms access table and when you save it create an external page file that you can open outside access program.

Posted on Nov 22, 2008

  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 1 Answer

Hi! how to connect in ms access from html using in form?

Posted on Jul 04, 2013

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

How to invoke a ms.access using parser


To parse a Text field that contains two words separated by a comma, follow these steps:
  1. Open any existing database.
  2. Create a table with the following structure: Table: Parse2Words
    ------------------
    Field Name: Empl
    Data Type: Text
  3. View the Parse2Words table in Datasheet view and type the following three records in the Empl field: Smith, John
    Callahan, Laura
    Fuller, Andrew
  4. Create the following query based on the Parse2Words table: Query: QueryTest
    ------------------------------------------------------------------
    Field: FirstName: Right$([Empl],Len([Empl])- InStr(1,[Empl],",")-1)
    Show: True
    Field: LastName: Left$([Empl],InStr(1,[Empl],",")-1)
    Show: True

    NOTE: You can modify the QueryTest query to account for spaces between the two parts in the Empl field. For example, if the text in the Empl field is "Smith,John" without spaces, remove the -1 from the FirstName field expression.
  5. Run the query. Note that the QueryTest query separates the text in the Empl field into the two fields below: FirstName LastName
    --------------------
    John Smith
    Laura Callahan
    Andrew Fuller

Jan 08, 2011 | Microsoft Office Access 2003 (077-02871)...

1 Answer

I want to learn that how can i connect my HTML page with my DATABASE created in MS ACCESS so that i can fill my table in HTML page directly-


1. You can use Pages option in MS Access. The page in MS Access is the web page in MS Access which allows you to access database in MS Access database.

2. You can use MS Office Front Page application and use the Form builder and connect your database in that.

3. You can also use Google Apps Business Solution for this however the database will not remain in MS Access but will remain in Docs online.

4. You can use .net application developer for this as well but needs expertise in that.

Mar 09, 2010 | Microsoft Office Standard for PC

1 Answer

I have DataBase in MS Access But I want connect it to my HTML Page for Add, Edit, Save date in access through HTML Page-


Under the pages tab in the Database window is a wizard that will walk you through creating the page. You can then copy the code or tweak it as you need to. If you do this and want to continue to mange using forms however, you may want to split your database. that means load all the forms in one file and link them to the tables in another. There is a tool to do this automatically under TOOLS > Database Utilities > Database Splitter.

Mar 08, 2010 | Microsoft Office Standard for PC

1 Answer

Connection between html and ms access


HTML page is static, means it will not interact with the database. It just shows what has been written to it.

Regarding your question, you have to use server-side scripting i.e. JSP/Servlet, ASP.NET, PHP etc.

To learn more about server-side programming see the below site.
http://en.wikipedia.org/wiki/Server_side_scripting

Sep 21, 2009 | Microsoft Office Standard for PC

1 Answer

How should i connect html page to MS Access


You have to create adodb.connection to connect the ms acesss database to web page

Jan 20, 2009 | Microsoft Office Standard for PC

1 Answer

How i create a data base in ms access


Hello,
Start, Programs, Microsoft Office, Microsoft Office Access 2007. Click the Office Icon in the top left corner of the Access 2007 window. Click New, locate where it says "Blank Database". In the field labeled "File Name", type the name of your new database. To choose a folder on your computer to save the new database, click on the folder icon next to the "File Name" field, and select the folder, then click Ok. Then click "Create".
Please let me know if this helps or if you have any questions.
Thank You, Raphael

Sep 08, 2008 | Microsoft Office Professional 2007 Full...

1 Answer

How to use passwd character in a table in ms-access 2003


When you create table where you want to store passwords, go to Edit Table, then select a field where the password will be stored, go to Input Mask field in Properties and type Password in that field. That will set up the field needed for storing passwords.

Aug 18, 2008 | Microsoft Office Access 2003 (077-02871)...

1 Answer

Hyperlink function in ms access


To Create a Hyperlink Field:


Display the table in Design view, create a new field to store the hyperlinks, click the new hyperlink field's Data Type box, click the list arrow, select Hyperlink, and save the table.
To Insert a Hyperlink:

Select the hyperlink field and then click the Insert Hyperlink button on the toolbar or select Insert , Hyperlink from the menu. Either select a file you want (use the Browse button to help you locate the file) or type a Web address for the hyperlink's destination and click OK.

To edit a Hyperlink: Right-click the hyperlink and select Hyperlink , Edit Hyperlink from the shortcut menu.


Is this enough?

Dec 21, 2007 | Microsoft Office Access 2003 (077-02871)...

3 Answers

Connecting html form to Ms-access data base


If, as I suspect, this is for a web form, then it effectively can't be done on a "proper" web server. This is because you cannot install MS Office on an MS server OS (e.g. Server 2003). You need to use MS SQL Server or MySQL instead. If this is for very limited use (i.e. only a few clients at a time), you can use XP running IIS but this is really not a good idea. The sedurity implications don't bear thinking about :) Linking a web page to Access can probably be done using ASP (never even thought of trying it - anyone else here know for sure?) If you are using a Linux web server then it's totally out of the question. Use Webmin or PHPMySQL to set up a MySQL database & PHP to code the linkage between the page and the DB. There are plenty of tools out there that will automate this for you, some of them Open Source and therefore free to acquire.

Sep 26, 2007 | Microsoft Office Standard for PC

Not finding what you are looking for?
Microsoft Office Standard for PC Logo

6,480 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18297 Answers

Sudeep Chatterjee
Sudeep Chatterjee

Level 3 Expert

3267 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...