X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Reply to this topicStart new topic
> Update Users External Database, Access 2010    
post Apr 21 2015, 08:44 AM

Posts: 450
Joined: 18-November 07

This application was written as a learning tool.
It has been tested but please retest before using.

A short user manual is included in the Zip file.

1. Purpose
Maintain Users MS Access Databases

NOTE: This application was NOT tested using .MDB files. It is was written using MS Access 2010.

2. Method to use the system
First make a copy of this template.
Next copy all necessary Tables, Queries, Forms, Reports and Modules from the update database to the copy of this database. These objects will be used to update the user’s database.

NOTE: ALL Database Objects that are part of this application begin with the letters “zzz”. This was done to make it easier to distinguish between the applications objects and the user’s objects. Hopefully, this will place the objects used by this database to the bottom of the list.

NOTE: The Re-link Tables form in this database is included in the Zip file as a stand-alone form.

3. Some 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

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.

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 File(s)
Attached File  UpdateUsersDatabase.zip ( 1.37MB )Number of downloads: 124
Go to the top of the page

Custom Search
RSSSearch   Top   Lo-Fi    23rd March 2018 - 11:39 PM