Access :: Creating A Website Based On Database?

Oct 6, 2010

I have created a database in Access 2007 for a university. Now, a new functionallity is required. What I need to do is a search function where students can search the database online. Now, they can only search using a front-end which is read-only, but they need to use a computer with Microsoft Access (or Runtime) and they need to be connected to the back-end which is located on a server.

make the database to work online? I am a novice to web programming. Which is the easiest way and how do I start?

The database has fields with Attachments. The students can search the database and open Attachments connected to the found posts, this part needs to be online. The personnel can edit and add data using a more complex front-end. This does not need to be online, they can still use Access.

View 2 Replies


Similar Messages:

C# - Creating A Subscription Based Website?

Apr 12, 2010

I'd like to update my website to make it subscription based. It's a ASP.NET Web forms project. I am looking for the following functionality:

Ability to have users sign up for
different plans (Gold, Premium etc)
Ability to have users upgrade /
downgrade to and from plans
Ability to hook this up to a Payment
processor
Ability to have a credit based
system (User buys x credits for $y)
as an alternative to plans in (1)

Most of this functionality (if not all) is supported by a large number of websites which makes me think I can leverage on an existing framework instead of re-inventing the wheel.

View 3 Replies

Access :: Creating Guid When Inserting Data To The MS Access Database?

Feb 11, 2010

I have one question here.I created a registration form using asp.net and c#.

when I entered all the fields in that form and hit the register button the data will be inserted in to the database table called xyz table

in that table I have an id field which is a text field in access database consists of guid starting with letter P

when I inserting the data from aspx form...the guid is not inserting into the table.

one of my datarecord in that table with the id field is like this.(.P11111111-1BBB-4444-A9D1-111111111111)

need to insert anoother record in that table that field must be generate with the ID starting with P..its an guid.. the creating guid in the aspx.cs page..??

View 26 Replies

Creating Data Access Layer For Small Website?

Feb 10, 2011

I am creating my application in asp.net 3.5. I have to make my Data Access layer, in which I am doing the traditional method of fetching/updating the data. Which is SqlConnection than SQLCommand, than SQLadapter. Will there be any other way I can create my DAL layer easily.

Specification.

My website is small. Approx 7-10 pages. Database has around 80 tables.

What I know:

Linq to SQL - I don't want to use it because I am not fully aware about the LINQ statement and I need to develop the application really fast. [3 days :-( ]. Also, there are 100% chances that the table structure will be altered in future. Enterprise Library: It will take too much time for me to integrate to my application.

View 4 Replies

Access :: Creating RSS Feeds Using A Database?

Jan 15, 2010

I know how to create an rss feed using xml, but not sure how to with my access database. Can anyone tell me how?

View 1 Replies

Creating 4 Website With Same Database And Admin Panel?

Jun 24, 2010

I am planning to develop around 4 product catalogue websites. The functionality of all the websites would be same. however the design, images and css would be different.

All the 4 websites will use the same admin panel, forums and database(MS Access) also.

How should I create such a system.

I dont understand what kind of folder structure should I create.

I would like to create following kind of folder structure.

(Root Folder)Admin Website ----> Website 1 (subfolder)

----> Website 2 (subfolder)
----> Website 3 (subfolder)
----> Website 4 (subfolder)

Root folder will have the database and all the common files.

Unfortunately, when I tried to create such structure, Dot Net Didnt allow me to create one website inside another

what kind of system should I use for maximum reusability.

I am a small time freelancer and cannot afford to build seperate websites for each of my client.

View 4 Replies

Security :: Creating A Login For A Website That Checks Against A Database Table?

Oct 26, 2010

Creating a login for a website that checks against a database table.

I have never made a login before but im just going with what i think would be right.

but how do i make it check against a database? and how do i capture that login and use it again in the next page?

View 5 Replies

Access :: Showing A PDF File Based On Info From Database

Aug 5, 2010

I have a small Access database with some fields, like: date, name, text. Those fields are stored in a record inside MS Access. I also have an PDF file available belonging to that record as described before. I like to store the title of this PDF also in this record. Clicking by an user on this title should show the PDF file in a separate form. The pdf's are all stored in a map called e:pdfs and filename can be as needed. My questions are:

1. how should i bring the pdf names inside the record (like e:pdfsumber-one.pdf ? )
2. by clicking on this name the pdf file should be showed in a seperate form?
3. clicking means probably a javascript that handles the pdf file ?
4. can anyone give me some clues? I do work with VS2010 and framework 4

View 3 Replies

Forms Data Controls :: Creating A Website Using VS2008 And Connected To A Firebird Database?

May 3, 2010

Ive created a web site using VS2008 ASP.net and connected to a Firebird Database.

I have a page that has a GridView(added at design time) and have connected to a table at runtime.

[Code]....

All good as the table contents are displayed at 10 rows per page. Ive set the Property AllowSorting to True. Has anyone got examples on how to code the sorting? Ive had a look round the net but all the examples Ive tried dont work.

View 3 Replies

Migrate Existing Database From Specific Application To New Ms Access Based Application (database)?

Aug 2, 2010

how to migrate an existing database from a specific application to a new Ms Access based application(database)?

View 4 Replies

Configuration :: Cannot Access SQL Database In Website Using IIS?

May 21, 2010

I have created a database and a website using C# and ASP.NET. I am deploying the website from IIS7.0 and created the connection string from the connectionstring tool in the IIS Features View.But I get any data ( access my database) when i run the website from the IIS, it works well when i debug from the Visual Studio.

View 8 Replies

Write To Access Database Inside The Website App_Data Folder?

Apr 20, 2010

An associate wants to store an Access database in the App_Data folder of a website that lives on a local server and write new data to it daily from Microsoft Access on a client computer on the local network.Internet users will access the Access data from the website.

Is it possibe to write to an Access database in the App_Data folder of a website that lives on a local server using Microsoft Access? And also connect and read with ASP.Net?The internet connection is "Read Only".

View 4 Replies

Website Access / Login Page Will Be Connected To Local Database?

Mar 30, 2010

when a website is entered in a browser it should take to a login page (in localhost) and if the login succeed then the site should be loaded else an error page should be displayed. the login page will be connected to local database. how to do this?

View 6 Replies

VS 2008 - Restricting Access To Web Pages (on Intranet Site) Based On Role Based Authorization

Jul 12, 2011

I have a simple intranet site. It has a role based authorization in the web.config file.

Any user's in a specific role called as "Apr-Sales-Writers" will be authorized to use those pages. If not, they will not be authorized. So far so good. Works fine. But we added additional functionality where a new active directory group (means new role) has to be added and user's belonging to this new AD group should be given access to only specific .aspx pages on the intranet site. I am using a web.sitemap and it looks like this.

If the user's belong to say AD group "Apr-Sales-Writers", they should access only default.aspx and salesData.aspx pages. User's belonging to new AD group (which I did not include in the web.config file below), should have access to other .aspx pages.

[CODE]<?xml version="1.0" encoding="utf-8" ?>
<siteMap xmlns="http://schemas.microsoft.com/AspNet/SiteMap-File-1.0" >
<siteMapNode url="default.aspx" title="Home" description="Home">
<siteMapNode title="sales Data" description="sales Data">
<siteMapNode url="salesData.aspx" title="sales Data" description="sales Data" />

[Code] ....

View 7 Replies

Configuration :: Configuring Original Settings For New Website Based On Site Files From 1st Website & Password Q

Oct 19, 2010

I want to make a 2nd website and am using a copy of the site files from my 1st site built for me, I added them via FTP to the hosting company. I realise when I edit the new site via the CMS it is editing both sites plus when I try to change anything to the CSS file I get the following error -

C:inetpubvhosts*****mysite******httpdocsapp_themessiteStyleSheet.css

So my questions are what do I need to change to be able to deploy a new site with the files I have to make a new site?I also don't understand where the password is coming from, I can see the User ID comes from the database. in the Asp.net connection strings are the following:

site Data Source=sql7.hostinguk.net;Initial Catalog=***;User ID=***;Password=*** - Where is this password coming from?

membership Data Source=sql7.hostinguk.net;User ID=***;Password=***;persist security info=False;initial catalog=***;

View 2 Replies

Access :: IIS_WPG Write/modify Access To The Folder Where MS-Access Database Is Located - Insert An Error Pop-up?

Feb 17, 2010

Is there anything missing in IIS 6.0 that prevents me from (Insert into table) using MS-Access?

Explain: The application works fine under Visual Studio 2008 IDE the insert into table works fine with no error, Also I tested with hosting provider and works fine with no problem. but now I have published the same exact app in a dedicated server windows 2003 with
IIS 6.0 .NET framework 2.0 with latest service pack I gave IIS_WPG write/modify access to the folder where MS-Access database is located and database but at the time of insert an error pop-up. I need to install in the Server or settings in the IIS to recognize my MS-Access db is it some office runtime that I am missing. (BTW I am using OLEDB connection string in my C# )

Using System.Data.OleDb;

I can retrieve data off of it with no problem but when I try to insert is when it fails I thought the problem was Access Rights but I do not think is the case.

View 4 Replies

VS 2008 Creating Role Based Authorization?

Feb 9, 2011

I have seen articles on Role Based Authorization in MS-Sql server-Asp.net but i did not find any article in MySql-ASP.net/vb.net, i am acheived this concept using session user name i am enabling certain parts of website to group A and certain parts of site to Group B but when i have more groups i cannot use this method.

Myrequirement is:

In Web applications, typically there exist certain parts of the site that only certain folks, or groups of persons can access. For example, imagine Web site used to administer the content on a company's public Internet Web site, where the public Web site lists products sold by the company. From the administrative site, all company employees might be able to make minor changes to the products' descriptions, quantity, and other such non-essential information. However, perhaps only a subset of trusted employees might be able to change the products' prices. And even a smaller subset of employees would be able to add new products or delete existing products from the database I would be delighted if any one provide the solution

View 9 Replies

PHP Login Form On Local Website To Access Remote Website?

Jul 15, 2010

I want to have a PHP login form on my website. When the user enters a username and password and clicks submit, they should be directed to a remote website logged in (therefore skipping the login form on the remote site).

As mentioned in the title, the remote site is built using ASP.NET.

I've tried to search for a solution this but really not finding.

View 3 Replies

Creating Dynamic DataList Controls With ID's Based On Bound Data - Finding Alternative

Jun 28, 2010

As a workaround for the fact that asp:Checkboxes don't have values, I am attempting to dynamically create the ID's of checkboxes in a DataList so that it inserts the primary keys into the control ID. This is surprisingly difficult.

I have placed a PlaceHolder in my DataList ItemTemplate, then in the ItemCreated I create the checkboxes using string.Format("Checkbox{0}", DataBinder(e.Item.DataItem, "ID")). The problem is that this only works in a non-postback condition, as on postback the DataItem is null. And of course ItemDataBound isn't called on PostBack so that won't work either.

I can't seem to find a good way to handle this short of if (IsPostback) dataList.Bind(), which i don't think is a good way to do it.

Can anyone provide me with any alternatives here?

View 1 Replies

Security :: Creating A Interface For User Role Management Based On Built In Membership Provider?

Feb 18, 2011

I am creating a interface for User Role Management based on built in membership provider.I want to display all the roles as check boxes for a selected user. I am able to display all the roles in the database, but not able to load the specific user roles. For example, I am able to publish role 1 role 2 role3 role 4 as check boxes. But if the user is already flagged as role 1 and role 3, I am not able to show that data (role1 and 3 should be checked when form loads, but right now, they are not checked)...How do I get the roles as checked boxes display on a page.I am using a repeater control to display roles as check boxes on the page..

<asp:Repeater ID="UsersRoleList" runat="server">
<ItemTemplate>
<asp:CheckBox runat="server" ID="RoleCheckBox" AutoPostBack="true" Text='<%# Container.DataItem %>'

[code]...

View 1 Replies

How To Point The Login Control To A Different Database Based On The Database Selection

Feb 23, 2010

For the login control that I am using, there is a connectionstring which is automatically created in the web.config file.I ran an .exe file which populated the specified database with all the asp login related tables and stored procedures...

<connectionStrings>
<remove name="LocalSqlServer"/>
<add name="LocalSqlServer" connectionString="Data Source=localmachineName;Initial Catalog=DBName;Persist Security Info=True;User ID=DBUserName;Password=password" providerName="System.Data.SqlClient"/>
How can I point the login control to a different Database based on the database selection by a user i.e. the user can change the name of the database and so the login should point to that database.

View 7 Replies

C# - Creating An International Website?

Jan 4, 2011

The question might sound weird, but I am planning to create a asp.net website, which when fully done, will ideally cater to all countries.I am currently in the architecture phase.. and is there anything that I should keep in might when doing this?

like,saving all datetime fields in utc

using user's timezone to display all time related data

all labels in the website to be localizable

is there anything else?

View 4 Replies

C# - Creating Versions Of The Same Website?

Jul 5, 2010

My new assignment at work is to create a second version of our existing web application. Currently, our application supports only full time brokers, but now we our launching a second site specifically for part time brokers.

The new site will be almost identical to our existing site with the following exceptions:

It will have it's own branding. A couple of the user controls used for displaying information will be different (but none of the pages will be different). Our existing users should not have access to the new site and vice versa. It needs to be easy to test both versions of the website from within Visual Studio easily. We want to reuse as much our existing code as possible. I have 2 weeks to do this. I'm hoping that this is a common scenario and someone out there has some advice for how to accomplish this.

View 4 Replies

Access :: Creating An Excel File From Dataset Or Access File?

Nov 21, 2010

i have an asp.net application

c# code

i have adtabase in access and i craete adatset from it

i want to create excell file

View 2 Replies

Creating An Scalable MVC Website Without Using Session?

Sep 16, 2010

I'm working on a Web project using Asp.Net MVC, which I'll have to deploy to a farm environment.

I've read a lot of articles and I'm thinking on disabling completely the SessionState, I think this would make a more robust application, and will save me a couple of headaches (Everything I've read tells me that handling sessions on a farm isn't trivial).

There are some things that I still don't have totally clear with this approach though, the main one being the authentication/authorization process. Basically I'm not sure of how (if?) I can handle user sessions if there's no SessionState enabled on the server.
If a user logs into the web site and then tries to access another page, how can I know that the user is already logged in?

I know using cookies is insecure, I thought of a mix of cookies with the session Id stored in the DB, but I suppose that if I disable SessionState I won't have access to the session id either.

View 3 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved