Roger's Access Library Homepage
Forum Home Forum Home > Other Download Libraries > Access-L Developer's Libraries > Farthing, Randy
  New Posts New Posts RSS Feed -
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Please consider donating $1 per sample downloaded, (find out why here)

 Post Reply Post Reply
Randy Farthing View Drop Down

Joined: 24 Jun 2008
Status: Offline
Points: 1
Post Options Post Options   Thanks (0) Thanks(0)   Quote Randy Farthing Quote  Post ReplyReply Direct Link To This Post Topic:
    Posted: 10 Jul 2008 at 5:36am
This app is designed to change field names for tables destined to move to Oracle. A button on the main form will capitalize field names, substitute "_"s in place of spaces, optionally place a "_" in front of upper case letters imbedded within the field name, the turn the whole field name to upper case. It will change format for all fields, but reports any fields longer than the 30 char Oracle limit. This may not be perfect, but in aN Oracle conversion, this did save me more time than it took to create.

This is written in Access 97. Hasn't been tested in any other version.

Download Access 97: uploads/11/

Back to Top
Sponsored Links

Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down