INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Access Howto:

Working with Specifications without the Wiz by coders4hire
Posted: 31 Dec 03

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!

Back to Microsoft: Access Other topics FAQ Index
Back to Microsoft: Access Other topics Forum

My Archive

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close