![]() Exports to various formats including Excel, CSV, SQL. ![]() If you double click a record it opens in a separate window – great for reading long text entries.Supports MDB but ACCDB support is available via in-app purchase £9.99.Filter, sort and search functionality allows you to easily find the information you need.Exports to various formats including CSV, TXT, Excel and SQL.Opens tables from multiple databases at same time.Does not support queries, forms or reports Opens MDB and ACCDB files (2007 only, not 2010/2013).However, there are, at the time of writing, five apps, all available from the Mac App Store, which allow you to open and view data in Access database tables. Yes you read that correctly! Up until recently, there was no way to open a Microsoft Access database directly on a Mac. I wouldn't put my company's data in that jeopardy.UPDATED JUNE 2017: Prices updated and a 6th app added… But, none that we've come up with actually solve the problem since mistakes happen and the methods all rely on people to not make mistakes. You might be able to work out some convoluted method of ensuring that only a SINGLE user has the db open at any time. When you close the database the cloud version is OVERWRITTEN so any changes you make to the database REPLACE the entire cloud version clobbering the version that your coworker just updated. Since the lock file would open on the local drive, NO ONE ELSE COULD EVER SEE IT so no other open copy of the db could ever be aware of any other open copy of the db. laccdb that opens in the same folder as the BE. As Doc said, it has nothing to do with the version of Access since they all handle sharing essentially the same way with a lock file. Did you not understand that? He can probably post a link to one of the other threads where he goes into much more detail. Doc has pointed out very clearly the difference in how the cloud drives work and why that prevents you from sharing an Access BE or even monolithic db on one of them. There are also third party options for RD and Citrix but they are fairly pricy for a small business and run ~ $40-$50 per seat per month but they do the maintenance and setup so you don't need technicians to do it for - Apparently you haven't read any of the threads from people who ignored the advice or just did it without coming here first. There are third-party services to host SP but I don't know what they charge per seat. Again, you need a server and SharePoint licenses. If your tables are no more than 5,000 rows, you might be able to use SharePoint to host the BE and connect the Access FE to the SharePoint lists. You would need to convert the BE to SQL Server and possibly change a lot of the application to use good client/server techniques if it doesn't already and it still won't be as fast as you'd like but it will be usable.Īny other method requires changes to the application and more software. You can use a VPN but if the BE is Jet or ACE, the application will be excruciatingly slow. You instantiate "desktops" on the server. Citrix, if you host it your self is a little more sophisticated than RD but the concept is the same. I'm not sure how much the license is for this but it is probably more plus you need an actual server. This instantiates a "desktop" for each user on the server. Another more costly implementation is to run a server version of RD. Professional versions of office come with the seat licenses you need to do this. If you have desktops in the office, you can set up RD to allow people to remote into their office PC and work as though they were on your LAN. Remote Desktop and Citrix both work very well can be implemented with either no changes to the app or perhaps some small changes. There is no cheap way of putting Access on the web but there are simple ways. There are lots of threads here on the topic with pretty detailed explanations of why this technique does not work. The way the sharing works for Access is quite different from what is needed for Word or Excel. Cloud drives operate very differently from those on a LAN and they CANNOT support shared access to an Access database. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |