Sharing Access over Dropbox internet folder

Murray Brown
Murray Brown used Ask the Experts™
on
Hi

I have an Access database that I want to share with other userrs using the Dropbox shared internet folder. How do I go about this?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2012
Top Expert 2014

Commented:
Place it in the dropbox folder but you have to share it using drop box website.
Murray BrownASP.net/VBA/VSTO Developer

Author

Commented:
I forgot to mention that the other users don't have Access on their machines
President / Owner
Most Valuable Expert 2017
Most Valuable Expert 2012
Commented:

  JET/ACE was not designed to run over a WAN.  It will, but you'll have varying degrees of sucess and over the Internet, not much.

Jim.
Most Valuable Expert 2012
Top Expert 2014

Commented:
They would have to download it locally. I am not sure if dropbox syncs shared folders within your own folder. If it does, that would be easier.

Commented:
Dropbox only syncs the file between the machines, so if the users don't have Access on their machines, they can't use the Access file.  

If the database is simple enough, you might be able to use the Google Docs Spreadsheet instead of Access.

http://docs.google.com
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
Top Expert 2007
Commented:
"JET/ACE was not designed to run over a WAN. "

:-)
Murray BrownASP.net/VBA/VSTO Developer

Author

Commented:
Thank you. The fact that both of you said that really cemented things in my mind
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
Top Expert 2007

Commented:
Sorry, but that's not what I'm saying at all.  So, you may want to redo the points. The smile was for a different reason.

JET/ACE was not to designed to run over WAN's of the early 90's, but with today's High Speed, stable WAN's (especially fiber optic) that *many* companies have, it's a different story entirely.  Under the right scenario, JET/ACE has no problem running over a WAN.   And as I've mentioned in other Q's, I invite anyone to drop by and see this in action :-)

mx

Commented:
Since the author said the other users don't have Access on their machines, is Jet/Ace even an option anyway?  

Dropbox is a service that syncs files between computers over the web.  You need something to read that file on each of the machines.  Or, eliminate dropbox and access all together and go with a web-based solution such as google docs.  

Office365 might be a viable solution for you also:

http://office.microsoft.com/en-us/access-help/move-your-data-to-access-and-office-365-HA102610172.aspx

Jim Dettman (EE MVE)President / Owner
Most Valuable Expert 2017
Most Valuable Expert 2012

Commented:
<<JET/ACE was not to designed to run over WAN's of the early 90's, but with today's High Speed, stable WAN's (especially fiber optic) that *many* companies have, it's a different story entirely.  Under the right scenario, JET/ACE has no problem running over a WAN.   And as I've mentioned in other Q's, I invite anyone to drop by and see this in action :-)>>

  Yes but as the question stated, a "shared internet folder." is not going to cut it.

   and with that said, I'm wondering if the "sharing" is what I thought it was.  I thought he was sticking a MDB/ACE file on a folder out on the net, users would have Access and be using this file across the internet.  

   If these users are simply downloading the file and using it locally, then that's another story.

  But across the Internet, there are only a few options:

1. Use a service like www.eqldata.com - Plug and play, but I don't know of anyone that's used their service first hand yet, so be careful if you decide to try.  And of course the downside is the recurring costs.  Overall though, for a company that wants to share out a DB with only a few users and has little IT resources, this is probably the best approach.

  and the usual cavets/warnings here; I'm not affiliated with them, have never used their products, etc - so make sure it works if you decide to try and let us know.

2. Use terminal services - Plug and play, but costs.  No recuring costs as far as the software, but you do need to maintain the server.

3. Use Citrix on top of terminal services, allowing you to access a TS box via web browser.  Plug and play, but costs a bit and again no recuring costs really, but you do need to maintain the server.

4. Write a web site interface for the DB and host it on a web site - lots of work

5. Use Access 2010 and Sharepoint 2010 - Costly with quite a few restrictions (to me, no VBA is the biggest).

6. Office 365 may be a possibility as has been mentioned.

  Sorry for not getting a clearer picture of the situation first.

Jim.
Jim Dettman (EE MVE)President / Owner
Most Valuable Expert 2017
Most Valuable Expert 2012

Commented:
<<I forgot to mention that the other users don't have Access on their machines >>

 Didn't catch that comment first time around BTW.

Jim.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial