Fermé

Simple asp access database web page

A one or two page asp website that allow user to search a read only Access database. There will be multiple databases on the web server, so first, webpage must ask user to select the database to work with. The databases will be placed in a folder and named like a date i.e. "[url removed, login to view]","[url removed, login to view]". So, you must show all the databases in a list, allow user to select the database, then make a connection to that database. There is only one table in the database and it will be named the same across all databases. The databases & tables will be same structure, just data different. The table names will also be the same accross all databases.

The selected database is now used for the query. Simple one field query. User enter search, hit select, then display the record. The search field is called "BarCodeData". You can see this in the Access database attached. Record has about 10 to 15 fields. Then allow user the print out this record. See attachment of sample screen and access database.

Sorry, I have to add more to the project. Please read this description again:

This is a simple asp or asp.net application that allow users to search an Access or SQL Server database.

Step 1. Screen with option for user to archive ‘production’ Access database. User will be prompted to provide a name for the archive database (usually date like 12-1-2011.mdb) . The app will then ask for confirmation. When “Yes” is selected, app will make a copy of ‘production’ database. If this is successful, the 'production' database will be emptied so data collection can start again.

Step 2: Please look at odv.mdb. The [BarCodeDate] column contains data we need to clean, removing all characters beginning with “[“ and ending with “]”. This should only leave sequence of numeric characters. The new column call it “BarCodeData_Cleaned” will be used for searches.

Step 3: Since the archiving is done monthly, the archive databases are placed in a folder . So, you must show all the archive databases in a list, so user can select database to work with, then make a connection to that database. There is only one table in the database and it will be named the same across all databases. The databases & tables will be same structure, just data different.

Step 4: The selected database is now used for the query. Simple one field query. User enter search, hit select, then display the record. The search field is called "BarCodeData_Cleaned". If there are multiple matches then display list so user can select which record to display detail. Record has about 10 to 15 fields. Then allow user the print out this record. See attachment of sample screen and access database.

Step 5: This application will be used at different locations. An admin page has to be design so I can log in with username & password. This admin page will allow entry of settings to make this application portable so I can install in on different servers. Also, need setting to put expiration date, so after this date, application will not work.

Please let me know if you need clarification. Thanks.

Compétences : ASP, Visual Basic, Design de site internet

en voir plus : simple database web page, simple asp database, simple asp access database, access database web asp, simple asp database search webpage, search access database webpage, simple asp database web page, simple access asp, simple database website, simple webpage database, simple data structure, named query, ask web search, access database webpage asp, simple asp search access, simple search database web page, search database web page, asp access database, webpage or web page, simple query, mdb, c# with access database, c with access database, basic web page, access database

Concernant l'employeur :
( 15 commentaires ) irvine, United States

Nº du projet : #1034495

48 freelance font une offre moyenne de $88 pour ce travail

ntiersolutions

Please check your pm. Thanks

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(308 Commentaires)
7.8
ITservice

Hi Pls check PMB. thanks

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(210 Commentaires)
7.6
shmai

have a glance at Pm. Regards,

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(205 Commentaires)
7.1
sureshdevi

I can do this work. Thanks, Suresh

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(322 Commentaires)
7.0
VikashThecoder

Hello sir PLease see PMB

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(173 Commentaires)
6.8
netcoder

Hi, I think I can do it:-)! Best regards, netcoder:-)

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(115 Commentaires)
6.1
Vikaskukki

Hi hope you are doing well, Let me explain what i understand as you have mentioned. 1) We need to create a page where we will read a folder ( where all db will be placed) and all database name will be listed in Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(22 Commentaires)
5.6
easycoders

Hi, Please check your inbox.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(22 Commentaires)
5.4
eperfections

I have completed 300+ projects on different lancing sites. I can do this project as per given requirements.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(38 Commentaires)
5.6
mantislin

Hi sir, Please check PM.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(55 Commentaires)
5.6
AImran

Please check PMB. Thanks

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(31 Commentaires)
5.1
morpheeen

Hi, I can help you with this if you like.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(20 Commentaires)
4.9
jarvisliu

Please see your PMB

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(10 Commentaires)
4.5
KellogITSolution

Hello Ready to start right now. Please see your PMB for details. Thanks

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(15 Commentaires)
4.3
superMena2001

sir thats a very easy project no need to pay high, please check your PM

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(5 Commentaires)
4.0
terranProgrammer

i already done this in my previous projects

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(9 Commentaires)
3.9
kroshty32

I have over 13 years database and application experience. I am an expert with .Net and Access.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(1 Évaluation)
3.2
manishadk

please view PMB for details.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(6 Commentaires)
3.0
yehia111111

Hi Sir,please check your PMB

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(2 Commentaires)
2.7
kazmi15s

Experienced ASP developer here. Please check your PM!

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(2 Commentaires)
2.4