![]() MDB/.ACCDB file to LINK to data sources so you can see it or do ad hoc queries with it (Usage 2). Then SQL Server, or Azure SQL will take you to all ends you wish to travel to! Again, SQL Server Express is a good first step. It does fine for small businesses, many small business can work just fine within the constraints of security and size that the JET/ACE format limits us too, but once your needs go beyond those limitations, or you just need a standard repository to use across your company, the JET/ACE (Access) format should be migrated away from. The Access (aka: JET or ACE repository format) is not a up to par for corporate data. MDB/.ACCDB file format as a repository to store company info (Usage 1 and Problem 2 & 3), then don't! Use SQL Server. (this is not an MS Access issue by the way)ģ) Too many silos of data (ie: corporate data in stored on Jacks or Jills PC and they went up a hill for vacation). The common problems being sought to fix are:ġ) People are creating inefficient queries against data they don't understand. MDB/.ACCDB format as a data respository)Ģ) Access to data (not the application, but gain visibility to data that is stored in a non-MSAccess repository)ģ) As UI to data (Forms, Reports, or Queries against data from all sorts of repositories) ![]() I hear people / companies say they are migrating away from Access I often ask what they are using Access for, and what problem are they trying to solve by eliminating it from their environment.ġ) Store Data (ie: using the.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |