Avatar of Murray Brown
Murray Brown
Flag for United Kingdom of Great Britain and Northern Ireland asked on

Sharing Access over Dropbox internet folder

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?
Visual Basic.NETMicrosoft Access

Avatar of undefined
Last Comment
Jim Dettman (EE MVE)

8/22/2022 - Mon
Nasir Razzaq

Place it in the dropbox folder but you have to share it using drop box website.
Murray Brown

ASKER
I forgot to mention that the other users don't have Access on their machines
ASKER CERTIFIED SOLUTION
Jim Dettman (EE MVE)

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Nasir Razzaq

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.
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
joshbula

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
SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Murray Brown

ASKER
Thank you. The fact that both of you said that really cemented things in my mind
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

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
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
joshbula

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)

<<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)

<<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.
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes