A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Start with clean tables



 
 
Thread Tools Display Modes
  #1  
Old January 16th, 2005, 04:18 AM
Sandra Grawunder
external usenet poster
 
Posts: n/a
Default Start with clean tables

I have been setting up a simple database and now I know
that everything is working OK, I would like to clean up
the tables so that the PK numbers start out fresh. My
tables are all empty and I have removed all the
relationships. I have deleted the primary key fields in
the table, saved the table design, then went back in and
recreated my PK's. When I tested this, the PK's are
starting where they left off, rather than at 1. How do I
start out with new PK's in the tables?

Thanks,

Sandra G
  #2  
Old January 16th, 2005, 04:29 AM
Allen Browne
external usenet poster
 
Posts: n/a
Default

Compact the database:
Tools | Database Utilities | Compact

If that does not work, you need to apply a JET 4 service pack. Available
from Downloads at support.microsoft.com

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Sandra Grawunder" wrote in message
...
I have been setting up a simple database and now I know
that everything is working OK, I would like to clean up
the tables so that the PK numbers start out fresh. My
tables are all empty and I have removed all the
relationships. I have deleted the primary key fields in
the table, saved the table design, then went back in and
recreated my PK's. When I tested this, the PK's are
starting where they left off, rather than at 1. How do I
start out with new PK's in the tables?

Thanks,

Sandra G



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
where to start.... Little pete Database Design 1 October 12th, 2004 09:39 PM
Office XP Ed Lester Setup, Installing & Configuration 1 May 27th, 2004 09:30 AM
Need help with Tables Design and Relationships Tom Database Design 24 May 19th, 2004 06:51 PM
Separate database for tables? Holly Clifton Database Design 3 May 18th, 2004 06:20 PM
Multiple Many-To-Many Tables Tom Database Design 7 May 15th, 2004 03:47 AM


All times are GMT +1. The time now is 01:31 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.