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?
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?
Nasir Razzaq
Place it in the dropbox folder but you have to share it using drop box website.
ASKER
I forgot to mention that the other users don't have Access on their machines
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
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
If the database is simple enough, you might be able to use the Google Docs Spreadsheet instead of Access.
http://docs.google.com
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you. The fact that both of you said that really cemented things in my mind
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
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
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
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
<<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.
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.
<<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.
Didn't catch that comment first time around BTW.
Jim.