Microsoft access website integration

It means that I need to get it done in the next few months, at as low a cost a possible, and uncertain about the right way to go about it at the moment.. It is a time collection application, so YES users will be putting in data time by day by project.

The number will increase modestly but as a result of organizational growth, not as a result of the web application. NO the web application is a feed to a back end Invoice and Payroll Access application. We currently use an Excel spreadsheet, running on individual systems, combined with e-mail.

Albert D. Well, since ms-access has really NOTHING to do with a web based system, then it really does not mater what database you use on the web server You might be able to find a web provider that supports the use of a ms-access mdb file. All this means is that the software the web software YOU will have to write will read data from the mdb file. However, for all intensive purposes, you are NOT really using ms-access anymore.

The only part that gets installed on the web server is the JET database engine that allows the web site to USE the data. JET is the same data engine that VB6 developers, or. So, really, you not using ms-access at all anymore here the web server only needs a way to read the data.

Since you are only reading or updating the data, and NOT using the application part, then at the end of the day, you can use sql server, or MySql, or whatever database engine that the web provider supports. Transferring data from MS-sql server is likely LESS work then trying to pull data from a mdb file sitting on that web server and, to copy the mdb file, you will have to shut down the web server which has the mdb file open.

Further, shutting down the web server can often be quite hard to do when you are using a web hosting company However, in all of these cases, and EVEN when you are using a mdb file on the web server you are NOT using ms-access in any way, shape, or form. If you use a server based engine like ms-sql server, then you can connect to that database over the internet and pull data from it into your mdb file So, at the end of the day, your data on the server does not have to be in ms-access, and in fact it is LESS of a advantage to place your data in a mdb file for the web server to open and consume.

To be fair, ms-access does have some web based ability, but they requite TIGHT integration with the web server, and in fact is only practical if you are running your own web server along with the VERY scary security risks of doing this!! These DAP's are in fact live connections to a mdb file. And, you can even create forms in ms-access and save them as a web form all the fears like sub-forms etc DO NOT work.

And, you still requite end users to have office installed. NET and, you don't need ms-access to do this, nor will ms-access help you anyway. So, you will have to check with your web provider as to what kinds of software tools and development tools THEIR web server supports. For example, it might be that your provider is using non Microsoft based web servers, and thus your choice of tools is limited. Hence, you either have to find out what tools and development systems your web provider supports, or choose the tools you want to crate your web stuff with, and then find a provider that supports your favorite tools you are will use to develop your web site.

However, those tools have really noting to do with ms-access at all. Time to start visiting some other non ms-access newsgroups here!! John, I don't see any way around creating a web application for this.

Also, as Albert says, there's no particular reason why you must use MS Access Jet as the database, especially if the "back end Invoice and Payroll Access application" does not yet exist. In addition, you should think about security as this would be senstitive information sitting on someone else's server going across the web with HTTP. You might want to use SSL very simple to do and some kind of authentication so that not just anyone can log in. You may want to discuss security with your 3rd party provider.

NET Web Site. Click the create new Web application icon , and then name the new Web application AccessSample. The New Web Site dialog box appears with the location of your new Web application in the right-most Location box. In the Language list, click the programming language that you prefer to work in. The programming language that you choose will be the default for the Web site, but you can set the programming language for each page individually.

Visual Web Developer creates the folder and a new page named Default. The Web site is displayed in Solution Explorer. An important aspect of working with an Access. When a Web application uses an Access database, the application must have Read permission to the.

Additionally, the application must have Write permission to the folder that contains the. Write permission is required because Access creates an additional file that has the extension. By default, ASP. Therefore, to use an Access database in an ASP. The folder is designed to be a store for application data, including Access databases. For more information about SharePoint permissions, see the See Also section. Forms, reports, and most macros run inside the browser.

This lets Access refresh data on the screen without having to redo the whole page. You can create a form to help people navigate your application. A new control, the Navigation control, makes it easy to add standard Web-style navigation buttons to a form for this purpose. Note: The Navigation Pane the feature that you use in Access to browse the objects in a database is not available in a web browser.

All of your tables become SharePoint lists, and records become list items. This lets you use SharePoint permissions to control access to your web database, as well as take advantage of other SharePoint capabilities.

Security Note: The connect string for linked tables is unencrypted, including the username and password if that information was saved and the link target supports user accounts. In a database that has a link to a SharePoint list and the link includes the username and password, a malicious user could change which list is the target of the link, using the saved credentials. Exercise caution when you share copies of a database that contains links to lists in a published web database.

All SQL processing happens on the server. This helps improve network performance by limiting traffic to result sets. You can publish to your own intranet SharePoint server, or to the Internet. Microsoft is offering an Internet-facing, hosted SharePoint solution. This section describes key new features and provides steps for the basic design tasks you need to complete to create a web database. Before you begin. Design differences between desktop and web databases. Desktop-only features with no Access Services counterpart.

Consider using a template. Get started with a blank web database. Design a web table. Create a new web table. Add a field from the field gallery. Add a field by clicking the datasheet. Change field properties. Add a calculated field. Set up data validation rules.

Set up a field validation rule and message. Set up a record validation rule and message. Create a relationship between two web tables. Create a lookup field in Datasheet view. Modify a lookup field in Datasheet view.

Maintain data integrity by using data macros. Create a web query. Create a web form. Create a web report. Create a Navigation form and set it as the default form to display on start. There are a few tasks that you should perform before you start to design your web database.

Moreover, there are design differences between web databases and desktop databases that you should know about, especially if you are an experienced Access developer. Determine the purpose of your database Have a clear plan so you can make good decisions when working out design details. Find and organize the information required You cannot use linked tables in a web database. Any data that you want to use that will not originate in the database must be imported before you publish.

If you line up your data before you start designing, you can avoid having to refit your design to accommodate unexpected data challenges. If you want to test your design in a browser while you design it not a bad idea , you have to publish it first. Plan your security You can take advantage of SharePoint security to control access to your web database. Plan security early so you can build it into your design.

Some database features that you can use in a desktop database are not available with Access Services. However, there are new features that support many of the same scenarios as these desktop features. The following table lists the desktop-only features, and the new feature that helps support the same scenario.

Important: You can create many client objects in a web database, but you cannot use them in a browser. However, they are part of the web database and can be used in Access on the desktop. People can open the web database in Access, and then use the client objects.

This is an effective way to share a database, and also opens new opportunities for working together over the Web. SharePoint handles any concurrency issues.

When you have determined what your application must do, consider whether a database template would work. Database templates are pre-built applications that you can use as-is or modify to suit your particular needs.

You can review the available templates on the New tab in Backstage view. For more information about the templates that come with Access , see the article Select and use an Access template. The File tab opens Backstage view, a new part of the Access interface where you'll find commands that apply to an entire database, such as Publish to SharePoint. Review the proposed file name in the File Name box, and the path for the database file, listed just below.

You can change the file name by typing in the File Name box. To change the path, click the folder icon next to the File Name box to browse for a location to put your database file. Click Create. Your new web database opens and displays a new empty table. When you first create a blank web database, Access creates a new table and opens it in Datasheet view.