Re: autonummering in table gives problems
- From: "Larry Linson" <bouncer@xxxxxxxxxxxxx>
- Date: Mon, 26 Sep 2005 03:33:53 GMT
You should be able to copy and paste the records up to that point, then
manually recreate the "bad" records in the new table, then copy and past the
records follwing the bad records. Then it is likely that your original
sequence of AutoNumber identifications may be regenerated (but don't count
on AutoNumbers to be anything except "unique").
Sometimes I just get into a rut and assume that most everybody has some VBA
and DAO experience. Sorry.
Larry Linson
Microsoft Access MVP
"red zebra" <redzebra@xxxxxxxxxxx> wrote in message
news:FgVYe.37$Aj4.1772@xxxxxxxxxxxxxxxxxx
> Thanks for your quick reaction. I made the new database with all the
> elements (tables, query's, forms...)
> All the records from the other tables are copied (copy and paste from
> the original database). There's only one table (the damaged one) where
> from i have to copy the files. This table is the only table were the ID
> is autonummering. you wrote that i need to write code to copy the
> records from this table. Is there another way (copy and paste?) to copy
> those records? Writing code is not one of my capebilities.
> Can you give me an exemple of that code ? When i have an example, i can
> adapt the terms to my database and use it.
> Thanks for helping me a lot !
> Have a nice weekend
>
>
>
> *** Sent via Developersdex http://www.developersdex.com ***
.
- References:
- Re: autonummering in table gives problems
- From: Larry Linson
- Re: autonummering in table gives problems
- From: red zebra
- Re: autonummering in table gives problems
- Prev by Date: Re: Access 2003 Possible Corruption?
- Next by Date: Re: comp.databases.ms-access
- Previous by thread: Re: autonummering in table gives problems
- Next by thread: report page layout help
- Index(es):
Relevant Pages
|
