I have an Access 2000/XP with an unusual autonumber scheme; I can't figure
out how it generates its very unique value.
I have the database temporarily located at this website: http://www.dbases.net/tmp/Tuscon2k.zip
The field is called ****Company_Id* *** in the table "Companies. " There are
LOTS of other tables linked to it but I deleted all of them because I was
able to decipher that they aren't responsible for helping to delete this
field's value, and it helps reduce the file's size.
I typically use an autonumber field simply for 1,2,3,4 etc--but this one
develops a VERY unusual value even including the { in the field, not just
numbers.
Tips?
LRH 4 2270
Larry, the autonumber field is set to Field Size Replication ID. What
this means is that for every record created, the machine creates a
GUID for each record.
See the link below for further info: http://msdn.microsoft.com/library/de...ieldCreate.asp
"Larry R Harrison Jr" <la*******@cox. net> wrote in message news:<OSalb.103 533$gv5.93092@f ed1read05>... I have an Access 2000/XP with an unusual autonumber scheme; I can't figure out how it generates its very unique value.
I have the database temporarily located at this website:
http://www.dbases.net/tmp/Tuscon2k.zip
The field is called ****Company_Id* *** in the table "Companies. " There are LOTS of other tables linked to it but I deleted all of them because I was able to decipher that they aren't responsible for helping to delete this field's value, and it helps reduce the file's size.
I typically use an autonumber field simply for 1,2,3,4 etc--but this one develops a VERY unusual value even including the { in the field, not just numbers.
Tips?
LRH
"andybriggs " <me*********@db forums.com> wrote in message
news:35******** ********@dbforu ms.com... The AutoNumber field's "Field Size" property has been set to Replication ID.
I remember seeing that, but didn't think it would have an effect since it
was in the "Field Size" property. How in the world would something in the
"Field Size" property affect the type of autonumber generated? Oh well.
Now that that's settled, what reasons would one have for using such a type
of autonumber field rather than simply 1,2,3,4?
LR
On Tue, 21 Oct 2003 17:19:24 -0700, "Larry R Harrison Jr"
<la*******@cox. net> wrote: "andybriggs " <me*********@db forums.com> wrote in message news:35******* *********@dbfor ums.com... The AutoNumber field's "Field Size" property has been set to Replication ID.
I remember seeing that, but didn't think it would have an effect since it was in the "Field Size" property. How in the world would something in the "Field Size" property affect the type of autonumber generated? Oh well.
Now that that's settled, what reasons would one have for using such a type of autonumber field rather than simply 1,2,3,4?
LR
Replication IDs are intended to be unique in the world, so that, when you
copy a record from one database into another, you know it won't duplicate
any records already there. If you try to do that with 2 databases that
both start counting from 1 - I think you see the problem. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Thomas Reichelt |
last post by:
Moin,
short question: is there any language combining the syntax, flexibility and
great programming experience of Python with static typing? Is there a
project to add static typing to Python?
Thank you,
--
greetz tom
|
by: Tony Williams |
last post by:
I have a table called tblseries with a field NextNumber
I also have a form called form1 based on table1 On the form is a control
NNum which I've called NNumtxt with the following code in the BeforeUpdate
Property =NewNbr()
NewNbr is a function in Module1 the code for the function is this
Function NewNbr() As Integer
Dim rst As DAO.Recordset, db As DAO.Database
Dim lngNextNumber As Long
Set db = CurrentDb
|
by: deko |
last post by:
Is there a way to reset the AutoNumber sequence?
I have several tables that use the AutoNumber field as the Primary Key, and
I'd like to somehow do an Import/Export that will make remove the breaks in
the sequence. A few breaks in sequence is not a big deal, but I have one
table with under 200 records, but the last AutoNumber PK ID field is over
1500 - due to a lot of edits....
|
by: Traci |
last post by:
If I have a table with an autonumber primary key and 100 records and I delete
the last 50 records, the next record added would have a primary key of 101. Is
there any way to have the primary key start at 51 after the last 50 records are
deleted?
Thanks!
Traci
|
by: jimfortune |
last post by:
Sometimes I use Autonumber fields for ID fields. Furthermore,
sometimes I use those same fields in orderdetail type tables. So it's
important in that case that once an autonumber key value is assigned to
a record that it doesn't change. Occasionally I find that due to
corruption or an accidental deletion and restore of a record from a
backup the autonumber field needs to be tidied up. So when I create
(through AddNew) the autonumber...
| |
by: ndn_24_7 |
last post by:
Hello all,
I'm designing a incident reporting program that allows our security
department to record incidents. The problem i'm having is on a form,
when ever a user is going to add a new incident, the user will click a
new records button (which I created using a wizard). I need the
autonumber to appear automatically when ever the new record button is
clicked to add a new record. I do realize that I shouldnt use the
autonumber as a...
|
by: elbyc |
last post by:
Any advice on using autonumber fields in forms?
I can't get a control bound to an autonumber field ("") to start at
the next record when I create a new record.
Here's what happens:
1. Open the form
2. Click the Triangle+Asterisk at the record selectors area
3. A blank record pops up, the ID is listed as
4. Click in another control and enter some text
5. The ID changes to 7. But there are 149 records in my database.
|
by: Alan Mailer |
last post by:
A project I'm working on is going to use VB6 as a front end. The back
end is going to be pre-existing MS Access 2002 database tables which
already have records in them *but do not have any AutoNumber* fields
in them.
Correct me if I'm wrong, but I'm assuming this means that I cannot now
alter these existing Access tables and change their primary key to an
"AutoNumber" type.
If I'm right about this, I need some suggestions as to the...
|
by: slurpz |
last post by:
I'm trying to make a simple program that will convert to and from a cipher that's already set.
foo = 'a = hz\nb = ye\nc = uo\nd = pd\ne = qi\nf = jy\ng = ru\nh = sw\ni = ln\nj = ae\nk = na\nl = rt\nm = wu\nn = is\no = nd\np = hw\nq = op\nr = kb\ns = vf\nt = fc\nu = xr\nv = ex\nw = mn\nx = gb\ny = bu\nz = ie\n. = *right wing slash* \n, = *hand wave* \n" = *hand curve* \n! = *double hand jerk* \n? = *wing wave* \n... = *squiggly hand...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
| |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |