Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / New Users / May 2008

Tip: Looking for answers? Try searching our database.

access 2007 table reset autonumber

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
sailinxtc - 12 May 2008 04:20 GMT
access 2007 table reset autonumber:
I found a document on this with the microsoft article ID (812718) but it is
not detailed enough because I am doing something and/or missing something.

Anybody have a better solution for this in 2007 access ?
Tom Wickerath - 12 May 2008 07:29 GMT
It's always nice to provide a direct link to an article, when you are
referencing it:

    http://support.microsoft.com/?id=812718

Which method did you try, method 1 or method 2?  Are you working with a
single table, or with a table that includes referenced tables? Can you
identify a particular step number in whichever method that you tried that you
are not understanding?

Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

> access 2007 table reset autonumber:
> I found a document on this with the microsoft article ID (812718) but it is
> not detailed enough because I am doing something and/or missing something.
>
> Anybody have a better solution for this in 2007 access ?
sailinxtc - 13 May 2008 00:17 GMT
Method 2 where is states "In access Access 2007, follow these steps" almost
to the bottom.

I assume after you delete the autonumber field name, you close the table and
don't save the changes or do you ? Only reason I ask cause later in the doc
it references the same table but states not to inlcude the autonumber field.

Another step talks about copy and pasting with structural, all the methods I
have been able to reference with structural paste and copy don't coinside
with 2007 from what I can see unless its as simple as clicking on the copy
and paste.

The only other table involved is the switchboard.

I probably could have created this table a couple times over again but want
to see what I am missing,  really doesn't seem it should be this dificult.

Any input is greatly appreciated....

Also the reply links I got to my hotmail account open up but there is no
info or refernce in them either.

I had to log back in and search until I found my original posting..... not
sure if that is on my end either,  have not had any other issues on other
forums ?

Thanks,

> It's always nice to provide a direct link to an article, when you are
> referencing it:
[quoted text clipped - 17 lines]
> >
> > Anybody have a better solution for this in 2007 access ?
sailinxtc - 13 May 2008 00:19 GMT
Also,  not sure if it matters,  but the database was created in 2003 access,  
I recently purchased 2007 access and am working with it in that.  Am I
correct to utilize the 2007 method under step 2 ?

> It's always nice to provide a direct link to an article, when you are
> referencing it:
[quoted text clipped - 17 lines]
> >
> > Anybody have a better solution for this in 2007 access ?
sailinxtc - 13 May 2008 01:27 GMT
Hi,

I was able to resolve the issues another method.

Thanks....

> It's always nice to provide a direct link to an article, when you are
> referencing it:
[quoted text clipped - 17 lines]
> >
> > Anybody have a better solution for this in 2007 access ?
Tom Wickerath - 13 May 2008 07:08 GMT
I take it you don't need anymore help on this issue, correct?

Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

> Hi,
>
> I was able to resolve the issues another method.
>
> Thanks....
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.