Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Telecom?

Status
Not open for further replies.
digilink

digilink

Technical User
Dec 10, 2002
2
US
Anyone here work in Telecommunications that can point me in the right direction? I am looking to build a small Access database for circuit inventory using Access and VB 6.0 I have minute programming skills, the biggest problem I am having is designing something that is effective. My biggest design goal is to have a form to enter information, submit a query, and have it return the results to me. I would like to keep the tables in Access and use SQL statements to create, add, delete, and query records. I am just unsure of the approach I should use as far as table relationships go? Anyone have any experience with this? I am looking to design a database that begins with our highest level circuit(OC-48) all the way down to a singe T1 and possibly even a DS0. I thought of creating a table for each high level circuit we have and creating relationships based on their cross-connect in the office.(DACS, DSX, etc) Any info or help appreciated!!!!

Thanks
 
Sort by date Sort by votes
It would be almost impossible to suggest how to create your database via a forum. There are too many variables. What you should do is pick up a book on database design and / or data modling. Even a VB book with a chapter or two on the subject would be helpful. I can't remember the name of the book that I have, I think it is called VB Database Programming published by SAMS. I could be wrong, it's at home right now.

You could also check the web for some free tutorials on the subject. You can try and Look for tutorials on database design, ADO, SQL and VB database programming.

ADO are active X data objects used in VB to connect to and manipulate data from a database. You will probably end up using these objects or other similar ones in your app.

If you run into some specific problems then post again. Thanks and Good Luck!

zemp
 
Upvote 0 Downvote
FYI, the book I mentioned is called 'Database Access with Visual Basic 6', written by J.P. McManus, published by SAMS, ISBN 0-672-31422-3.

I was close! Thanks and Good Luck!

zemp
 
Upvote 0 Downvote
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top