Thread: Access Database Editor

  1. #1
    Registered User Grayson_Peddie's Avatar
    Join Date
    May 2002
    Posts
    96

    Access Database Editor

    Hi. I'm looking for a database editor and I'm in a tight budget. Is there any database editors that were similar to Microsoft Access? A database editor without a wizard is okay for me, by the way, since I just want to create databases for my web site. (I use Visual C# .net to create .net web sites.)
    View in Braille.
    http://www.future-gpnet.com/braille.jpg

    Like a bolt out of the BLUE,
    Fate steps up and sees you THROUGH,
    When you wish upon a STAR
    YOUR DREAMS COME TRUE.

  2. #2
    Me -=SoKrA=-'s Avatar
    Join Date
    Oct 2002
    Location
    Europe
    Posts
    448
    You use C# to crate websites? You're crazy!
    Anyway, if you can use php, there's something called phpMyAdmin which can be used as a front-end for MySQL databses.
    SoKrA-BTS "Judge not the program I made, but the one I've yet to code"
    I say what I say, I mean what I mean.
    IDE: emacs + make + gcc and proud of it.

  3. #3
    Registered User Grayson_Peddie's Avatar
    Join Date
    May 2002
    Posts
    96
    My web server doesn't have support for SQL (only Access) but I got OpenOffice. Thanks for your help.
    View in Braille.
    http://www.future-gpnet.com/braille.jpg

    Like a bolt out of the BLUE,
    Fate steps up and sees you THROUGH,
    When you wish upon a STAR
    YOUR DREAMS COME TRUE.

  4. #4
    Me -=SoKrA=-'s Avatar
    Join Date
    Oct 2002
    Location
    Europe
    Posts
    448
    At first I read Acess as a verb, rather than the db app, which is why I pointed you to phpMyAdmin.
    I wouldn't think microsoft'd give front-end away, but you might get lucky.
    SoKrA-BTS "Judge not the program I made, but the one I've yet to code"
    I say what I say, I mean what I mean.
    IDE: emacs + make + gcc and proud of it.

  5. #5
    Registered User Grayson_Peddie's Avatar
    Join Date
    May 2002
    Posts
    96
    The *.mdb is a Microsoft Access Database file.
    View in Braille.
    http://www.future-gpnet.com/braille.jpg

    Like a bolt out of the BLUE,
    Fate steps up and sees you THROUGH,
    When you wish upon a STAR
    YOUR DREAMS COME TRUE.

  6. #6
    5|-|1+|-|34|) ober's Avatar
    Join Date
    Aug 2001
    Posts
    4,429
    what server are you using and why are they only allowing you to use access dbs? (btw, I find this hard to believe because few people in their normal state of mind would want to use Access for a web database.

    Do yourself a favor. STFW for tutorials on PHP and MySQL. Both would be free for you to use and as long as your server supports both, you should be good to go. (And as long as you're not trying to make a profit off of them)

    I've never heard of anyone interfacing with an Access DB across the web. It just seems ridiculous.

  7. #7
    Registered User Grayson_Peddie's Avatar
    Join Date
    May 2002
    Posts
    96
    I only use Visual C# to create web sites and I don't know if MySQL will work with the server since my web server (UpLinkEarth.com) only support Access. My web hosting provider, UpLinkEarth might support SQL in the future but I don't know when. Also, I don't think that Visual C# supports PHP but I will try it out.

    Thanks for your help.
    View in Braille.
    http://www.future-gpnet.com/braille.jpg

    Like a bolt out of the BLUE,
    Fate steps up and sees you THROUGH,
    When you wish upon a STAR
    YOUR DREAMS COME TRUE.

  8. #8
    5|-|1+|-|34|) ober's Avatar
    Join Date
    Aug 2001
    Posts
    4,429
    Here's a thought. Stop using Visual C# to make websites. Why not use plain old html and PHP???? I don't even understand how you're making a website with Visual C#. wtf.

    If your provider doesn't support SQL servers like MySQL then maybe you should find a new provider.

  9. #9
    Registered User Grayson_Peddie's Avatar
    Join Date
    May 2002
    Posts
    96
    I suck at HTML. The reason I don't like HTML is HTML is hard for me because of < and >. With HTML, I tend to type slow.

    I chose ASP.net over PHP because ASP.net supports about 25 languages. And so, I chose C# because C# is a lot easier to learn than HTML/PHP.

    Take a look at this:
    http://www.hands-on-labs.com/only4gu...ft/php_asp.pdf

    I only stay with C#.
    Last edited by Grayson_Peddie; 01-04-2004 at 02:33 PM.
    View in Braille.
    http://www.future-gpnet.com/braille.jpg

    Like a bolt out of the BLUE,
    Fate steps up and sees you THROUGH,
    When you wish upon a STAR
    YOUR DREAMS COME TRUE.

  10. #10
    PC Fixer-Upper Waldo2k2's Avatar
    Join Date
    May 2002
    Posts
    2,001
    >>I only stay with C#.



    a programming angel just lost it's wings....I love php
    PHP and XML
    Let's talk about SAX

  11. #11
    Registered User
    Join Date
    Jun 2002
    Posts
    25
    've never heard of anyone interfacing with an Access DB across the web. It just seems ridiculous.
    Unfortunately, it's all too common.

  12. #12
    'AlHamdulillah
    Join Date
    Feb 2003
    Posts
    790
    Unfortunately, it's all too common.
    yes, I had a computer science lab prof. who thought MS office products were great... I am so glad that most of my CS prof. absolutely hate MS.

  13. #13
    Me -=SoKrA=-'s Avatar
    Join Date
    Oct 2002
    Location
    Europe
    Posts
    448
    >>I had a computer science lab prof. who thought
    >>MS office products were great...
    Mine told us to do modular design with Word because he couldn't install a CAD program the school bought. Terrible
    I think absoultely hating MS is a bit extreme, algthough it opens a lot of possiblities.
    SoKrA-BTS "Judge not the program I made, but the one I've yet to code"
    I say what I say, I mean what I mean.
    IDE: emacs + make + gcc and proud of it.

  14. #14
    5|-|1+|-|34|) ober's Avatar
    Join Date
    Aug 2001
    Posts
    4,429
    Originally posted by Grayson_Peddie
    I suck at HTML. The reason I don't like HTML is HTML is hard for me because of < and >. With HTML, I tend to type slow.

    I chose ASP.net over PHP because ASP.net supports about 25 languages. And so, I chose C# because C# is a lot easier to learn than HTML/PHP.
    I'm sorry, but you cannot be serious. It is web developers like yourself that seriously ........ me off. HTML has got to be one of the easiest things to learn. It's a couple tags. If you said you had a problem learning Javascript, then I might consider you somewhat useful, but give me a break. And PHP? It doesn't get much easier than PHP for scripting.

    ASP restricts you to windows based servers. What if your provider decides to switch to all linux machines? You will be F-ed, my friend.

    And I don't know C#, but I have a feeling it is harder to learn than HTML and PHP.

  15. #15
    Registered User Grayson_Peddie's Avatar
    Join Date
    May 2002
    Posts
    96
    Just to show you my proof that C# is a lot easier to code and read than HTML, I found C# easier to read than HTML. And my web hosting provider uses Microsoft Windows. I don't use Linux (I don't like Linux that much).

    Here's what I do when I create a simple web page.

    In Visual C# .net, I create a new ASP.net template project.

    Let's say that I want to create a listbox with a textbox, Add, Remove, Remove All, and a status label.

    I give the following ID to each of the controls:

    Textbox: txtItemName
    Button: btnAdd
    ListBox: lbItems
    Button: btnRemove
    Button: btnRemoveAll
    Label: lblStatusInfo

    When you first double-click the control, VC# creates a code automatically. For example, if I double-click Add, I will see this:

    Code:
    private void btnAdd_Clicked(object sender, System.EventArgs e)
    {
        
    }
    Visual C# had also added the code for the web form designer:

    Code:
    this.btnAdd.Clicked += new System.EventHandler(this.btnAdd_Clicked);
    The code that start with "this.btnAdd.Clicked" executes the code:

    Code:
    private void btnAdd_Clicked(object sender, System.EventArgs e)
    {
        
    }
    ...when a user clicks a button.

    Since the add button is for adding the name of the text from txtItemName, I add the code inside the btnAdd_Clicked() function:

    Code:
    private void btnAdd_Clicked(object sender, System.EventArgs e)
    {
        if(txtItemName.Text != "")
        {
            lbItems.Items.Add(txtItemName.Text);
            lblStatusInfo.Text = "You have added " + txtItemName.Text +
                " to the list.";
            btnRemove.Enabled = true;
            btnRemoveAll.Enabled = true;
        }
        else
        {
            lblStatusInfo.Text = "No name in the text box.";
        }
    What this does is when you click the Add button, it copies from txtItemName into lblItems' list box. The lblStatusInfo lets a user know that s/he had added an item to the list. But if there's no text in the txtItemName text box, lblStatusInfo will mention "No name in the text box." Pretty simple.

    Here's the code for the Remove button, btnRemove:

    Code:
            private void btnRemove_Click(object sender, System.EventArgs e)
            {
                string GetItem;
                try
                {
                    if(lbItems.SelectedIndex != 0)
                    {
                        GetItem = lbItems.SelectedItem.Text.ToString();
                        lbItems.Items.Remove(lbItems.SelectedItem.Text);
                    }
                    else
                    {
                        lblStatusInfo.Text = "You need to select an item" +
                            " from the list.";
                    }
                }
                catch
                {
                    lblStatusInfo.Text = "You have removed " + GetItem +
                        "from the list.";
                }
                if(lbItems.Items.Count == 0)
                {
                    btnRemove.Enabled = false;
                    btnRemoveAll.Enabled = false;
                }
            }
    This code, when you press Remove after you select (or if you don't select) an item, handles the exception. The web page will generate an error if you don't select an item. Of course, if there's no items in the list, two buttons: Remove and Remove All, will be disabled.

    The third, and last button called Remove All (btnRemoveAll), removes all the items in the list. This is a very simple code.

    Code:
           private void btnRemoveAll_Click(object sender, System.EventArgs e)
            {
                if(lbItems.Items.Count != 0)
                {
                    lbItems.Items.Clear();
                    lblStatusInfo.Text = "You have removed all the items" +
                        " from the list.";
                }
                btnRemove.Enabled = false;
                btnRemoveAll.Enabled = false;
            }
    Here's the full source code in C#:

    Code:
    using System;
    using System.Collections;
    using System.ComponentModel;
    using System.Data;
    using System.Drawing;
    using System.Web;
    using System.Web.SessionState;
    using System.Web.UI;
    using System.Web.UI.WebControls;
    using System.Web.UI.HtmlControls;
    
    namespace www.future_gpnet.com
    {
        /// <summary>
        /// Summary description for Sampler.
        /// </summary>
        public class Sampler : System.Web.UI.Page
        {
            protected System.Web.UI.WebControls.Label Label1;
            protected System.Web.UI.WebControls.Button btnAdd;
            protected System.Web.UI.WebControls.ListBox lbItems;
            protected System.Web.UI.WebControls.Button btnRemove;
            protected System.Web.UI.WebControls.TextBox txtItemName;
            protected System.Web.UI.WebControls.Label lblStatusInfo;
            protected System.Web.UI.WebControls.Button btnRemoveAll;
        
            private void Page_Load(object sender, System.EventArgs e)
            {
                // Put user code to initialize the page here
            }
    
            #region Web Form Designer generated code
            override protected void OnInit(EventArgs e)
            {
                //
                // CODEGEN: This call is required by the ASP.NET Web Form Designer.
                //
                InitializeComponent();
                base.OnInit(e);
            }
            
            /// <summary>
            /// Required method for Designer support - do not modify
            /// the contents of this method with the code editor.
            /// </summary>
            private void InitializeComponent()
            {    
                this.btnAdd.Click += new System.EventHandler(this.btnAdd_Click);
                this.btnRemove.Click += new System.EventHandler(this.btnRemove_Click);
                this.btnRemoveAll.Click += new System.EventHandler(this.btnRemoveAll_Click);
                this.Load += new System.EventHandler(this.Page_Load);
    
            }
    		#endregion
    
            private void btnAdd_Click(object sender, System.EventArgs e)
            {
                if(txtItemName.Text != "")
                {
                    lbItems.Items.Add(txtItemName.Text);
                    lblStatusInfo.Text = "You have added " + txtItemName.Text +
                        " to the list.";
                    btnRemove.Enabled = true;
                    btnRemoveAll.Enabled = true;
                }
                else
                {
                    lblStatusInfo.Text = "No name in the text box.";
                }
            }
    
            string GetItem;
            private void btnRemove_Click(object sender, System.EventArgs e)
            {
                try
                {
                    GetItem = lbItems.SelectedItem.Text.ToString();
                    lbItems.Items.Remove(lbItems.SelectedItem.Text);
                    lblStatusInfo.Text = "You have removed " + GetItem +
                        " from the list.";
                }
                catch
                {
                    lblStatusInfo.Text = "You need to select an item" +
                        " from the list.";
                }
                if(lbItems.Items.Count == 0)
                {
                    btnRemove.Enabled = false;
                    btnRemoveAll.Enabled = false;
                }
            }
    
            private void btnRemoveAll_Click(object sender, System.EventArgs e)
            {
                if(lbItems.Items.Count != 0)
                {
                    lbItems.Items.Clear();
                    lblStatusInfo.Text = "You have removed all the items" +
                        " from the list.";
                }
                btnRemove.Enabled = false;
                btnRemoveAll.Enabled = false;
            }
        }
    }
    Here's the source code generated by Visual C# .net:

    Code:
    <%@ Page language="c#" Codebehind="Sampler.aspx.cs" AutoEventWireup="false" Inherits="www.future_gpnet.com.Sampler" %>
    <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
    <HTML>
        <HEAD>
            <title>Sampler</title>
            <meta name="GENERATOR" Content="Microsoft Visual Studio 7.0">
            <meta name="CODE_LANGUAGE" Content="C#">
            <meta name="vs_defaultClientScript" content="JavaScript">
            <meta name="vs_targetSchema" content="http://schemas.microsoft.com/intellisense/ie5">
        </HEAD>
        <body MS_POSITIONING="GridLayout" text="white" bgColor="black">
            <form id="Sampler" method="post" runat="server">
                <asp:Label id="Label1" style="Z-INDEX: 101; LEFT: 15px; POSITION: absolute; TOP: 11px" runat="server" Width="331px" Height="19px">Enter an item in the text box below and click Add to add an item to the list</asp:Label>
                <asp:Button id="btnRemoveAll" style="Z-INDEX: 106; LEFT: 334px; POSITION: absolute; TOP: 120px" runat="server" Width="92px" BackColor="#C00000" ForeColor="White" Text="Remove All"></asp:Button>
                <asp:TextBox id="txtItemName" style="Z-INDEX: 102; LEFT: 17px; POSITION: absolute; TOP: 59px" runat="server" Width="315px" Height="23px" BackColor="Black" ForeColor="White"></asp:TextBox>
                <asp:Button id="btnAdd" style="Z-INDEX: 103; LEFT: 333px; POSITION: absolute; TOP: 59px" runat="server" Width="92px" BackColor="Green" Text="Add"></asp:Button>
                <asp:ListBox id="lbItems" style="Z-INDEX: 104; LEFT: 17px; POSITION: absolute; TOP: 87px" runat="server" Width="316px" Height="220px" BackColor="Black" ForeColor="White">
                    <asp:ListItem Value="Made by Grayson Peddie">Made by Grayson Peddie</asp:ListItem>
                    <asp:ListItem Value="Used with Visual C# .net">Used with Visual C# .net</asp:ListItem>
                </asp:ListBox>
                <asp:Button id="btnRemove" style="Z-INDEX: 105; LEFT: 334px; POSITION: absolute; TOP: 89px" runat="server" Width="92px" BackColor="#C00000" ForeColor="White" Text="Remove"></asp:Button>
                <asp:Label id="lblStatusInfo" style="Z-INDEX: 107; LEFT: 18px; POSITION: absolute; TOP: 306px" runat="server" Width="317px" Height="71px"></asp:Label>
            </form>
        </body>
    </HTML>
    This is an ASP.net code, by the way.

    Why don't you try out my sample just to give you a feel of how ASP.net and C# works? Here's the link:
    http://www.future-gpnet.com/Sampler.aspx
    View in Braille.
    http://www.future-gpnet.com/braille.jpg

    Like a bolt out of the BLUE,
    Fate steps up and sees you THROUGH,
    When you wish upon a STAR
    YOUR DREAMS COME TRUE.

Popular pages Recent additions subscribe to a feed

Similar Threads

  1. How to add a database from access in c++
    By m_abdelghani in forum Windows Programming
    Replies: 7
    Last Post: 03-24-2005, 08:19 AM
  2. CGI with MS Access database integration
    By Tarran in forum Tech Board
    Replies: 12
    Last Post: 01-11-2005, 09:47 AM
  3. connecting to ms access database
    By fkheng in forum Windows Programming
    Replies: 12
    Last Post: 07-06-2003, 07:49 PM
  4. Mfc Dao Access Database
    By LISANANA in forum Windows Programming
    Replies: 1
    Last Post: 07-03-2003, 01:18 PM