Shamil Salakhetdinov
shamil at users.mns.ru
Fri Oct 27 05:53:27 CDT 2006
Hi Arthur, Nothing suspicious here :) I cannot show this mentioned software in action because it is commercial with my signing NDA and this project is "dead" now and very probably forever. But nothing suspicious is used in it. In MS Access there is Replication ID type for Numbers and AutoNumbers - I do use them in this software database and VBA code: <onlineHelp> Replication ID - Globally unique identifier (GUID (GUID: A 16-byte field used in an Access database to establish a unique identifier for replication. GUIDs are used to identify replicas, replica sets, tables, records, and other objects. In an Access database, GUIDs are referred to as Replication IDs.)) </onlineHelp> <<< they are NOT autonumber, in the sense of sequential IDs. >>> Arthur, I didn't say that an Autonumber means here a sequential automatically generated ID. Autonumbers can be random of course. <<< To create a default GUID you should create a default equivalent to NewID(), but this is much different than a traditional Access autonumber. >>> MS Access Replication ID Autonumbers are MS Access feature since MS Access 97 (?) AFAIKR. There is no need to create an equivalent of NewID() MS SQL function. The similar to NewID() "magic" is built-in in MS Access Replication ID non-sequential Autonumbers. -- Shamil P.S. It's possible to generate sequentila GUIDs/Replication IDs - here is one example - http://www.sqldev.net/xp/xpguid.htm . There are others - I have seen good online article on that subject several years ago but I lost its URL... -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of artful at rogers.com Sent: Friday, October 27, 2006 4:16 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] MS Access 2007 - where may one have a look atthefulllist of the new objects, properties, methods, ... Something seems suspicious here, with all respect, Shamil. GUIDs are not autonumber, they are created by invoking the function NewID(). Perhaps that is what you meant, but they are NOT autonumber, in the sense of sequential IDs. To create a default GUID you should create a default equivalent to NewID(), but this is much different than a traditional Access autonumber. Arthur ----- Original Message ---- From: Shamil Salakhetdinov <shamil at users.mns.ru> To: Access Developers discussion and problem solving <accessd at databaseadvisors.com> Sent: Thursday, October 26, 2006 5:01:38 PM Subject: Re: [AccessD] MS Access 2007 - where may one have a look atthe fulllist of the new objects, properties, methods, ... Martin, I have here commercial software, which I did program in the past for one customer. Unfortunately this software wasn't finished / published - I did use it to dig out information about new properties... In principle there is nothing complicated here but it needs quite some coding to do that from scratch - just make a sample database with different objects and iterate all .Properties collections of every sample object and its children objects... BTW, this software was originally programmed for MS Access 97 and yesterday I had to convert it to MS Access 2003 and then to MS Access 2007. The VBA code is rather advanced and it does do a lot of "massaging" of MS Access objects and it does use several backend databases and its does put quite some data into tables etc. - all worked rather well, with one exception that using Autonumber GUIDs in some places was resulting in MS Access 2003 to GPF. This was when GUID was obtained as value of a listbox and then passed as variant to a function, which passed it as variant to another function. When I did add converting GUID to string in between all started to work OK. Just wanted to note that an advanced VBA coding originally developed for MS Access 97 works without almost any issues in MS Access 2003 and MS Access 2007... -- Shamil -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Martin Reid Sent: Friday, October 27, 2006 12:30 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] MS Access 2007 - where may one have a look atthe fulllist of the new objects, properties, methods, ... Shamil Out of interest how did you dig them out? Martin Martin WP Reid Training and Assessment Unit Riddle Hall Belfast tel: 02890 974477 ________________________________ From: accessd-bounces at databaseadvisors.com on behalf of Shamil Salakhetdinov Sent: Thu 26/10/2006 21:07 To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] MS Access 2007 - where may one have a look atthe full list of the new objects, properties, methods, ... Jim, Here is the reference on the HTML page with the list of 307 properties I have dug out so far: http://smsconsulting.spb.ru/info/acc2007/newPrpsInAccess2007.htm This is XML source of this list: http://smsconsulting.spb.ru/info/acc2007/newPrpsInAccess2007.xml -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com