Japanese (日本語)

dbSheetClient

What is dbSheetClient?

dbSheetClient allows you to create a system using the interface and functions you are familiar with from Excel. It has all the functions and standards you need to use in an office system.

dbSheetClient provides solution that can easily construct a rich client Web-enabled system that apply its frame to Microsoft's Excel and Access, applications that are most common in offices.
In this rapidly changing era, this tool not only makes system maintenance easy, but also allows for in-house system creation.
By developing a Web-enabled system in-house and then performing maintenance in-house as well, you can swiftly respond to specification changes as well as significantly reduce expenses.

All the input Excel data is updated and managed in a database. The data can be transferred from the database to Excel.
In other words, dbSheetClient uses the same interface as Excel.

Product Structure of dbSheetClient

dbSheetClient consists of a server version that operates on the server-side, an execution version that operates on a client-side, and a development version that creates the definition files that act as an instruction document for the execution version.

Challenges faced by using standardized Excel and Access files:

"Formalized Excel work" generally refers to work stages involving the distribution of Excel books standardized through work improvement activities to the same work managers.
Cumbersome Excel operations lead to mistakes! Excel Books are managed manually and below are some of the challenges faced;

  1. Sharing information on the file level.
    –File management is required for a number of participants.
    If files are sent and received frequently, it becomes cumbersome to manage freshness of data.
  2. Reliable data management is difficult.
    –No decisive data leakage/falsification control. Management is difficult because Excel sheets can be updated arbitrarily by workers.
  3. Aggregation of Excel books is cumbersome.
    –A massive amount of work hours is required for categorizing and aggregating Excel books.
  4. Sharing of information in real-time is difficult.
    –Information sharing is limited to a monthly level.

MDB files have limitations and cause problems. Client/Server type operation of Access face challenges stated below;

  1. The file can be damaged due to simultaneous access from multiple users.
    –Access is not a product that assumes the simultaneous access of multiple users. Data integrity can even be lost.
  2. File sizes expand rapidly each time a file is overwritten.
    –The maximum size of a file allowed by Access is 2GB. For files larger than that, you need to allot and use MDB.
  3. Due to the increase in data processed by Access, the processing speed becomes extremely slow.
    –In the case of a link table, the network between the server and client computers will experience a very heavy burden.
  4. It's easy to copy Access files, so there is a risk of information leakage.
    –Leakage of information sometimes leads to corporate complaince problems.
  5. It's difficult to create a Web-enabled system using WAN connections.
    –With Access, it's possible to construct a stand-alone or client server system, but it's dificult to make a Web-enabled system.

Why dbSheetClient?

dbSheetClient is a tool that is extremely efficient for creating a Web-enabled system for Excel work. Since the Excel sheets and the DB on the server are directly linked, the chart on the Excel sheet is just a screen format, and the data input on the screen is directly input to the DB by pressing the "Register" or "Refresh" buttons. Therefore, even if the application is opened by many people, only one Excel book is needed. Also, by using the functions of the server version, you can easily achieve central management of resources and the establishment of a secure environment. Furthermore, the data in the database, offers easy achievement of categorizing and aggregating Excel books and also sharing information in real-time.

dbSheetClient allows for data in Excel books to be stored not only in the Excel workbook but in its database. As a result, complex procedures to collect data from Excel books for calculation becomes unnecessary.

Benefits of dbSheetClient using Excel;

  1. Provides direct linkage between Excel and the database(DB)
    –Only one Excel book is necessary. It's also easy to centrally manage other resources.
  2. Easy establishment of security
    –Easy construction of structures for permission management and log management.
  3. Automatic categorization and aggregation of Excel books (Benefit of DB construction)
    –Reduction of massive amount of work hours needed to aggregate the Excel books.
  4. Sharing of information in real-time (Benefit of DB construction)
    –The second the data is updated in the DB, you can easily share information in real-time.

See How You Can Use dbSheetClient to Create Web-enabled System Using Excel: »

For Access version, you can create the program in Access and call for the dbSheetClient function by API.
Therefore, it's relatively easy to upgrade to a Web-enabled Access system. Also after upgrading to a Web-enabled system, system maintenance by persons who understand AccessVBA becomes possible. Therefore, even with a rapidly-changing environment, you can achieve development and operation of a system that the workers will enjoy.

Access file based operations can become a web-enabled system using dbSheetClient, so valuable local data can be turned into even more effective management data.

Benefits of dbSheetClient using Access;

  1. Use SQL Server (Oracle) to ensure data reliability and durability
    –Migrating (upsizing) from Access to SQL Server (Oracle) virtually solves the problems (1-4) stated above that are faced by usage of Access.
  2. Construct a company-wide Web-enabled system with Access at the front end
    –Use Access' expressiveness and usability to construct a Web-enabled system that can support WAN circuits. (Problem 5)
  3. Use your existing Access to significantly reduce development and maintenance work hours
    –You can perform development in a short time to make the most of Access' resources, such as forms, reports, queries, modules, macros, and table definitions.
  4. The server version resource management function supports your corporate internal control
    –Use the database control, permission management, log management, and unauthorized access prevention provided by dbSheetClient server version to heighten security.
  5. You can use Access VBA technology to construct a Web-enabled system
    –You don't have to learn server languages, such as Java, PHP, and ASP.NET. You can move development and maintenance to in-house operations.

See How You Can Use dbSheetClient to Create Web-enabled System Using Access: »

Screen shots of dbSheetClient system

Below are screen shots of dbSheetClient system, which replaced Excel book based operations. In doing so, previously used Excel files are retrieved and re-used in dbSheetClient system as they are. Therefore, introducing a new operation by dbSheetClient costs less effort, even to the end users.

PL Monitor

PSI

Ability evaluation management system

Screen shots of our customers’ cases

Below are some of the screen shots of our customer, Ichimiya Transportation Co., Ltd's.

Customs clearance/work result data

Quotation management

Customer management

To Summarize:

If you want to make your end-user Excel or Access work into a system with:

  • Immediate data delivery and sharing;
  • Smooth data reporting and processing;
  • Automated data processing;
  • Strict role-based access control and secure user authentication;
  • Multiple personnel use in multiple distant locations;
  • In-house development;
  • Short-term development;
  • Tight/small budget;

Get started today with dbSheetClient! »