Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS ACCESS






SuperbHosting.net & Arvixe.com have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for BigResource.com.







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


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 Complete Forum Thread with Replies
Sponsored Links:

Related Messages:
Export Data From An Access Database To MYSQL
Hi There,

Whereabouts would I change the date format from the access database from yyyymmdd ?

I am trying to convert this table from access into mysql, and when I ouput to a csv file the date is in access.

Many Thanks

Chris

View Replies !   View Related
Export Structure?
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 Replies !   View Related
Export Structure
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 !   View Related
Export Table From Backend Data File To New Database
Hi

I want to simply export all the tables from my backend data file to the new database file I have created. When I try to run following code from my frontend, it sends the tables as linked table to the new database. I want this to actually export all the tables from backend file instead of frontend. Here's my code

Dim RealDB As DAO.Database
Dim MobileDB As DAO.Database
Dim strRealDataPath As String
Dim strMobileDBPath As String
Dim TDF As DAO.TableDef
Dim i, X

strRealDataPath = DLookup("Database", "MSysObjects", "Name Like 'TblPatients'")

Set RealDB = OpenDatabase(strRealDataPath)



'Start Exporting tables

For Each TDF In RealDB.TableDefs

If TDF.Name Like "MSys*" Then
Else


DoCmd.TransferDatabase transfertype:=acExport, databasetype:="Microsoft Access", _
databasename:=strMobileDBPath, objecttype:=acTable, Source:=RealDB.TableDefs(TDF.Name), _
destination:=TDF.Name

X = SysCmd(4, "Exporting Table " & TDF.Name)
Me.Repaint
End If
Next

X = SysCmd(acSysCmdClearStatus)


Any suggestions?
Aqif

View Replies !   View Related
Export Table From Backend Data File To New Database
Hi

I am trying to export all the tables from my backend data file to a new database I have created. At the present moment it is only exporting the tables from frontend as linked table. I want it to actually export entire tables from backend data file.

here's my code

Dim RealDB As DAO.Database
Dim MobileDB As DAO.Database
Dim strRealDataPath As String
Dim strMobileDBPath As String
Dim TDF As DAO.TableDef
Dim i, X
Dim FS As FileSystemObject
'Set FS = CreateObject("Scripting.FileSystemObject")

strRealDataPath = DLookup("Database", "MSysObjects", "Name Like 'TblPatients'")

Set RealDB = OpenDatabase(strRealDataPath)


strMobileDBPath = GetFileName2(strRealDataPath, "FileDirectory") & "BCR_Mobile.mdb"


For Each TDF In RealDB.TableDefs

If TDF.Name Like "MSys*" Then
Else


DoCmd.TransferDatabase transfertype:=acExport, databasetype:="Microsoft Access", _
databasename:=strMobileDBPath, objecttype:=acTable, Source:=RealDB.TableDefs(TDF.Name), _
destination:=TDF.Name

X = SysCmd(4, "Exporting Table " & TDF.Name)
Me.Repaint
End If
Next

X = SysCmd(acSysCmdClearStatus)

Any suggestions?
Aqif

View Replies !   View Related
Export To Access Database
Hi, just a quick question. Is there any way of exporting say a query, or a range of quieries to another seperate access database file? ie. create a new database in code?

View Replies !   View Related
Export OLE Object From Access Database
OK, I have a very large Access database with embedded bitmap photos.

I have realized the error of my ways and would like to list them as linked.

The problem:
How can I get the embedded files out without individually going through, viewing and saving and naming?

Is there a way to save a file do a directory and name it, say the primarykey.bmp or something?

Please help!

View Replies !   View Related
Access Truncating Data In Export
Hello...
I am trying to export an Access table to a csv file.
I have several fields in the table that are type double and go to 3 decimal places. When I export the data, it truncates it to 2 decimal places.
I changed the table design from "Auto" decimal places to 3. and that didn't help.
When I am in the Table Export wizard, it shows all 3 decimal places, but when I look at the text file, it's only 2.
Anybody ever have this problem?
Thanks in advance!
Greg

View Replies !   View Related
Automate An Export Of Data To Access Tables.
Hi,

Would it be possible for me to build an interface for a customer to use for importing data. So that they customer could choose from a drop down list, or input into a text box where they want to export from, and where they would like the export to be imported?

View Replies !   View Related
Export Access Data Into Excel Column
Hello,

I have a table in Access and would like to export it using code into specific fielfs of a template in Excel.

My table has 3 fields:

SSN
FIRSTNAME
LNAME

I would like to export the recorsed to a template named MyTemplate. This template has a workbook named MyWorkbook.

The only problem is that I need to copy the active recorset (meaning the one which I will select) in a column and not into a row.

Example: I will select a record using a combo and then data will be copied from my Table into the cells B1 (ssn), B2 (FIRSTNAME), B3 (LASTNAME)

Any idea or help? Thanks

View Replies !   View Related
Can I Export A Data Access Page To Static HTML?
Good morning! I'm using Access to redesign our company's electronic phonebook. Our intranet uses SharePoint technology and our IT people have cranked our security settings up pretty high, so I can't use data access pages or ASP. Therefore, I'm going to use static HTML, producing a single page which the CEO's secretary will upload once a month, allowing our 800+ employees to view the entire phonebook at once. CTRL-F is their friend.

I've managed to design a data access page that looks very much like we want it to, but I don't know how to export it to static HTML. Can such a thing be done, or am I just being wacky? If so, is there a way to automate it so the secretary can just push a button to generate the page?

Thanks,
Andreas

View Replies !   View Related
Export Table Data Into An Excel SpreadSheet (VBA, ACCESS)
I have an export function below that will export my table "Test" to an Excel Spreadsheet.

However I want it so i can choose where that data in the "Test" table will go in the Excel Spreadsheet i.e. I want to export all the data in to Cell "B2" of the SpreadSheet - at the moment it will export all the data into "A1"

Any help or ideas?


Private Sub Command3_Click()

'Export function
'EXPORTS TABLE IN ACCESS DATABASE TO EXCEL
'REFERENCE TO DAO IS REQUIRED

Dim strExcelFile As String
Dim strWorksheet As String
Dim strDB As String
Dim strTable As String
Dim objDB As Database

'Change Based on your needs, or use
'as parameters to the sub
strExcelFile = "E:CSCLDMSLDMSDatabaseAppLDMS_Spec.xls"
strWorksheet = "WorkSheet1"
strDB = "E:CSCLDMSLDMSDatabaseAppLDMS_IFF_APP.mdb"
strTable = "Test"

Set objDB = OpenDatabase(strDB)

'If excel file already exists, you can delete it here
If Dir(strExcelFile) <> "" Then Kill strExcelFile

objDB.Execute _
"SELECT * INTO [Excel 8.0;DATABASE=" & strExcelFile & _
"].[" & strWorksheet & "] FROM " & "[" & strTable & "]"
objDB.Close
Set objDB = Nothing




End Sub

View Replies !   View Related
Database Structure
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 Replies !   View Related
Database Help - Structure
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 Replies !   View Related
Help With Database Structure
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 Replies !   View Related
Help With How To Structure A Database
I am trying to figure out how to store data into a database to be use later in a web app. So I have a shirt and it can come in four different colors. What would be the best way to enter this into the database. I'll have shirts, jackets and accessories which I have give each their own table. The shirt one is giving me trouble though, I just don't know how to organize it.

Thanks for the help

View Replies !   View Related
Locking Down The Structure Of A Database
Dear All,

is there any way to look-down the structure of tables within a database so users cannot change tables?

Is it possible to make this password protected so only certain users have rights to change the layout of the tables?

Would this still allow users to create queries and enter data?

Thanks, Steve

View Replies !   View Related
Database Structure Enquiry
I'm doing some changes to a database in work, but the person who created it doesnt work there anymore and so nobody knows anything about it. The database has been split into a front and back end, which is fine, but there appears to be 3 seperate databases linked to the main one, each with a .mde file for security. Depending on which department you're in, you access your database. Any information being added is updated in the main front end database. Does anybody know how that will be linked? I'm just probably going to have problems when encorporating my changes.

View Replies !   View Related
Database Structure (many To Many Issue?)
Hello,
I am looking for someone's professional opinion to help me clear up some unresolved technical issues in my mind... =P
Ok, I have a contact management database that would seem really straightforward to me except for the fact that I am dealing with 2 primary entities. In this I mean I have an Individual table and Organization table. These two tables have primarily the same field data, such as both having address data, phone (contact info) data. There are some unique fields to one entity that aren't contained in the other entity though, and visa versa. One important issue is that 0, 1, or more individuals can be related to an Organization. Therefore I now have linking tables for IndividualOrganization, as well as linking tables for Phone and Address data.
My primary complication is that since both Individuals and Organizations have address and phone data, the respective linking tables for them contain: an addressID/phoneID key, for the appropriate linking table, with an OrganizationID key and an IndividualID key in each table. So, the way I am thinking is that if the record pertains to an Individual, the appropriate ID will be in IndividualID and the OrganizationID will just be 0, or empty. This brings up issues with primary keys being blank.
I am wondering if there is a better way to do this that I am overlooking or if I am in fact on the right track? I have contemplated combining the Organization and Individual tables into one but that really doesn't seem like the best solution. If anybody has any ideas then I would GREATLY appreciate it. I had a working database the other day but now I am separating the phone and address info out of the primary tables and have really got a mess on my hands. =P If anybody would like to look at my database structure I'd be more than happy to post the back_end and the front_end for you to give me your honest opinion about any trouble areas.
Thanks BIG TIME in advance to any nice souls willing to help out a struggling programmer who doesn't have any close support on this one as I am working alone, :rolleyes:
Dana S.

View Replies !   View Related
Database Design - Structure.
I have 7 tables:

Booking - BookingID
Course - CourseID
Company - CompanyID
Materials
Materials_on_course (had to have this in order to avoid many-to-many.)
Employee - EmployeeID
Employee_runs_course (had to have this in order to avoid many-to-many.)

I'm stuck with the Course and employee thing. Each employee has an expertise or two, and therefore each course has an expertise needed to run it (a specialist if you like).. so the PK in 'course table' is Course ID, you cannot have two PKs in one, so would it be right to say that the 'expertiseID' would have to go in 'Employee_runs_course' ?.. what would i do then? place 'expertise ID' as an FK in both employee and course tables?

Extra info:

Clients (tblCompany) can book one or many courses
A course can have one or many bookings made for it
A booking has one or many employees/courses
An employee can work on many bookings (obv if available)
Each employee has one or two expertise (usually only one)
and therefore a course has on expertise attached to it.

__

If you have a better way of designing it, shoot!
Attachment: ERD (kinda) of first draft.

View Replies !   View Related
Fundamental Database Structure
Hi People,

I am building a database of in-car audio systems. Stored in this are simple things like vehicle information, audio brand and other general information. The main information I need to store includes details about speakers (position, quantity, material, range, size etc.) and amplifiers (power output, no. of channels etc.). Sounds simple I hope.

I have been thinking about this extensively and have come up with two solutions, each with its own pros and cons. My primary concern here is how the speaker and amplifier information is stored:

1) Tables specific to car regions (e.g. Rear Speakers, Front Speaker, Surround Speakers) have the fields 'Range', 'Material', Size, etc. Range and material can read their values from other look-up tables no probs. These would be linked to the main table via it's primary key in a 1-M relationship.
-Pros:
Ease of construction and general handling of data
Flexibilty/expandability (in terms of speaker quantity)
-Cons:
When it comes to data entry the form would need to be continuous and continuous forms I have found to be a pain in terms of referring to individual records!
I want some of these controls to conrol a diagram for my report (and input form) - such that they show/hide speaker pictures on a car diagram. Also, I have not yet figured out how to validate a continuous form in this situation or delete records from it either (should the user makes an error).

2) Again, tables specific to car regions but this time with a field for each speaker range (mid-range, tweeter, woofer, etc.) and it's associated data, tied to the main table via the main table ID in 1:M relationships.
-Pros:
Easy to manipulate form/report properties because every speaker has its own field
Easier to remove erroneous data (I imagine)
-Cons:
More complex construction (and less efficient) - e.g. material occurs more than once for each record so to look up material form a central pool requires an intermediate table
Many many more fields!
Non-expandable in terms of speaker quantity

Similar principals can be applied to amplifiers so I haven't mentioned those.

So what do you think? Or is there another way...

Hope that all makes sense!

Thanks for your time,

Bobadopolis

View Replies !   View Related
Need Advice On Database Structure
Hi ,
I am developing an access application that will be used by our Marketing Dept to create BRIEFS for our AD agencies.


The Brief has the following structure

1. Option1
1.1 A1
1.2 A2
1.3 A3
1.3.1 AA1
1.3.2 AA2
1.4 A4


2. Option2
2.1 B1
2.2 B2
2.2.1 BB1
2.2.2 BB2
2.3 B3
2.3.1 BB3


3. Option3

........................
........................
........................


The users will be basically selecting from a list of Categories,Sub Categories and Sub-Sub Categories.


I am a bit confused as to what kind of Database Structure should I use for this kind of requirement.

Right now I have a table tblBRIEF that conatins the basic information about the BRIEF like
Project Name
Company Name
Date
Responsible etc etc

My question is , where and how should I store the selections made by the user for each of the Categories , subcategories and su-sub categories.

Should I have a table for each of the Categories and Subcategories and have a relation with the BRIEF table ???

You advice will be apprecaited?

View Replies !   View Related

Copyright 2005-08 www.BigResource.com, All rights reserved