Sequence Engine in Access

  • Thread starter Thread starter Manuel
  • Start date Start date
M

Manuel

Hi!!!!
I have unsuccessfully been trying to create a sequence
engine in Access in order to create unique IDs in an
Intranet environment. I need that because I'm using it not
only for a primary key, but also for foreign key
references in other tables. This works marvelously with
Oracle, with MSSQL I had to create a stored procedure that
will emulate this scenario (by filling a table with an
Identity(1,1)), but with Access I have this run-time error
3085 when I try to emulate it (by using an
autonumber/COUNTER).

Any help is really appreciated!
 
More details about the problem:

1. By using a table with an autonumber field, the ID is
generated with not a problem at all from within a querydef
in Access.

2. However, if I call this same querydef, I got the error
8035.

There is an article in the Microsoft's knowledge DB,
Q209864, that describes my situation, but does not answer
it.

Sight!!!
 
Back
Top