Go Back   Access World Forums > Microsoft Access Reference > Code Repository

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 04-24-2015, 05:44 AM   #1
magicscreen
Registered User
 
Join Date: Sep 2010
Location: New Jersey
Posts: 2
Thanks: 0
Thanked 1 Time in 1 Post
magicscreen is on a distinguished road
Update Users Database

These are some of the functions of the application.

There are two Zip files attached, one containing the application with some data and a second empty. Both zip files contain documentation.

Functions
1. Create a new table
2. Create fields
3. Add fields to an existing table
4. Modify fields in an existing table
5. Delete fields from an existing table
6. Add properties when creating new fields
7. Change properties for fields in an existing table.
8. Create Primary Indexes
9. Create Non-Primary (Secondary) Indexes
10. Delete Database Objects from the users database
11. Add Database Objects to the users database
12.
NOTE: Not all field properties are addressed with this application.

A. Properties and Attributes that can be added when creating a field
1. Field Type
2. Text Size
3. Field Description
4. Field Caption
5. Required
6. Allow Zero Length

Properties 2 7 can be modified.
Property 1 (Field Type) CANNOT be modified with this application
Field Name can be modified


B. Primary and Secondary Indexes can be set when creating or modifying indexes.

NOTE:
After entering an Index Name and Table Name the drop down list will reflect the Indexes and Tables associated with each other. To restore all tables and indexes to the drop down boxes, double click the appropriate drop down box then make a selection.

The system will make an attempt to determine if a duplicate index names and/or types exist and allow them to be changed.
Attached Files
File Type: zip UpdateUsersDatabase.zip (1.37 MB, 290 views)
File Type: zip EmptyUpdateUsersDatabase.zip (1.37 MB, 244 views)

magicscreen is offline   Reply With Quote
The Following User Says Thank You to magicscreen For This Useful Post:
hassanogaibi (06-28-2016)
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
[SOLVED] Can users without access installed update? danmack General 4 11-25-2013 02:36 AM
Question Multi users database: users to see changes in real time sm80 General 5 11-19-2012 06:57 AM
Update .accde files with multiple users konaan1 General 15 12-13-2011 12:58 PM
OLE field update by users in a form? Singlespeed Forms 2 07-23-2010 01:28 AM
Update users problem! hDLP Queries 2 01-23-2007 05:13 AM




All times are GMT -8. The time now is 12:55 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World