Sign up now and get videos as they're finished and posted to the web site. You can participate in development, ask questions, and possibly have them answered in the next video. Enroll now for a discounted rate because once the Seminar is finished, the price will be going up.
Feel free to post your questions or comments below
Hosting Access on OneDriveLink Jason Steward Mon 8/3
Can't you just host the split application on OneDrive and forward a copy of the frontend to whoever you want? Seems much easier.
Jason, excellent question. The answer, in a nutshell, is NOPE. Unlike Word and Excel files, Access requires a continuous connection to the record-locking LACCDB file for it to work properly with multiple users.
I've tried with OneDrive and with Google Drive. The only way this works is if you can "check out" the database. In other words, User A downloads the file, DELETES it from the server, uses it, re-uploads it, and then the next person can use it.
I've had SOME success with a synched Google Drive folder on your local PC. This only works with REAL small databases. Essentially, you can install Google's synch software which keeps all the files in synch between your desktop PC folder and your Google Drive. You can share this folder with other users, but the files aren't synched in "real time." So what you can do is create a lock file (a simple .TXT file for example) to indicate that the database is in use. When you close the database it deletes the lock file. It's not perfect, but it works for small files that can synch up quickly.
This is a good solution if you are the only user and want to share it with yourself between multiple locations. Use the database in the office. Close it. Drive home. Use it there. Close it. Drive to work the next day. The file should stay synched during your drive time AND if you accidentally leave it open at work (or a colleague goes to use it) then the lock file will let you know. I've actually built this as a solution for a client, and it works pretty well. If anyone wants to see how it works let me know and I'll post a lesson on it.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.