Tables :: Old Database Using New ID?
Jul 1, 2013
I have several visual dBase tables converted over to Access 2013. The old tables use identification, SEQ. I have retained the old SEQ , but now have the Access ID. It seems I somewhere saw that if you delete an ID, you will be changing all the subsequent IDs that follow. In other words, if you have ten records that have IDs of 1-10 , and delete record five, ID 005, record ID 006 now becomes 005.
Is that true. Is it a good policy to count on the ID number when you at times delete records?
True, I could test this theory myself, but I'm concerned that there might be conditions where it could be troublesome.
View Replies
ADVERTISEMENT
Sep 7, 2011
I'm trying to set up a simple query that links four tables. However, the tables are extremely large, all in excess of 1.5GB each so I had to split the tables up into four separate DBs. I've tried the following with no success:
1) Link the 4 tables in the DB which contains my primary key. This quickly inflates increases the file size above 2GB and won't let me go any further.
2) Build a remote query to connect the four tables. This looked promising until I tried to run the query and it became evident that it only knows to point to the last database source that you specified.
I'm running everything locally on my C drive. The data source are simple text files (1.6 million rows) from the FDA website.
View 3 Replies
View Related
Dec 3, 2012
I have 2 identical database in terms of structure but it differs in data.
Basically I would like to import data from subDatabase to mainDatabase and ensuring that there are no duplicate records.
I have used the "link to datasource method" through importing the tables to have the "updating" function.
However, this method also means that the records in mainDatabase are also imported over to subDatabase which I do not want.
Is there a method to ensure that the records are shared/update one way only? (i.e. import from subDatabase to mainDatabase and not main to sub?)
View 1 Replies
View Related
May 28, 2013
I am splitting a database and have created the Back end already. When I create the front end and link to the tables on the back end... The front end does not link to all the tables in the back end. The list that comes up when creating the linkings does not show all the tables in the back end. What would cause this?
View 1 Replies
View Related
Mar 4, 2013
I am about to set up a database but wanted to check the relationship of the main tables before I add to it. I have attached the relationship design
For a PROJECT, there can be many TESTS, for a TEST, there can be many PRODUCTS
Is my design reasonably sensible?
View 6 Replies
View Related
Jul 4, 2013
I have broken up by master database, table, into several tables. They all share the same ID values since they came from the master table. So each table that I split off has a unique, matching, identifier, ID, in both the master table and the new table. Plus a previous matching identifier listed immediately below.
Example: Permit the master or main table and Builder a supporting table. There are five tables that I split off and all have an identifier similar to the two listed below.
Permit->ID
Permit->BLD
Builder->ID
Builder->BLD
All my tables have the same ID. But each table also has a identification numbers such as builder BLD, Subdivision SB and inspector INS>
Permit has the BLD, SB and INS
Builder has only one occurrence for each builder in the Permit table. As in the past it was identified by BLD number and now also ID. the use of BLD is from when I used visual dBase. The big difference here is that I have two ways to identify one is ID any other is by BLD, etc. My first thought is to identified by the BLD. I don't know why, but I guess I fear using a single "ID" to identify my various split off tables unique value or BLD.
View 1 Replies
View Related
Aug 28, 2013
I am testing the security of my DB X on Acccess 2007. I could create a new database Y and linked to the database X. Unfortunately i could change the records on the tables. I don't want other DB that make connections to my DB to change my tables!
View 1 Replies
View Related
Feb 19, 2013
I have created multiple tables in my database and now for some reason it keeps telling me it can not find a few of my existing fields.
View 5 Replies
View Related
Sep 19, 2013
looking for a way to export the list of table names, table types & if they are linked (e.g. tbl Sales Linked .dbf or tbl Staff linked to excel) from a database - this has to be done for about 300 databases.
in an individual db, I have a make table query off of the table MSysObjects to get the data. The Database field tells me where the source of the linked table resides & the ForeignName field gives me an idea of the format of the data source (e.g. dbf or excel). I could manually import that query into each db, run it to get the table names, then copy & paste..
View 3 Replies
View Related
Jul 29, 2013
I have one database that I am working on and within it there are several Tables. 2 of the tables have similar information on various organisations and I need to query these 2 tables to get a simple mailing list of ALL organisation addresses and the main incumbent there.
Within Access (2007) and in the SQL View window, I have made a simple query to give me a list of all the organisations and incumbents but cannot get it to work correctly. Is there an easy way to get this information out of the 2 tables? I realise that the SQL in SQL View has to be formatted differently. I have also tried the Microsoft Query Wizard but that doesn't work either as it gives in a side by side list which is useless to me.
The Field names that are required are as follows:
<Incumbent>, <Organisation>, <Address1>, <Address2>, <Address3>, <County>, <Postcode>,
View 8 Replies
View Related
Aug 28, 2013
I am playing around with a sample Access 2007 database that has a number of tables, forms, reports queries and macros.I would like to rename then so that the names make it easier for me to recognise what they are when listed in a drop down list.
For example, I have a form named "Workorder Parts" and a table named "Workorder Parts" and I would like to rename the table to "tWorkorder Parts" and the forms to "fWorkorder Parts".I am assuming that these are referenced throughout the database and would like to know if there is a simple way to do a rename on mass?
View 5 Replies
View Related
Nov 29, 2007
Can a Append Query move all my data stored in multiple tables to another database with a identical table structure?
Because as I try to work the query, I keep getting prompted to "Select a table" I want to append to, and I don't want to append to just one table...
View 4 Replies
View Related
May 6, 2006
Hello.
I am trying to re-create a db system which used a backend database for some of the information. I have opened the backend db in access and there does not seem to be any information in this database when I know for a fact there is.
How do I go about viewing the tables etc in the database.
Bach.
View 3 Replies
View Related
Jul 19, 2006
Thanks for considering my question. I have developed a DB with about 60 tables, all related by one-to-many relationships. During development, I placed values in the tables, generated keys, etc. so things have gotten quite cluttered. Is there a way (vb program, access method, etc.) that I can use to remove all the entries from the table, and essentially start with a set of clean tables and no keys? I'd like to be able to run this from a control on a form.
View 2 Replies
View Related
Mar 5, 2008
Hi,
I wonder if there is a possibility to select a table from a database by using a sort of explorer window.
My problem is this:
I want to import a *.xls file in a table.
I want to be able to select a certain *.xls file from a list (so far no probs) en add it contents to a table selected in a browser window.
A table ofcourse who the exact field structure.
Anyone?
View 4 Replies
View Related
Oct 22, 2005
hi,
can anyone please tell wht's the query to check if database exists, if exists list all tables in database (in sqlserver) else raise error
Thanks in advance,
Deepthi
View 2 Replies
View Related
Oct 11, 2006
Do i have to list them manually eg "SELECT * FROM 1, 2, 3, 4" or is there another way to search them all.
View 5 Replies
View Related
Feb 3, 2005
Hello,
Ok this may seem simple, but I can't think of an "easy" way to do it.
How can I query all tables in a database (that are not related in any way, and shouldn't be... for a reason) to find a specific string.
The example is, the db contains tables of pc's at multiple schools, sort of a primitive inventory. Each school has its own table at this point, because we may eventually give each school its own db in the future (and once we clean this one up a little!).
If I am looking for a pc's service tag, but don't know what school's table it's in, I have to open and individually do a "find" in every table. Is there a way to simply query all tables in a db without the tables being related? Is this a union query? If so, is there a limit to how many tables can be part of that?
Thank you!
LMS
View 2 Replies
View Related
Nov 21, 2012
I am working in Microsoft Access 2010 and wanted to move tables from a number of databases to a "Master List of Tables" without having to manually recreate them. The purpose is to have this "Master List" available when we are creating new databases covering similar topics.
I was hoping to use the import tool but it appears to address only data not tables.
View 3 Replies
View Related
Oct 11, 2005
Im trying to add 2 new tables to a split and linked database... but no matter which side i add the table to (BE or FE), it wont show up in the linked table manager.. so my question is 1.) is there some trick to getting it to show up in the link manager? or 2.) is there some way to re-merge the database, add the new tables.. and then split it again?
View 3 Replies
View Related
Mar 9, 2005
Is it possible to create a database and link this to a form and another database? What i want to do is link a network database with a local database on a client machine?
View 3 Replies
View Related
Aug 1, 2006
Looking for advice on how to make changes required in my database designed to track health wellness. Here is a breakdown of what I have now:
Membership Query built off membership table that isolates one employer group and creates age off birthdates that will change as the months go by.
Category table that gives up to 9 different items included in the wellness program along with the criteria. Shown as A through I with corresponding age and time restrictions.
Compliance Log – results come from compliance input form that updates each member’s data relative to the wellness items that are listed. Based on restrictions in place for their age group, we have been indicating them as either compliant or non-compliant.
Scorecard – built of some of membership query details, including the group # and the age of the person. Contains a subform that is built off the compliance table that lists the Wellness Category, Time Frame, Criteria, Compliant (yes, no, na, unknown) and complaint date of activity.
Everything was perfect until one of the larger employers now wants the scorecard to be more specific. In other words, under criteria, wants specifics spelled out according to gender and age. Previously we were showing “to be completed within time frame”. Even though everyone’s scorecard showed the same category/criteria information, we internally applied the age/gender rules based on our data input. Now they want the criteria to reflect the rules applicable for each member only on his/her scorecard. Example: Health Maintenance exam, age 19-39, every 12 months (if member within that age group) or 40+, every 12 months etc.
I have struggled most of last night trying to figure out different ways to make this happen in an automated way, and I am at a loss as to how to reconstruct some of my work to allow for this. I am looking for some ideas here. For starters, I did expand the category table to include the different gender-age groups but cannot figure out how to get this related to my members, their changing age, and the scorecard.
I am attaching a brief copy of my DB with hopes that someone can help me. We need to send scorecards out on Friday and short doing lots of manual things; I am not sure where to go with this.
:confused:
View 1 Replies
View Related
Sep 9, 2007
Hi,
I would like to create a small HR database that holds:
* Employee details (Name, Date of birth, Entry Date, Exit Date, Function,Department, Shift)
* Departments
* Departments and capabilities needed
* Employee, departments and capability achieved (1=yes, 0=no)
The idea would be to have a link between the employee the departments capabilities I can tick fields of the capabilities they have or have achieved.
When I have this I could run a report that shows a score per employee
For example:
Name: Department: Orderpicking: Packing: Cutting:
John Warehouse 1 1 0
As the tasks / capabilities required are different per department you would see something different if you would have user Jane that works in accounting
Is there anyone that can give me some hints so that I can get any further??
For the moment I have 3 tables:
1. Employee information - John, Jane
2. Departments - Warehouse, Accounting
3. Department tasks - Department, Cap1, Cap2, Cap3, Cap4
View 7 Replies
View Related
Aug 6, 2007
Is there a way to have a query pull all of the table names within a database and display the number of records in each table? The names, number of tables in the database, an number of records within each table will always be changing, which is why I wanted to use a Query to pull the information.
I have already tapped into the MSysObjects table to retrive the Table names (via a Query), I am however stumped on how I am going to display each tables record count. Any help would be appreciated. Thanks in advance.
View 1 Replies
View Related
Oct 30, 2004
How do I join 3 tables in Access using INNER JOIN query. I have a product tabel which is related to a subcategory table, which in turn is related to category table. I want to display the product along with the main category (not the sub category) it belongs to. My "SELECT * FROM products p INNER JOIN subcategory s ON p.subcatID = s.subcatID INNER JOIN category c ON s.catID = c.catID" query is returning error in ASP.
Could someone please help?
View 2 Replies
View Related
Nov 7, 2004
Hi just started working for a Company and I found they have tons of
databases but no structure or standard, so I would like to build a tool that will go thrue a list of databases and get all the table names, the items and type. Is there functions in vba that can get me a list of the tables in the database and the get all the items in the database ?
Thanks on any input
View 2 Replies
View Related
