How To Keep Track Of Documentation For BE / FE Revisions

Apr 1, 2007

Hello everyone,

I have been wondering about how I'm going to keep track of revisions for one of my databases.

Currently, I have the database split into a Back End (BE) and Front End (FE). In the work environment, the BE sits on the server, whilst all other 4 machines get a local copy of the FE. All table data in stored in the BE and linked to the FE.

I have recently got my act together and started documenting all the revisions I make to the BE and FE of the database. To do so, I created two tables with the following fields:

RevID (PK Auto increment),
RevDate
RevNumber
RevisionNotes
TimeDateStamp


I called them tblRevisions_FE, tblRevisions_BE. I placed both tables in the BE.

Whenever I make changes to BE / FE, I record it in the appropriate table.

However, because I often work on the FE of the database off site, I don't have access to the BE table (tblRevisions_FE) to record the new changes for the FE.

One alternative I thought of was just recording the revisions in a text document, and asking the client to manually record these in the tblRevisions_FE (via a FE form).

I did have tblRevisions_FE located in the FE, but when each db user got a copy of the FE, there would also be 4 copies of the table floating around.

Does anyone have any suggestions about how to manage documentation of FE revisions in this situation?

View Replies


ADVERTISEMENT

Index Documentation

Apr 6, 2007

Have the situation where a database backend is on a number of sites and if changes have to be made to the design structure of the backend database I would like to run a VB generated report to check that all indexes are correct. While this is not an issue with single field indexes, I have issues with multi field indexes.

Has any one got some ideas on reporting on this?

Thanks

View 11 Replies View Related

Creating Database Documentation/help

Apr 25, 2005

Hi I need to create a documentation - help system in my Access database. Can you give some guide lines and tips? General of course... like how to link a help file or something like that...
thanx for the helping hand

View 2 Replies View Related

Crerating A List Of Queries For Documentation

Jul 17, 2006

I'm attempting to create documentation for an existing Access database - literally, it's a work-flow document.

It was relatively easy typing out the list of tables, modules, and Macros, but I have god-only-knows how many queries.

Is there any way to export a text list of query names to include in my documentation?

Regards and thanks!

Susan

View 3 Replies View Related

Microsoft Monopoly Means No Documentation

Sep 19, 2004

I spent a great deal of time trying to load up a picturebox with an image stored in an Access data base.

The thing that was most troubling was the complete lack of documentation.

Every feature that exists in VB or Access had many, many man days spent in development. Which means that someone has extensive documentation on it.

Yet, when I went to Microsoft web site to look it up, I was told my product (access) was not supported in the us, but rather I had to pay $99 to speak with someone.

It is a shame that the Microsoft monopoly is able to steal from the consumers and the little developers. Not to get to political but i think it is unfortuante that the bust up of microsoft was averted. It is really a drag to the little developer the lack of documentation and proper development of so many features of their products.

Perhaps I am missing something but is there a place to find proper documentation on the various components - with examples of use?

View 8 Replies View Related

Examples Of System Documentation Needed

Oct 7, 2004

Hey all,

I was wondering if anyone has an example of a system documentation that could be shared. I'm about to start writing one myself and I'm not sure what to include in the documentation. Thanks in advance!

Regards,
Swee

View 2 Replies View Related

Help W/table Structure - Keep Historical Data - "Revisions" On Many-side Tables

Jun 1, 2005

Hope the thread title wasn't too confusing.

I have a database that tracks emissions from painting. Bear with me since this is going to be a long post.
:o

Some background info.
- a paint can consists of many parts mixed in a specific ratio.
- a part cosists of many chemicals
- a part may be used is many different paints

Here is how I have the existing database structured now. I’ve simplified it somewhat.

tblPaint
PaintID (PK)
PaintName - String
PaintDensity - Double
PaintVOCContent - Double

tblPart
PartID (PK)
PartName - String
PartDensity - Double
PartVOCContent - Double

tblRatio
RatioID (PK)
PaintID (FK)
PartID (FK)
Ratio - Integer

tblChemicalWt
ChemicalWtID (PK)
PartID (FK)
ChemicalID (FK)
WeightPercent - Double (Percent)

tblChemical
ChemicalID (PK)
strChemicalNumber - Long
strChemicalName - String

tblUsage
UsageID (PK)
PaintID (FK)
UsageDate - Date
UsageAmount - Double

PK = Primary Key (Autonumber)
FK = Foreign Key (Autonumber)

The Density or VOC Content (VOC = Volatile Organic Compound) for a paint can either be given OR it can be calculated by the mix ratio of parts and their respective Density or VOC Content values. One or the other must be complete.

What I did not account for was that there may be changes due to the paint manufacturer revising their paint composition, such as;
the parts that make up a paint may change
chemical make-up of a part changes (can be a change in Weight Percentages or the addition or deletion of a chemical).
ratio in which parts are mixed for a paint changes
Density/VOC Content values may change for a Paint or Part

The problem is that I cannot simply change the existing records as the emissions are calculated using all the data from each table and emissions need to be calculated using the paint/part/ratio/chemical weight percent info that was valid at the time of usage.

Another thing is that the Paint Name will not change, it’ll always be something like “BrandX Acrylic Blue”.

The person entering usage data only knows how much of what paint was used for a given day.

The person who enters paint usage has nothing to with entering the chemical make-up for parts and information for the paints and vice versa.

At any rate, my new draft table design is as follows. Two of the tables (tblChemical & tblUsage) will remain the same.

tblPaint
PaintID (PK)
PaintName - String

tblPaintVersion
PaintVersionID (PK)
PaintID (FK)
PaintDensity - Double
PaintVOCContent - Double
PaintVersionDateIN - Date
PaintVersionDateOUT - Date

tblPart
PartID (PK)
PartName - String

tblPartVersion
PartVersionID (PK)
PartID (FK)
PartDensity - Double
PartVOCContent - Double
PartVersionDateIN - Date
PartVersionDateOUT - Date

tblChemicalWt
ChemicalWtID (PK)
PartVersionID (FK)
ChemicalID (FK)
WeightPercent - Double (Percent)

I might be able to do away with tblRatioVersion and just have one table to store the mix ratios. It should be the case that a change in mix ratios (either a change in mix ratios and/or what parts make up a paint) means a change in the Paint Density & VOC Content. But I am presenting both versions of the Ratio tables here for completeness.

Version 1
tblRatioVersion
RatioVersionID (PK)
PaintVersionID (FK)
RatioVersionDateIN - Date
RatioVersionDateOUT - Date

tblRatio
RatioID (PK)
RatioVersionID (FK)
PartVersionID (FK)
Ratio - Integer

Version 2
tblRatio
RatioID (PK)
PaintVersionID (FK)
PartVersionID (FK)
RatioVersionDateIN - Date
RatioVersionDateOUT - Date
Ratio - Integer

I plan on having the DateOUT fields be populated automatically to match the DateIN for the new version. That way I can use “BETWEEN DateIN and DateOUT” to select the appropriate info for calculating emissions. The idea came from an old thread I started (http://www.access-programmers.co.uk/forums/showthread.php?t=31677&highlight=historical+data). I think this is the way to go, but with all the relationships going on, I'm having a hard time wrapping my head around it all. Am hoping someone here can help me with this.

Anyone see any problems with the new table design?
Anyone know a better way?
:confused:

Some potential issues that I see
If only the Density/VOC Content changes for a Paint, then the old set of records in tblRatio must be duplicated.
If only the Density/VOC Content changes for a Part, then the old set of records in tblRatio & tblChemicalWt must be duplicated.

Thanks for reading this post all the way to the end!
:D

EDIT: Thought about it some more.
A new version of a Part, should trigger a new version of Mix Ratios which in turn should trigger a new version of a paint.
Part --> Ratio --> Paint
Ratio --> Paint

Also, a change in a Part must trigger a New Paint version for ALL Paints that currently use it!
:eek:

View 3 Replies View Related

Track Changes

May 30, 2006

Hallo Everyone,

I am working with the database that consists of more than 15 tables with more than 50000 records and the problem is that more than 10 people use the database. So in this case I am not sure whether who has the changed the data in it.

So for this reason i need to create a logfile to determine what are all the changes made in the data in the database with the user who uses that.
(I need to create a history and save it.)

is that possible in MS ACCESS? if so can anyone tell me some suggestion


aravind.s

View 3 Replies View Related

Am I On The Right Track?

Apr 14, 2005

Hi! I am new to Access and am trying to create a database for my customers that tells me what product/service they avail of and the status of their payments.

My tables are

Customer Info
CustomerID
LastName
FirstName
Address
ContactNo

Products (A,B,C) ( A customer can only purchase one product)
CustomerID
ProductID


PaymentSchedule (Annual, Quarterly, Monthly)
CustomerID
PaymentSchedule

Annual Product Fees
Product
Fee

Quarterly Product Fees
Product
TotalFee
QuarterlyFee

Monthly Product Fees
Product
TotalFee
Downpayment
MonthlyFee

Am I doing ok so far? I wasn't sure How to make my tables since the amount payable is dependent on both the product type and the payment schedule. Any suggestions?

View 3 Replies View Related

Track Changes By Users

Mar 8, 2006

What is the simplest way to track who is making a change to a record and when they made the change? I've tried searching for help but I'm not quite grasping how to do this. Any ideas?

View 13 Replies View Related

How To Keep Track Of Hours?

Feb 5, 2005

Hi, I am trying to figure out a way to keep record of store hours, and days open for lots of different restaurants. The only thing I could up with is the following. I'm not sure how to keep track of store hours, or even the best way to make a table for hours. Any help is appreciated, thanks.


tblRestaurant
RestaurantID (pk)

tblRestaurantDays
RestaurantID(pk)
DayID(pk)

tblDays
DayID(pk)
DayName

tblHours
HourID(pk)
Time

View 6 Replies View Related

Track Field Value Changes. Please Help

Jan 24, 2006

Hi. I have a form with many fields. I want to track changes av 1 field to know the field value has been changed or not. I know about onchange event, but this only works when user inserts or changes the value. My form is being updated by macro/visual Basic. Is there any way to fin out if the value of a field has been changed automatically?

Thanks for any help!
metad

View 5 Replies View Related

Track Users

Aug 22, 2004

hello all... i tried to search an answer for my questions but i couldn't...

what is the easiest way to track users and their login time???

View 3 Replies View Related

Track User Changes

May 17, 2007

Is it possible to identify the user and date of a change made to a record in an Access 2003 Database retroactively the built in securiy features were not turned on?

View 2 Replies View Related

How To Track User Logins

Oct 3, 2005

Hi,

I thought this was posted here in the past, but I can't find it. I need a way to track when users log into an access database (username and time).

Is there an easy way to do this?

Thanks,

Keith

View 1 Replies View Related

Track Changes Made To Database

Mar 15, 2006

Hi guys,

Im fairly new to MS Access and have recently created a simple database to track the details of people in my department.

The database is on a shared drive and the idea was that when the details of the individual change, they open the database themselves and edit the appropiate field.

However, is it possible to track the changes that people make over a certain period (ie every month).

Thanking you in advance,

Jonny

View 1 Replies View Related

How To Track Utility Bills???

Jan 24, 2007

I'm interested in tracking monthly utility bills....monthly charges, units/volumes, costs per unit and so on, by monthly date. Would I be OK using a single table for my data, since it only involves gas, electric and water each month? How would I chart the data, so I could see trends (i.e., cost per volume, etc.)

Are there any sample projects out there that I might be able to adapt to what I'm interested in?

I'd be most appreciative if anyone has a comment, idea or suggestion. Thanks in advance!!

View 9 Replies View Related

Track/log Changes To Live Data

Mar 11, 2008

I have created a database that I am happy with, and I am about to receive information to populate it with. I know I am about to be asked to about security and logging of changes made to the data, which I know nothing about!!

As a result before I get into this part of my project I would like to know myself what is and what is not possible!!
Currently I have 2 tables and 3 forms, one of which is a sub form........ All changes will be done via the forms, adding new records, editing existing records or even deleting obsolete records.

•Is it possible to record any changes made to the live data?
oFor this to happen I presume that I need to setup users and access rights?
•What type of information can be saved if any?
oWhat form would this be saved in and where (a temp table?)?

While typing this a change of plan – if it is possible I am going to start building it regardless, as it will enhance my database.

Thanks

View 5 Replies View Related

Track Missing Records

Sep 12, 2005

Hello people. Iam having a problem and i need some help.
iam appending data in one table to data in another another.
I have two tables(table1 and table2), with the same fields but the records in one table2 are 5 more than those in table1 which are 3.
The 3 records in table1 are also in table2.
I would like a query which outputs the other 2 records that are in table2 and not in table1.

Thanks in advance.

View 5 Replies View Related

Modules & VBA :: Track User Log In And Out

Mar 27, 2014

I want to be able to track users log-ins on my DB, basically when a user enters their username and password I want the the time they log in and their username recorded in table. I tried doing it from the database found here: [URL] .... but I cant get it to work.

View 1 Replies View Related

Track Updates In A Dataset

Mar 21, 2013

I have a table into which users insert records through a user form, I need to track the updates made in a record in a data set and i have a user log in function, it needs to tell me who updated last and what did they update.

View 1 Replies View Related

Keep Track Of Stock Items By Query

Aug 14, 2006

Hy, I have this db where a user can purchase and item and total stock number needs to be updated.

I can calculate how many items are left but how to update the warehause table?

I can live without table updating, but if the same item is purchased multiple times my query return incorrect values as the number from which the formula subtracts is never changed.

See attached database.

View 1 Replies View Related

Query To Track Files Last Status

Sep 27, 2006

Hi folks,
This is my first posting to this forum and I hope someone will be able to help me out with this.
I have a table called FILETRANS in a DB.Essentially this table is to track the in-flow and out-flow of files in a documentation unit.
The schema of the table is as follows
Filetrans_id Pk int Auto
Files_id int
Filetransdate date
Filestatus_id int

A filestatus can either be 1(IN) or 2 (out)
I need a query that will give me a list of all files whose last recorded status is 2(out) and vice versa.
Any help will be greatly appreciated.
Regards
Charles

View 4 Replies View Related

Query To Track Revision History

Dec 28, 2007

I would like to track the revision history of table records. To do so, I have created tables with two-key fields. A typical table is tblPO_Data. The first key field is PO_Number and the second key field is PO_Revision. Data fields follow.

A key element of this table is that each record may have any number of data fields left blank AND later revisions may only show the "changed" field values.

To Illustrate tblPO_Data:

PO_Number PO_Revision Length Width Height Weight Quant UPrice
100 _________0___________10_____15___________________2 ____20
100__________1_________________________30
100__________2_________________________35____100
200 _________0_______________________________________1 ____10

NOW I would like to create a query that lists one record for each PO number, showing the most recently revised data. The desired result would look like:

PO_Number PO_Revision Length Width Height Weight Quant UPrice
100_____________2_______10_____15_____35_____100__ ___2____20
200_____________0_________________________________ ___1____10

Please realize that this is an example. There would be numerous one to one tables for each PO number to reduce the number of blank fields (ie. only tables with changes would be get revised records).

Can someone suggest a way to create a query to accomplish the above requirements, thanks in advance, Jeff...

View 3 Replies View Related

Track Users Computer Name & Network Name?

Nov 29, 2006

I have been searching and found a few great threads about checking users but the codes there were incomplete. Is there a way to effectively log a user's name & computer name when they open your database and also log when they close/exit your database. Without them noticing but just for your own personal security incase something happens and you would like to know who all was actually working in/on the database at that specific time?


Or just something that will show me who is in the database so I dont' have to keep seeing network333 something has it open.


Thanking you all in advance, and I know I am a P.I.T.A.!

View 5 Replies View Related

General :: Track Locations On A Grid?

Feb 16, 2013

I am writing a database to track our (and others) wine collections. i'm wanting to track what bottle is where. so i can look up what i have, look up where i have put it and away i go to get it, simple right?

just to complicate things i want a system in place. where the end user and use forms to add/remove or modify wine racks.

assuming that all racks are rectangular i would like to be able to add a rack and call it rack 1. rack 1 has 4 shelves all able to hold 5 bottles. the database would then say that bottle X is in rack 1 shelf 1 position 1.

if possible there will aslo be a screen that is auto generated by the database showing a simple grid with grrn and red squares denoting if the position if full or empty. the ability to click on a position to see what is in there or to add a bottle there would be amasing but not fussed if that can't be done.

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved