Solved

ms access created since y97, need to put into web app, how to procedd

Posted on 2014-10-12
4
20 Views
Last Modified: 2016-07-05
first of all, I would like to state that I am not a programmer, so I might lack some very basic procedure here, please enlighten me and put it simple.
I created an ACCESS data base to cope with my small business's accounting. It contained all of the form, query, macro and Visual Basic code.
I have changed its .mdb extension to the new 2007 version of .accdb.
now I need to put it into web app as I think it is more secure to have other people work at it,
but I don't know the detail process to do it.
I am not sure if it can directly put into web app, share point.
I really don't want to rewrite a new data base as the all data stored are very sensitive and I can't afford to lose them.
Please inform me what to do or how to make a more secure lan base working environment.
I try to use the users level password, but the .mdb access limited only one user at a time, which is not a practical way.
I am not sure if the new 2007 version can have a better user security environment.
Please enlighten me. thanks.
0
Comment
Question by:Piti Wongboonyakul
4 Comments
 
LVL 24

Expert Comment

by:Bitsqueezer
ID: 40375610
Hi,

a web app is not more secure just because it is one.
Upgrading to A2007 is OK, but for example the Access security model with MDW files doesn't exist anymore since A2007. So if you only want a better security and do not really need a web app then it would be a good idea to use i.e. an SQL Server Express as backend for your database. Here you can use the Windows authentication model to allow only users which are in your Windows domain (if you have one) access to the database. If not, you can work with SQL Server logins instead.

A web app has the disadvantage that it cannot work with any VBA. You would need to change any VBA code to macros, but in most cases that's not possible as macros are only usable for very primitive programming.

If you want to use i.e. SQL Server as backend then you can download the Microsoft SQL Server Migration assistant for free which helps you converting the Access tables to SQL Server tables and links them back to your Access application. If your database is not too complicate then this is often enough to have a working database after this step. You can simply try that out because the assistant is free and also SQL Server Express.

If your Access database is not separated into front- and backend but instead a single database on a fileserver which is used by multiple persons then the first step should be to separate that into front- and backend so that the backend only contains the tables and the frontend all the rest, any user should use his own frontend.

Cheers,

Christian
0
 
LVL 30

Expert Comment

by:hnasr
ID: 40375635
Start with visual studio.
Use http://msdn.microsoft.com to search for topics, like tutorial to use databases.
You may use Access database or SQL database as data sources.

You need to update the database to newest version.
Then start a web forms project, and connect to the database.

You need to create all required web forms.
0
 
LVL 57

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 500 total points
ID: 40376824
Moving to the web from what you have pretty much means a re-write of the application.

 However one option is to use the existing DB as is and run it under terminal services.  With that, you can publish the app or use Citrix to have it appear in a web browsers.

 This means your app runs on a local server and user "remote in" and execute the application directly on the server.  All that goes across the internet is Keyboard, Video, and Mouse.

Jim.
0
 
LVL 27

Expert Comment

by:MacroShadow
ID: 41691622
No comment has been added to this question in more than 21 days, so it is now classified as abandoned.

I have recommended this question be closed as follows:

Accept: Jim Dettman (Microsoft MVP/ EE MVE) (https:#a40376824)

If you feel this question should be closed differently, post an objection and the moderators will review all objections and close it as they feel fit. If no one objects, this question will be closed automatically the way described above.

MacroShadow
Experts-Exchange Cleanup Volunteer
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Contents of subform based upon combobox value 3 26
Field behavior for "locked" form 12 29
Query to summarise data Like Pivot Table 3 29
SQL profiler equivalent in MS-Access 3 42
In the article entitled Working with Objects – Part 1 (http://www.experts-exchange.com/Microsoft/Development/MS_Access/A_4942-Working-with-Objects-Part-1.html), you learned the basics of working with objects, properties, methods, and events. In Work…
In Debugging – Part 1, you learned the basics of the debugging process. You learned how to avoid bugs, as well as how to utilize the Immediate window in the debugging process. This article takes things to the next level by showing you how you can us…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now