Best way to place a Microsoft Access database into a company intranet portal

Kurt

Well-known Member
Joined
Jul 23, 2002
Messages
1,664
Hello All,

I am sure some of you have done this before.

What do you recommend for best practices for placing a Microsoft Access database into a company portal where Sales people can enter in their information?

Please advise.

Thanks,

Kurt
 

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.
Kurt,

Unfortunately Access really does not do well with a company intranet portal unless you have a Sharepoint.

If you are using an Access Desktop database there really is not a way to run in n a browser on a company intranet portal.

If you did not design, crete, and test it run on the company intranet portal from the start you will have may have to start over if it must be on the company intranet portal


If you have Access 2013 and Sharepoint Enterprise then you could also recreate the database as a web database and publish it to Sharepoint. The really bad news is that a web database can only use Macros. NO VBA CODE!

See:
Build and publish an Access database to SharePoint
The avove artice is about Acess 2010. Web database were greatly improved in 2013. I would only use 2013 that is you go that route.


What I do and also recommend for desktop databases:

Standard network deployment without using the company intranet portal. This will used everything you have already done with only a few minor tweaks.

You will need to install Access on each PC. The good news is that you can use the free runtime version for all the PCs that do not have an Access license.

You will do a standard multi-user deployment. The database will be split. The front end local on each machine. The back end on a network share where the users have read and write permissions.

If you upsize the back end to SQL server then you can also develop an ASP/ASP.net web app for others. Now you can have a mix of front ends. Some uses with the Access front end and some in a browser with the ASAP.net front end.
 
Upvote 0

Forum statistics

Threads
1,221,848
Messages
6,162,406
Members
451,762
Latest member
Brainsanquine

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top