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

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

1 Answer

Can u plz mail me tha easiest way to use Ms Access, like Creating relationship, with the table, creating form, query etc.


In general you initiate this process by pressing the "Relationships" button on the MS Access toolbar. It is the button with three small boxes arranged in a triangle shape.
rowell_randy_0.jpg

When it first comes up it will give you the option to add tables. You can add any set of tables including the possibility of adding one table more than once (you would do this if you wanted to create a relationship between fields in the same table).

Once you see the tables you're interested in, you simply drag the field from one table over a field in another table. The fields should be those that will define the relationship. Once done, you should see an Edit Relationships window. You can get back to the Edit Relationships window later by double clicking the line in the relationships window.
rowell_randy_1.jpg

MS Access does a good job of figuring out the relationship type. For example, if you match a field in one table, that is not a key, with a primary key in another table, Access will make this a Many-to-One relationship.

This can become a very deep subject. Hope this at least gets you in the right direction.

Dec 18, 2010 | Microsoft Computers & Internet

Tip

Set up a GPRS data connection for email Please note: Please note that you need a...


Set up a GPRS data connection for email info.png boxAdd('subj0', cBoxClosed);
Please note: Please note that you need a POP3 email account in order to send and receive email messages on your phone. You cannot access web-based email accounts (e.g. Hotmail accounts). 1 Find "Access points"
  • Press the menu icon.
  • Press the fourth tab.
  • Press Phone settings.
  • Press Connectivity.
  • Press Access points.
2 Create new or edit existing data connection
  • To create a new data connection:
  • Press Add.
  • To edit an existing data connection:
  • Press the required data connection.
  • Press the icon to the bottom left.
  • Press Edit.
  • Press the Connection title input field.
  • Press C to clear the input field.
  • Key in EMAIL GPRS and press OK.
3 Select data bearer
  • Press the Bearer drop down list.
  • Press UMTS or GPRS.
  • Press OK.
4 Select authentication
  • Press the Authentication drop down list.
  • Press PAP or CHAP.
  • Press OK.
5 Enter username
  • Press the Username input field.
  • Key in user and press OK.
6 Enter password
  • Press the Password input field.
  • Key in one2one and press OK.
boxAdd('info6', cBoxClosed); The APN name general.t-mobile.uk must be in lower case letters. 7 Enter APN name
  • Press the APN input field.
  • Key in general.t-mobile.uk and press OK.
8 Save and exit
  • Press Save.
  • Press Disconnect to return to stand-by mode.

on Apr 30, 2008 | LG KU990 Viewty

1 Answer

Different between MS EXCEL & ACCESS


Hi. MS Excel is for spreadsheet. Very useful when creating accounting documents. MS Access is for database. Very useful when collecting data.

Please visit these links to learn more about the 2 applications:
http://www.blurtit.com/q373300.html

http://office.microsoft.com/en-us/access-help/using-access-or-excel-to-manage-your-data-HA001042918.aspx

http://www.thetechfaq.com/2010/03/14/microsoftaccess-and-excel-comparison/

Sep 03, 2010 | Microsoft Windows XP Media Center Edition...

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

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 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,485 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2644 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18381 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...