How difficult is it to make a database web accessible?

[zestygirl]

I'm open to different suggestions...

Is there a simple way to make a database web accessible?

To be able to add data, run reports, run forms, etc?

How difficult is it?

Thanks for any opinions!

 

[JamesMcS]

I haven't done it properly myself but have you tried a data access page?

 

[SOS]

I haven't done it properly myself but have you tried a data access page?

Not a good suggestion as DAPs have gone away in 2007 and above.

Right now, there aren't a whole lot of options for moving to a web presence with Access. When 2010 comes out you can do a lot better (if using SharePoint 2010 as well), but you can currently write web pages to connect to an Access database but that really takes someone who knows ASP, ASP.NET, etc.

The frontend items like forms, reports, etc. are not able to be run from the web (at this point).

 

[Mr. B]

If you just want to use an Access database as the data source for web pages, then take a look at Visual Web Developer 2008. This is a free web development tool from Microsoft. You can download it and you can use an Access database as the data souce for the asp.net web pages you create with it.

 

[NYC2RDU]

What about running an Access application in a Citrix session online? Has anyone thought of or tried doing that?

 

[Simon_MT]

Or even better still deploy a Terminal Server as the database remains local and it is very efficient.

Simon

 

[HiTechCoach]

I'm open to different suggestions...

Is there a simple way to make a database web accessible?

To be able to add data, run reports, run forms, etc?

How difficult is it?

Thanks for any opinions!

See is my article helps:

Running an Access database over the internet