Question Posting to Sharepoint

[mikebrewer]

Hey guys, hopefully an easy question here but I can't find the answer...

I have an access database that I'm using at my organization and I have 1 user who is off-site that I need to have her able to input data into the database. the data is currently hosted on a SQL Server as the backend with Access working as the front-end connecting through ODBC connection to the SQL Database.

The question is... can I publish the Access Database front-end to any kind of browser (sharepoint) so that the user can still have the interface but won't have to have it loaded on her PC? The reason is that the database does some querying off of another SQL Database for information and the speed of her connection just isn't good so I'd like to put it to a web interface where the speed can be improved greatly. I'd like to keep the data on the SQL database backend.

Thanks!!

 

[spikepl]

I have 0 experience with Sharepoint, but AFAIK you have to be lucky if what you have can be published unmodified.

You have other options: Remote Desktop, Citrix.

Or LogMeIn, gotoAssist, Teamviewer, VNC for remote login on a local computer.

 

[mikebrewer]

I have remote desktop installed for other options but I was hoping that I'd be able to get the ability to publish this to some form of web interface and keep the SQL backend because there is other developing that I would like to do to this but I'd love to have the ease of using a web interface to interact with the program and since I'm not much of a web programmer, I was hoping I could stick with what I know in order to develop and just make it much more accessible to my users.

 

[spikepl]

What you are writing makes no sense to me. A web interface is another complication. Remote -access things like RD or LogMeIN let you leave your software as is, and have no bearing on what your frontend talks to in terms of backend.

 

[mikebrewer]

My real goal was to be able to continue to develop the app and just publish it without having to learn how to code a web interface. I have some reports that run, etc and I'd like to be able to just publish the database front end to a web site so people can run it without having to log into a remote desktop session. Then my users can bring up the site and run reports, enter data, etc., especially if they are not on their work computers and maybe on a home computer where they don't have a VPN setup or know the server name for Remote Desktop.

 

[spikepl]

What you write now does not fit with "I have an access database that I'm using at my organization and I have 1 user who is off-site ". Have the requirements changed between your post #1 and now ?

 

[mikebrewer]

no, not necessarily. currently I have one user who is off-site and the speed is killing me but down the road I do want it to be a little more accessible and even for the one user, it would be a lot easier to use a web site than RD every time.

The real question is... can it be done or not? The more I'm reading is sounding like it cannot be with the simplicity that I'm looking for.

 

[spikepl]

OK -so there are two different issues here.

One: how to help your offsite user right now, and that is RD or LogMe in. Forget about Sharepoint just for one user, unless you have plenty of time and funding.

Two: Provide Remote Access to other offsite users in the future. For this you can look into sharepoint, but your frontend will most likely need a revamp (check - try to publish and see what it says) , because some things are disallowed, or require different structuring of queiries and data. Coding a stand-alone webinterface in ASP/PHP/JSP is also a possibility. And depending on the number of external useres RD is still an option, or some Citrix.

 

[mikebrewer]

That looks like thats what I'm running into at this point. I was only going to point at Sharepoint if it had the ability to do what I want it to do (which it does not look like it will function the way I want) so I'll stick with RD for now (I have a lot of users doing this already) and maybe I'll look into the coding for building the site myself as for future use, it is really the best option.

Thanks for your time and help!