microsoft access problem

This is a discussion on microsoft access problem within the A Brief History of Cprogramming.com forums, part of the Community Boards category; So this is a very basic question, listen up: I have only one table in my database. The table contains ...

  1. #1
    the Great ElastoManiac's Avatar
    Join Date
    Nov 2005
    Location
    Republika Srpska - Balkan
    Posts
    377

    microsoft access problem

    So this is a very basic question, listen up:
    I have only one table in my database. The table contains several text fields ( about 8 ).
    The table is filled with very very much data. The problem is that i have a multiple
    instances of the same data ( i mean apsolutly same, all the fields are same ) so
    i need to delete copies.
    Help please. Those copies are making me mad
    Last edited by ElastoManiac; 12-02-2005 at 02:06 PM.
    lu lu lu I've got some apples lu lu lu You've got some too lu lu lu Let's make some applesauce Take off our clothes and lu lu lu

  2. #2
    Mayor of Awesometown Govtcheez's Avatar
    Join Date
    Aug 2001
    Location
    MI
    Posts
    8,825
    Here's something similar I did for a table of mine that had a bunch of drawings in it. There's a wizard for this in there, too (which is where this was generated from)

    SELECT Drawings.Dwg_Num, Drawings.Station, Drawings.Title
    FROM Drawings
    WHERE (((Drawings.Dwg_Num) In (SELECT [Dwg_Num] FROM [Drawings] As Tmp GROUP BY [Dwg_Num] HAVING Count(*)>1 )))
    ORDER BY Drawings.Dwg_Num;

  3. #3
    the Great ElastoManiac's Avatar
    Join Date
    Nov 2005
    Location
    Republika Srpska - Balkan
    Posts
    377
    Is this some kind of VB macro, 'cause i don't know VB neither do macros.
    How to use wizard?
    lu lu lu I've got some apples lu lu lu You've got some too lu lu lu Let's make some applesauce Take off our clothes and lu lu lu

  4. #4
    5|-|1+|-|34|) ober's Avatar
    Join Date
    Aug 2001
    Posts
    4,429
    That's SQL. Open a query and go to SQL view by right clicking on the form.

    The "Duplicates" wizard should be in one of your menus.
    EntropySink. You know you have to click it.

  5. #5
    Devil's Advocate SlyMaelstrom's Avatar
    Join Date
    May 2004
    Location
    Out of scope
    Posts
    4,062
    If you don't know SQL, it's pretty tough to get too far in MS Access. Access's help section has some info about it, but it's very, very bad. Search online for a tutorial.
    Sent from my iPadģ

  6. #6
    the Great ElastoManiac's Avatar
    Join Date
    Nov 2005
    Location
    Republika Srpska - Balkan
    Posts
    377
    This is not a complicated database, it's a single table for god's sake, why should i learn SQL?
    lu lu lu I've got some apples lu lu lu You've got some too lu lu lu Let's make some applesauce Take off our clothes and lu lu lu

  7. #7
    Devil's Advocate SlyMaelstrom's Avatar
    Join Date
    May 2004
    Location
    Out of scope
    Posts
    4,062
    Oh I didn't know you were just gonna keel over and give up on life after this database. I just thought you might want some information for the future.

    Nevermind, though. Don't mind me.
    Sent from my iPadģ

  8. #8
    the Great ElastoManiac's Avatar
    Join Date
    Nov 2005
    Location
    Republika Srpska - Balkan
    Posts
    377
    Quote Originally Posted by ober
    That's SQL. Open a query and go to SQL view by right clicking on the form.

    The "Duplicates" wizard should be in one of your menus.
    I have done everything you'v told, except the last thing, i can't find the wizard in any menu.
    Does it matters if my Access is a bit old ( 2000 version )
    lu lu lu I've got some apples lu lu lu You've got some too lu lu lu Let's make some applesauce Take off our clothes and lu lu lu

  9. #9
    the Great ElastoManiac's Avatar
    Join Date
    Nov 2005
    Location
    Republika Srpska - Balkan
    Posts
    377
    Quote Originally Posted by SlyMaelstrom
    Oh I didn't know you were just gonna keel over and give up on life after this database. I just thought you might want some information for the future.

    Nevermind, though. Don't mind me.
    sorry for that
    lu lu lu I've got some apples lu lu lu You've got some too lu lu lu Let's make some applesauce Take off our clothes and lu lu lu

  10. #10
    Cheesy Poofs! PJYelton's Avatar
    Join Date
    Sep 2002
    Location
    Boulder
    Posts
    1,728
    The find duplicates query only finds duplicates, it doesn't delete them. Unfortunately there isn't an easy way to get rid of them that I know of unless you know SQL.

    What I usually do is copy the table, then paste but only paste the structure (it should ask). Then in this new table set the fewest amount as columns that you can as the primary keys but that will not completely delete unique rows. Let me know if this is confusing and I'll clarify. Then simply append the original table to this new table, it'll say something like appending XXX items but could not append YYY items due to key constraints. Click OK and your new table shouldn't have any duplicates.

  11. #11
    the Great ElastoManiac's Avatar
    Join Date
    Nov 2005
    Location
    Republika Srpska - Balkan
    Posts
    377
    Ok, heres what i will do. Since i obviosly don't know how to do this, could someone remove the duplicates for me?
    Just give me your e-mail, and send back the database with no duplicates.
    i'l send the database with duplicates - the database is about 1,2 MB
    // this is not rule breaking since this doesn't have to do anything with programming...
    lu lu lu I've got some apples lu lu lu You've got some too lu lu lu Let's make some applesauce Take off our clothes and lu lu lu

  12. #12
    Yes, my avatar is stolen anonytmouse's Avatar
    Join Date
    Dec 2002
    Posts
    2,544
    You could try this. I'm sure you can figure out how to execute an SQL statement.
    Code:
    SELECT DISTINCT * INTO [NewTableName] FROM [OldTableName]

  13. #13
    the Great ElastoManiac's Avatar
    Join Date
    Nov 2005
    Location
    Republika Srpska - Balkan
    Posts
    377
    I have found the wizard!!!
    No need to help anymore...
    But i really wish to learn SQL, so if anyone has a link to tutorial of somekind...
    lu lu lu I've got some apples lu lu lu You've got some too lu lu lu Let's make some applesauce Take off our clothes and lu lu lu

  14. #14
    5|-|1+|-|34|) ober's Avatar
    Join Date
    Aug 2001
    Posts
    4,429
    search google... you'll find literally thousands of tutorials.
    EntropySink. You know you have to click it.

Popular pages Recent additions subscribe to a feed

Similar Threads

  1. malloc access problem
    By parad0x13 in forum C++ Programming
    Replies: 4
    Last Post: 01-30-2009, 12:00 PM
  2. Microsoft -> ISO conversion problem
    By murdercityriot in forum C++ Programming
    Replies: 18
    Last Post: 08-07-2008, 09:03 AM
  3. Memory problem with Borland C 3.1
    By AZ1699 in forum C Programming
    Replies: 16
    Last Post: 11-16-2007, 10:22 AM
  4. access problem in LAN
    By naruto in forum Networking/Device Communication
    Replies: 2
    Last Post: 07-21-2004, 03:03 AM
  5. Network problem
    By dirkduck in forum A Brief History of Cprogramming.com
    Replies: 11
    Last Post: 07-26-2002, 12:36 AM

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21