Đã Đóng

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.

Kĩ năng: ASP, Visual Basic, Thiết kế trang web

Xem nhiều hơn: 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

Về Bên Thuê:
( 15 nhận xét ) irvine, United States

ID dự án: #1034495

48 freelancer đang chào giá trung bình $88 cho công việc này

ntiersolutions

Please check your pm. Thanks

$55 USD trong 3 ngày
(308 Nhận xét)
7.8
ITservice

Hi Pls check PMB. thanks

$100 USD trong 3 ngày
(210 Nhận xét)
7.6
shmai

have a glance at Pm. Regards,

$100 USD trong 2 ngày
(205 Nhận xét)
7.1
sureshdevi

I can do this work. Thanks, Suresh

$100 USD trong 2 ngày
(322 Nhận xét)
7.0
VikashThecoder

Hello sir PLease see PMB

$50 USD trong 1 ngày
(173 Nhận xét)
6.8
netcoder

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

$55 USD trong 5 ngày
(115 Nhận xét)
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 Thêm

$80 USD trong 0 ngày
(22 Nhận xét)
5.6
easycoders

Hi, Please check your inbox.

$60 USD trong 3 ngày
(22 Nhận xét)
5.4
eperfections

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

$150 USD trong 2 ngày
(38 Nhận xét)
5.6
mantislin

Hi sir, Please check PM.

$60 USD trong 2 ngày
(55 Nhận xét)
5.6
AImran

Please check PMB. Thanks

$80 USD trong 5 ngày
(31 Nhận xét)
5.1
morpheeen

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

$60 USD trong 3 ngày
(20 Nhận xét)
4.9
jarvisliu

Please see your PMB

$100 USD trong 2 ngày
(10 Nhận xét)
4.5
KellogITSolution

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

$50 USD trong 3 ngày
(15 Nhận xét)
4.3
superMena2001

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

$50 USD trong 3 ngày
(5 Nhận xét)
4.0
terranProgrammer

i already done this in my previous projects

$35 USD trong 2 ngày
(9 Nhận xét)
3.9
kroshty32

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

$125 USD trong 2 ngày
(1 Nhận xét)
3.2
manishadk

please view PMB for details.

$80 USD trong 2 ngày
(6 Nhận xét)
3.0
yehia111111

Hi Sir,please check your PMB

$70 USD trong 3 ngày
(2 Nhận xét)
2.7
kazmi15s

Experienced ASP developer here. Please check your PM!

$80 USD trong 3 ngày
(2 Nhận xét)
2.4