Autonumber MAC Address

[turtle]

I need to know if the following is possible. I have a vague idea how
to get started on the first part of this but completely lost on teh
exception:

We need to create a database program that issues MAC addresses
sequentially (with one exception).
The database should accept the following information:

Product Type: (e.g. G4C, G4B, G4P, CCP, …)
Product Serial Number:
Requester Name:

If the serial number has already been given MAC addresses then the
previous serial #’s MAC addresses should be re-issued. If not then
new numbers should be generated. The number of MAC addresses
generated will be dependent on the product type. For example, a G4C
needs three MAC addresses and a G4B needs one address. MAC addresses
should start at 0040c0 000000 and be issued sequentially.

The only exception is the G4C which needs to be at addresses 0040c0
xx60xx, 0040c0 xx80xx and 0040c0 xx90xx for its three interfaces
respectively. This gives 65536 unique addresses which is more than
enough. So the three addresses for the first G4C should be 0040c0
006000, 0040c0008000, and 0040c0 009000.

Is this possible using a combination of code and autonumber?

thanks,
KO

[Tony Toews [MVP]]

Re: Autonumber MAC Address

turtle <kolsby@vistaco ntrols.comwrote :

>I need to know if the following is possible. I have a vague idea how
>to get started on the first part of this but completely lost on teh
>exception:

The following links should get you started.

How To Implement Multi-user Custom Counters in DAO 3.5

http://support.microsoft.com/default.aspx?scid=kb;en-us;191253

How To Implement Multiuser Custom Counters in Jet 4.0 and ADO 2.1

http://support.microsoft.com/default.aspx?scid=kb;en-us;240317

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at

http://www.granite.ab.ca/accsmstr.htm

Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/