Export Structure

Mar 23, 2007

I'm trying to find a way to export the structure of a table in my Access database.

I created a new table and I want to put it in the database on my website. However, my site is constantly being used so I have no way of downloading the database, modifying it, and then uploading it again without losing some data.

I do have a database editor on my website that allows me to run queries. So If I can get a query with all of the CREATE TABLE information (all the fields, whether they are Allow Zero Length, etc.) then I can just use that.

I can't seem to find a way in Access 2000 to export the structure of the table.

The database on my website is also Access 2000.

View Replies


ADVERTISEMENT

Export Structure?

Mar 22, 2007

I'm trying to find a way to export the structure of a table in my Access database.

I created a new table and I want to put it in the database on my website. However, my site is constantly being used so I have no way of downloading the database, modifying it, and then uploading it again without losing some data.

I do have a database editor on my website that allows me to run queries. So If I can get a query with all of the CREATE TABLE information (all the fields, whether they are Allow Zero Length, etc.) then I can just use that.

I can't seem to find a way in Access 2000 to export the structure of the table.

View 3 Replies View Related

Export An Access Database Structure (i.e. No Data)?

Jan 30, 2007

If I want to duplicate just a table, I can easily select "structure only" under paste options. Is there an easy way to do the same thing for an entire database (tables, queries, etc.) all at once?

In short, someone has a database. They're willing to share the database itself, but not necessarily its contents. The database has a user interface, so the people who use the database don't necessarily know much about Access. Therefore, I can ask them to follow a few basic, built-in Access menu options, but can't ask them to do something manually, such as copying the entire file and then manually emptying the tables. This seems like something that should be easy, but I can't find it. Any help?

Thanks,

Rhythm

View 4 Replies View Related

Export The Export/import Specifications For Text Files

May 10, 2007

Hello,
Does anyone knows how can I export the export/import specifications (which file/directory) and how can I import/export the specifications between different versions of Access. Thanks!

View 3 Replies View Related

Help With Structure

Dec 7, 2005

I have a database to record documents received on a project. 2 main tables, documents and revisions, each document can have many revisions. I have now been asked to add a section in for actions against each revisions, that is each revision can have many actions. Am having problems understanding how to add this table. The current database has several hundred records already and I do not really want to re-enter. Can someone help.
TableDocument: counter(primarykey,autonumber), DocNumber, DocTitle
TableRevision: counter, revision, DateRec'd

View 2 Replies View Related

Sample DB Structure Ok?

Oct 27, 2005

Hi all,

I am on my way to building my first relational DB. Is anyone able to look at the attached sample and tell me if I am on the right track?

The DB is being desined to record Repair information carried out on a machine. (TblRepair)

The DB will also eventually record refurbished machines (TblRefurb) and also many other situations like stock control, etc.(yet to be designed). Before I go on I just want to check:

> Is this roughly correct so far?
> If I create a new record in the existing form, why can I not enter both UnitID and EmployeeID? Relationship conflict?
> Should I be building forms on a query? (I think the answer is Yes, just need confirmation).
> Is it because of a problem with the query I cannot enter details correctly? (as per the above question).

Any pointers would be very welcome. PS Sorry its v.old A97!

View 2 Replies View Related

Better Program Structure

Dec 16, 2005

Hi all!

I have created a database with auto-archiving features. I have "working tables" that are populated when the product is moved to the correct process, in this case when it reaches the test department. When the product is moved out of the relevant process, the database runs several queries which archive the relevant data and deletes the records from the working table.

There are two working tables in the test department, one for test failures and one for rework activities. The question at hand is WHEN should I populate the working table for rework activities:

Option 1: Populate the table when the product moves to the relevant process. This will create and delete thousands of records from the working table every day. Using this method will cause my table to bloat to 50,000+ records that are constantly updated, appended, and deleted.

Option 2: Populate the table when (and IF) the product fails a test. This will keep the table to a much smaller size (around 2500 records) but requires the database to run several queries in the middle of the data entry process, significantly slowing my program.

So which is the faster/better process: Filtering a table of 50,000+ records or appending the working table when you need the data?

View 1 Replies View Related

Database Structure

Feb 14, 2006

Is there any way to keep track of a database structure in access? For instance, which query relates to which report? Sometimes I create queries that are no longer needed but if there are a lot (which there are!) it can be easy to delete one that's needed.

View 5 Replies View Related

Database Help - Structure

Mar 5, 2006

I created a database to track tardies and absences of my employees. I would like to be able to sum the number of absences and tardies for each person per month and graph it.

Per our attendance policy, 6 tardies = 1 absence. I need to take the total number of tardies that month/6 and add to the total absences that month to equal the total attendance for the month.

I need help. Can you please view my database and give me some ideas?

Thanks,
Jason

View 1 Replies View Related

Relationship Structure Help

Nov 6, 2006

Hi everyone

I would appreciate some help redesigning a database structure.

Currently the database has a table holding students personal details. Linked to this table with a one-to-many link is a table holding subject reports.

Also linked to the student table are two other tables holding prior attainment and mentoring details. These table are linked one-to-one.

Personally I believe the two tables linked with one-to-one links should be merged with the students table to become one single table holding student data.

Is this right?

View 3 Replies View Related

Structure Field Name

Jun 11, 2007

I have 2 tables.
1 tables cointains field_name

2 tables contains data


I want to create a query that I could use the field_name from table 1 (loop thru table1 )to see if the field_name exist in table 2

thanks

View 2 Replies View Related

Need Help With Table Structure

Oct 28, 2004

Here’s a little scenario:

An engineer requests that “x” amount of computers are ordered for the company. The estimated costs of the system(s) are determined. The estimated cost of the systems is forwarded to a manager, and the request must be approved by a manager before the order is placed. Once the manager approves the request, the order is placed through the ordering company. After the ordering company approves the order, an order number is assigned and serial number(s) specific to each computer is associated with that order number. At this point it is possible to track the order status via existing programs using the assigned order number and serial numbers. After it is determined through the existing software that the order has been shipped, invoiced, and received by the Receiving department, I need to physically go pick up the systems and submit them into my Central Inventory. From the central inventory, systems will be checked out to employees as needed, checked back in when testing is finished, or transferred internally between employees......

View 1 Replies View Related

Table Structure

Nov 15, 2004

Hi everybody,

Please, I really need some help with my normalised tables and relations:

1.AdmissionID
AdminYr
.......

2.StudID
SName
AdminID
.........

3. ParentContactID
Fname
StudID

4. CycleNO
cycname
.....

5. DisciplineID
Discname
CycleNo
StudID
.......

6.SubjectID
subName
DiscID
....

7. ExamID
examdate
StudID

8. Results
StudID
ExamID
mark
......

I have a feeling this relationship, is still a bit messy?

I also need to keep track of students daily class attendance, at the end of the tern, or year to find out how many students dropt out of a particular class etc. Is this a new table?

thanks in advance.

haag

View 3 Replies View Related

3nf Table Structure, I Think, No What?

Dec 15, 2004

I have been reading up on normalizing table structures. I have this database that I am working on, to work as a hiring database. It should hold information about people applying to the law firm I work at.

I am looking for advice on if this table structure is normalized and sound. I am also looking for specific help on creating good forms.

Thanks for any help that can be given!

ps. I am attaching a zip that has a jpg view of the tables and their relationships, as well as the db with the table structure.

I would love any and all advice. I want a very clear concept for this db before I do anything!

Thanks again!
:D

View 2 Replies View Related

Structure Dilema

Feb 21, 2005

hello all

Consider i have an employee database.
And i want to keep a track and analyze all the training programs every employee has attended from the day he joined ( for both working and resigned employees).
The analysis part is based on division-wise, level-wise, year-wise, location-wise, trainingtype -wise etc..

I have a main employee database with his ID, name, location, age. And i have created seperate tables for his designation, dept, training program, year ,etc...THe reason for this is that the departments, designation , training programs available within the company get updated often. And I have created relationships between them.

When an employee resigns or leaves the company, i have to store the records, but I dont need to update it.
One option is ; whenever a employee leaves the company delete his related record and transfer them to to another table called OUT_Emp.
Just the delete the employee record from the Employee table. And keep the other relationships intact.

Or should i create seperate database and transfer all the tables from the main database, just for the employees who have retired, resigned or suspended. THis database will contain all the tables that the main table has along with the relationship.


I really suck at one liners :D

View 4 Replies View Related

Help With Database Structure

Apr 18, 2005

I am designing an application that tracks information on Choir membership and sheet music that we have on file. I am starting with a database of church members. There are four different choirs and choirs share some members. Some members of some of the choirs are also not members of our church so I will have to place non members in the member table. I am new to database design and would like the collective wisdom of this list to tell me of any problems I may encounter before I start doing any detail work.

What is the best way to deal with someone who is a member of more than one choir and may belong to a different section in this other choir (Tenor in one and Bass in another). An individual may also hold different offices in various choirs.

The table structure I have is as follows

CHURCH MEMBERSHIP DB:
MemberId Autonumber (pk)
FirstName, Text
MiddleName, Text
LastName, Text
DateJoined, Date
Phone, Text
Address, Text
City , Text
Zip, Text
EmailAddress
BirthDate, Date
Member, Boolean

CHOIR MEMBERSHIP DB (How do I efficiently track someone in > 1 choirs)
MemberId, FK
ChoirId, FK
FolderNo
RobeNo
Section
ChoirOfficeId, Fk

CHOIRS DB (This lists the various choirs in the Church)
ChoirId, pk
ChoirName, Text
DirectorId, FK (Pointing to Member DB, Person may not be member of any Choir)

MUSIC DB
CatalogId, PK
Title
Composer
Arranger
Type (Single Copy/octavo or book/collection)
PublisherId, FK
PublisherNumber
VoicingId, FK (From table with possible voicing)
NumCopies
UsageId, FK (Where in the service is it appropriate
Location, Text (Where in the filing system, or off site)
ClassificationId, FK (List of classification/genre in table so can update)

PUBLISHER DB
PublisherId, PK
PublisherName
PublisherAddress
PublisherPhone
PublisherWeb
PublisherContact

MUSIC CLASSIFICATION DB
ClassificationId, PK
Classification, Text (Christmas, Easter, general anthem etc)

To be able to track performances and plan services and performances I have the following table.

PERFORMANCE DB (This is to keep track of and plan the regular service)
PerformanceId, PK
Pdate, date (Date of Past/Planned performance. Possibly more than one per day)
ServiceTypeId, FK (From table of types of performances – morning service, evening, etc)
Location
Speaker
Pianist
Organist
Introit
Invocation
Anthem
Meditation
Benediction
(etc)

I would also like to be able to prepare mailing labels for the various choirs as well as the general membership from this DB. My primary focus will be on the music. I would like to have an efficient music DB that I may find out what music I do have and when I last performed them, what options for performance (usage and classification)

Would be grateful for your comments, Thanks!!

Rmiller

View 7 Replies View Related

How Do I Structure My Tables?

Apr 21, 2005

I don’t understand how to structure tables and relationships.

I want to build a form that allows the user to search for a postal service from a group of carriers.

User must be able to input into a form:

Weight in g, Kg or lbs
Insurance level required
Whether signature is required (Yes/No from drop down list)
Collection/drop-off options (tick boxes)

Each service has a different insurance level, some need signature; some services collect, and all have different rates.

I just want to know how to structure the database.

The main part of my question is what would be my main table be and what fields would be contained in it, and what foreign keys would be introduced to pull in info.

Would you have a different table for each service?

View 9 Replies View Related

Structure Of A Table

Apr 27, 2005

I was having a discussion with a friend of mine about this... and I couldn't come up with the best explination. Hopefuly someone here can point me in the right direction.

He has a table

Recipies(Id, name, item1, quantity1, item2, quantity2, item3, quantity3, item4, quantity4)

I don't believe that this is the proper way to create a table. What happens if you happen to come across a Recipie that needs 6 items?? or more??
After researching it, I believe it violates 2NF. Is this correct?

Instead I think a better structure would be

Recipies(Id, name)

RecipiesIngredients(Recipies.ID, Ingredients.ID, quantity)

Ingredients (Id, Name)

The problem my friends sees with this method is the fact that the Xref table will get giant.

In the example... Speed is of utmost importance, as the tables will most likely contain thousands of records and be queried against frequently.

Thanks for any input.

-Mike

View 8 Replies View Related

Many-to-many Structure Correct?

Jun 11, 2005

I’m struggling to fix a database for my state agency. Here’s what the social workers need:

The agency holds several Foster Parent training sessions a year. Each session consists of 9 classes. We need to track ‘student’ attendance at each class. We also need to track class dates for each student.

The fly-in-the-ointment: ‘Student’ foster parents must attend the 9 classes, but they can fulfill this requirement over several sessions. They can take classes 1, 2 and 5 in Session 1, classes 3, 4, 7 in Session 2, and so on.

Here’s what I’ve created:

tblSessions
SessionID
SessionLocationkey ( to tblLocations; irrelevant to this post)
SessionStartDate
SessionName

tblClasses
ClassID
SessionIDkey
ClassTopic
ClassDate

tblAttendance
ClassID
StudentID

tblStudents
StudentID
StudentFirstname
etc.

The Attendance table is the junction table for the many-to-many relationship between Students and Classes.

Is this the correct structure? Thanks in advance for any advice. And thanks to Pat Hartman, The Doc Man, and SJ McAbney for getting me this far with the advice I found in researching this topic.

Sean

View 12 Replies View Related

Table Structure.........

Aug 27, 2005

hello this is my 1st posting....... :o
please help me .........


I have 3 tables.....

Table : Customers

CustomerID
CustomerType (i.e. 1st Allottee, 2nd Allottee etc.)
Name
Address
C/o
...

Table: Apartments

File# (every apartment has unique file#)
Category
App#
Level
Area
Price
Discounted (yes/no)
DiscountRate %
...

Table: Receipts

Rec#
RecType (Down Payment, 1st Installment, 2nd Installment...)
Ref
Date
Chq#
Amount
...

one customer can have more than 1 apartments, and one apartment can be transfered to another customer (file# same but customerID changed)
one customer is paying different types of payments against his apartment.

please help me to manage tables and relationships.

View 3 Replies View Related

Merge 2 DBs - Dif. Structure ..Need Help

Dec 10, 2005

I need to merge two Access DBs but I need to know if it is even possible before I start learning how to do it. It is not easy for me to express the problem but here goes:

DB A:
-Flat Table with numbered indexes
-will use a unique field as my index for the merge
(not the primary key)

DB B:
-The destination
-One to Many relation (table 1 to table 2)
-primary key not numbered field (I think)
-will match primary key to the unique field in DB A
-a few fields from DB A will be appended to table 2

....................DB B
Table1----------------Table2
******---------------************
*-----*-one to many-*-------------*
******---------------*-------------*
-----------------------*-------------*----append----------DB A
-----------------------************...<<<<<<<......***********
--------------------------------------------------------*-----------*
--------------------------------------------------------***********

View 1 Replies View Related

Table Structure Help

Jan 29, 2006

I need some help trying to setup tables on a new database. I want to setup a house analysis database where I can evaluate each room for it’s condition broken down by feature. I can’t seem to figure out a good way to tie all the rooms and evaluations back to that house’s address (primary key). I want the fields to work as shown below with the room evaluations tracked to each room and house address. If possible I would like to be able to enter the as many room names as needed for each address.

House Address

Bedroom 1______________Bedroom 2_______________Bathroom 1

Ceiling condition –Good____Ceiling condition-Fair____Ceiling condition- Good
Floor condition – Fair______Floor condition – Fair____Floor condition - Fair
Wall condition – Good_____ Wall condition – Bad____Wall condition - Good

Can someone please explain to me how I should structure the tables to work. As a novice Access programmer I am out of ideas. Please help me!!

View 6 Replies View Related

Table Structure

Jan 30, 2006

What's the best way to setup this db?

I have the following information:

Company
Company ID
Program A
Program B
Program C
Program D
2000
2001
2002
2003
2004
2005
The years indicate the year the Program participated in the company. For example, Program A participated in Company Z from 2000 to 2005, Program D participanted in Company Z from 2001 to 2002.

Should I have a table with the Companies and Program A and the years from 2000 to 2005
and a table for the Companies and Program B and the years, etc? I was going to add a yes/no field for each program, too. There must be a simplier way.

I want to be able to query participation of workers in any of the programs.

What is the best way to set this up?

Thanks.

View 2 Replies View Related

Table Structure

Apr 14, 2006

I've got some tables, and I want to make sure I relate them in the best possible way.

Table1 has a one to many relationship with Table2
Table1 has a one to many relationship with Table3
Table2 has a many to many relationship with Table3

Would it be best to set them up this way or is there another way that would be better?

Fields for Table1
Table1_ID
.
.

Fields for Table2
Table2_ID
Table1_ID
.
.

Fields for Table3
Table3_ID
Table1_ID
.
.

View 3 Replies View Related

Need Structure Ideas

Dec 28, 2006

It's been a LONG time since I've designed a database, but it's slowly coming back to me. However, I'm still having a very difficult time deciding the most effective way to setup my tables and queries. Here's what's going on.

The database will be used for FFA livestock shows to enter the exhibitors for market classes and showmanship classes. The database also needs to be able to break a pay scale down showing how much each exhibitor is awarded for their showmanship class and their market class. The database that the club had been using had 2 tables (1 for the exhibitor and 1 for the animals being shown). Then they had 10 different queries that sorted the animals into weight groups (ex. Class 1 is weight between 90lbs and 100lbs); and then they had 10 different queries to breakdown the showmanship classes (ex. Showmanship Class is is age between 5 and 7). This is a LOT of queries! Now, the manager wants to be able to have more than 10 classes, which their current database cannot do. He also likes to be able to enter the parameters to manually break the classes. As of now, he is manually going into each query and editing the criteria for each class, but he wants to be able to do that from a form.

So my question is.... is it best to leave this in the "multi-query" form, or is there some way I could arrange all of this from tables or from a couple queries... and also, what would be the best way to offer the option to add a new class?

Any and ALL advice is greatly appreciated!

~ Audrey

View 10 Replies View Related

Is My Table Structure Ok?

May 14, 2007

Hi,
Thanks for taking time out reading my thread!
I want to start entering data, but i'm not to sure weather my relationship structure is good enough to start inputing.

Heres a pic of my relationships
http://img201.imageshack.us/my.php?image=almostdoneae0.jpg


Thanks.

View 1 Replies View Related







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