Q&A

Read answers to your most common questions about Bright Software

Ray D’Andrade, founder, Bright Software offers answers to your questions about fees, employees, competencies, and management style.


Products

1) Which products do you work with?

We work with all versions of these development tools:

  • MS Visual Studio .NET
  • MS ASP.NET
  • MS SQL Server
  • MS Access
  • Java
  • Oracle databases

2) What products have you integrated with?

We have integrated large and small applications into existing or new systems, including:

  • QuickBooks
  • MS Dynamics Great Plains
  • MS SharePoint
  • MS Dynamics Solomon

System integration is a real time saver and helps eliminate double-entry of the same data, reduces errors, and speeds business. For example, we integrated an accounting system for a customer that was ready to move away from paper invoices. We set up everything to transfer between the customer and their vendor, so invoices are now received electronically (via EDI) and the data automatically populates their accounting system.

3) Has our organization outgrown our Microsoft Access application?

If you use Microsoft Access, you already know it is a rapid application development (RAD) platform for databases and best for small to medium size businesses.

The following 3 considerations may indicate your business may be ready to move away from Access:

  1. Remote Users: If you have a large number of remote people that need to view the data, an ASP.NET web application may be a better solution for you. It depends on your needs. We have customers that use an Access front-end internally in the office, and have a small ASP.NET web component used by remote sales people that only has 10% of the functionality of the internal Access application. Terminal services can also be used to view Access applications remotely in some cases.
  2. Simultaneous Users: Another limitation of Access is the number of simultaneous users that can use the system. If you purchase a server dedicated to just Microsoft SQL, with multiple processors, 64-bit operating system, and plenty of RAM, you will get 80 to 100 simultaneous connections to the database without much problem. If you needs are any larger than that, a .Net application will likely be a better option.
  3. Application Size Requirements: The last limitation of Access is the actual size of the application itself. While, yes, you can create an extremely large application in Access with hundreds of forms, it really doesn’t make sense. Access if perfect for smaller applications in that they can be built quickly and full of functionality. If the application becomes very large, Access becomes more difficult to maintain. You would benefit from using an enterprise-level application development platform. The only “real” choices in this arena are the Microsoft .Net platform, and the Java Platform Enterprise Edition. Applications built in these platforms, are much easier to maintain when the application becomes large. There are many other developing platforms on the market, but among the majority of serious business application developers, these are the only two feasible options on the market for large applications.

We have a lot of experience in helping businesses redevelop their Access applications in .Net or Java to handle a larger application size. What generally happens is that customers get a taste of how powerful the technology is once they have it in their hands, and they start coming up with their own ideas on how to bring it to the next level.

4) So you do software, what about hardware?

Software is our main focus, but Bright Software is involved in hardware products if they are needed to help make your system work.

We have a complete hands-on understanding of server and network hardware. This helps us better understand your software project in context of your existing system. It also helps us troubleshoot problems.

5) What about product integration with peripheral devices like mobile phones?

We have experience in integrating all sorts of peripheral devices such as mobile phones, cameras, scales, and electronic signature pads.