Stats

  • Locked Locked
  • Replies 1
  • Subscribers 165
  • Views 12696
  • Members are here 0
More Content
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Access database interface

Lock2002

Anyone using Microsoft Access for their CIS database? That's what we are using but we would like a interface to limit the "hands on" access to the Access database. We are currently using an Excel based program that utilizes MathCAD (don't ask, I don't know), but it's not as functional as I would like. Anyone have any suggestions?

We currently have a process where one requests or creates the part and it gets saved in the database as "preliminary". Then someone checks it and it becomes "released". The "requester" and "approver" info gets saved into the database.

 

 

Thanks 

 

  • redwire

     You can use Access with passwords.  A user can create a "new" part, which is just temporary, by using the CIS interface.  The librarian can go into Access with the correct password and create the final part and its description.  The ODBC interface allows you password access to the database.

Cadence Guidelines

Community Guidelines

The Cadence Design Communities support Cadence users and technologists interacting to exchange ideas, news, technical information, and best practices to solve problems and get the most from Cadence technology. The community is open to everyone, and to provide the most value, we require participants to follow our Community Guidelines that facilitate a quality exchange of ideas and information. By accessing, contributing, using or downloading any materials from the site, you agree to be bound by the full Community Guidelines.