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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Working with Specifications without the Wiz

Access Howto:

Working with Specifications without the Wiz

by  coders4hire  Posted    (Edited  )
Ever viewed the System Tables in Access? Tools>Options>System Objects. You'll now see the additional core tables in Access. BE CAREFUL... back up any database you are working on so you don't muck it up!

AFTER you have a saved specification in the database, there exists the MSysIMEXSpecs and MSysIMEXColumns tables. You'll need to look up your specification ID in the Spec table to look up the columns in the Columns table.

You can make changes to the spec now. Be careful, many of the datatypes are coded, so it takes a little bit of work to figure it all out.

As well - you CAN'T ADD records (ie. add a column) using the table interface. BUT there is a workaround. You can use SQL queries to append additional records.

If you're really good, you could build dynamic specs on the fly with code, and call them using transfertext. Cool Stuff!

It beats rewriting a spec everytime you make a mistake!
Register to add this FAQ to your archive
Register to rate this FAQ  : BAD 1 2 3 4 5 6 7 8 9 10 GOOD
Please Note: 1 is Bad, 10 is Good :-)

Part and Inventory Search

Back
Top