[AccessD] MS Access 2007 - where may one have a look atthefulllist of the new objects, properties, methods, ...

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




More information about the AccessD mailing list