Print Page | Close Window

Printed From: Roger's Access Library
Category: Other Download Libraries
Forum Name: Farthing, Randy
Forum Description: Randy Farthing's Library
Printed Date: 25 Nov 2020 at 8:47am
Software Version: Web Wiz Forums 12.03 -

Posted By: Randy Farthing
Date 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/


Email: -

Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.03 -
Copyright ©2001-2019 Web Wiz Ltd. -