Access之后我们将做什么? [英] What will we do after Access?

问题描述

Microsoft似乎对折腾数据库工具的瑞士刀一事无成.寻求/文件交换/克隆/名称-您的缩写-连接任意数据库服务器/电子表格/CSV/平面文件还有什么其他优势呢?

Microsoft seems hell-bent on deprecating the swiss-army-knife of database tools. What else comes close for facading/file-swapping/cloning/name-your-acronym-connecting arbitrary database servers/spreadsheets/CSV's/flatfiles?

您从Access中挤出了哪些奇怪的功能?还有什么代替它?

What weird kinds of functionality have you squeezed out of Access? And what else is there to take its place?

推荐答案

访问权限不是DBMS.或者至少不是仅仅是一个简单的DBMS.这是一个非常好的RAD环境，是一种以图形方式创建SQL代码的简单方法，并且是成熟的DBM的常规前端.

Access is not a DBMS. Or at least it's not just a simple DBMS. It's a very good RAD environment, a simple way to create SQL code graphically, and a regular front-end to fully fledged DBMs.

SQL Server(Express或MSDE)或Oracle，MySQL等都不会永远替换它，直到它们与简单的编程语言，Crystal Reports之类的工具以及适合初学者的方式集成在一起无需学习SQL就可以解决问题.

Neither SQL Server (Express or MSDE) nor Oracle, MySQL, etc. will ever replace it, until they come integrated with a simple programming language, a Crystal Reports like facility and a way for beginners to get around without having to learn SQL.

在我的第一份专业工作中，我完全在Access中开发了一个非常大的系统.客户的前端，我的管理前端，管理的报告和监控，每位用户的权限，在特定时间运行的自动任务等.因此，我开始学习它的许多缺点和优势.

At my first professional job I developed a very big system completely in Access. Front end for the clients, admin front for me, reports and monitoring for management, permissions per user, automatic tasks run at certain times, etc. I came to learn a lot of its flaws and strengths as a result.

我见过用它完成的奇妙应用程序以及一些废话.我仍然将其用于个人项目，并且不会为它感到羞耻(例如Sudoku播放器或Karnaugh映射实现).有一个MVP完全在Access中创建了Paint克隆，尽管我认为那是极端的.

I've seen marvelous apps done with it, as well as pieces of crap. I still use it for personal projects, and ain't' ashamed of it (for instance, a Sudoku player, or a Karnaugh mapping implementation). There's an MVP who's created a Paint clone completely in Access, though I believe that's extreme.

访问"珍珠:轻松测试数据库设计构想并为您创建草图，报告等，这是很好的.如果您更改列的名称(甚至是表，尽管有时会失败)，很高兴看到所有对该名称的引用已自动更改为新名称.我渴望在VB6上使用子窗体"控制岩石.而且"Thunder"按钮可以对表进行重复过滤，这很棒，我希望在SSMS上有类似的东西！

Access' pearls: It's nice to easily test a database design idea and have sketch forms, reports, etc. created for you. If you change a column's name (or even a table, though that fails sometimes) it's nice to see all references to that have changed to the new name, automatically. The "sub-form" control rocks, I longed for it on VB6. And the "Thunder" button to do repeated filtering on tables is great, I wish I had something like that on SSMS!

这篇关于Access之后我们将做什么?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！