Đã Đó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 thêm: 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

Mã Dự Án: #1034495

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

shmai

have a glance at Pm. Regards,

$100 USD trong 2 ngày
(200 Đánh Giá)
7.1
lsweb

Hello. Please check your PM. Thanks.

$55 USD trong 1 ngày
(71 Đánh Giá)
6.7
ITservice

Hi Pls check PMB. thanks

$100 USD trong 3 ngày
(75 Đánh Giá)
6.5
ntiersolutions

Please check your pm. Thanks

$55 USD trong 3 ngày
(95 Đánh Giá)
6.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
(31 Đánh Giá)
6.2
sureshdevi

I can do this work. Thanks, Suresh

$100 USD trong 2 ngày
(168 Đánh Giá)
6.2
netcoder

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

$55 USD trong 5 ngày
(106 Đánh Giá)
6.0
mantislin

Hi sir, Please check PM.

$60 USD trong 2 ngày
(45 Đánh Giá)
5.4
easycoders

Hi, Please check your inbox.

$60 USD trong 3 ngày
(21 Đánh Giá)
5.4
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
(16 Đánh Giá)
5.1
morpheeen

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

$60 USD trong 3 ngày
(21 Đánh Giá)
4.9
AImran

Please check PMB. Thanks

$80 USD trong 5 ngày
(17 Đánh Giá)
4.8
jarvisliu

Please see your PMB

$100 USD trong 2 ngày
(10 Đánh Giá)
4.5
KellogITSolution

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

$50 USD trong 3 ngày
(14 Đánh Giá)
4.3
VikashThecoder

Hello sir PLease see PMB

$50 USD trong 1 ngày
(7 Đánh Giá)
4.1
superMena2001

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

$50 USD trong 3 ngày
(5 Đánh Giá)
4.1
ndgarg

Ready to start right way. Hope to achieve next positive feedback from you !!! Please check you inbox. ""Always willing to walk extra miles to achieve Excellence""

$125 USD trong 3 ngày
(2 Đánh Giá)
3.7
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 Giá)
3.2
terranProgrammer

i already done this in my previous projects

$35 USD trong 2 ngày
(2 Đánh Giá)
2.9
manishadk

please view PMB for details.

$80 USD trong 2 ngày
(5 Đánh Giá)
2.9