Access 2010 Web Database

[Adam858]

Is there any way of localy hosting an Access 2010 web database without using sharepoint?

I want to create a database that I can update on any browser in the shop.

Cheers

Adam

[abpni-computer-solutions]

Is there any paticular reason why you'd like to stay with Access? Are you looking for a "web frontend" for your database?

[DotNetWebs]

Is there any way of localy hosting an Access 2010 web database without using sharepoint?...

That particular feature does I believe require Sharepoint

http://www.opengatesw.net/ms-access-tutorials/Access-2010/Microsoft-Access-2010-Web-System-Requirements.htm

Another way would be to convert your database to SQL (Access includes tools to do this) Attach the to SQL Server (the Express version is free) and create a browser-based client to connect to it but you would probably need a developer to help you do this.

You can also create Access [desktop] clients based on your existing forms that would connect directly to your SQL data.

Regards

Dotty

[Astaroth]

You can do it without sharepoint by creating a web front end in a similar way to Dotty's suggestion of converting it to MS SQL but it will come with the same draw backs that it is not automated and so you may need a developer to complete it for you.

If you simply want a single person accessing it at any one time then you in the same way as you do when using the local machine it is on then you could simply place it on a shared location (if all the PCs are on the same network) or VPN/ VPC into your network with the remote PC if they aren't on the same network

[abpni-computer-solutions]

Hi Adam,

We can create a very simple web frontend for your database, which can be accessed by any PC with a web browser. PM me if you're interested :)

Even if you wanted to do it yourself, I'm sure I could give you a hand on how you could do this yourself.

Cheers

[DotNetWebs]

...If you simply want a single person accessing it at any one time then you in the same way as you do when using the local machine it is on then you could simply place it on a shared location (if all the PCs are on the same network) or VPN/ VPC into your network with the remote PC if they aren't on the same network

Yes I also agree that would be the easiest option if only local [single] access is required. Many company networks operate this way.

Otherwise chat to the developers offering to help.

Regards

Dotty

[Adam858]

Thanks for your help guys, I will keep this in mind when I come to finish this project. For now I will just share the database over the network, but a web front end would be a good addition in the future.

Cheers

Adam

[BusinessIdeas]

Coldfusion

[DotNetWebs]

Coldfusion

I would assume that if the OP didn't want to have to purchase and install Sharepoint he wouldn't want to have to purchase and install Coldfusion either.

Regards

Dotty

[BusinessIdeas]

Hiya Dotty, long time no speaky :)

Coldfusion only costs about £2 a month to go with your hosting doesnt it?

[DotNetWebs]

Hiya Dotty, long time no speaky :)

Coldfusion only costs about £2 a month to go with your hosting doesnt it?

Yes but OP wants to LOCALLY host it so he would have to pay for a software licence.

Anyway nice to speak to you again. :)

Regards

Dotty

[BusinessIdeas]

Thanks Dotty, yep I get it now. :)