DHCP Database-How to read?

DHCP Database is in .mdb extension.
I try to open it on Microsoft Access 2003, but no luck.
"Unrecognise Database format".

Is there any way to open it and read all the assigned IP address?

You can use netsh to dump out the dhcp database to a test file

"Kam" <(E-Mail Removed)> wrote in message
news:756C9CD2-6CFE-41F8-A240-(E-Mail Removed)...
> DHCP Database is in .mdb extension.
> I try to open it on Microsoft Access 2003, but no luck.
> "Unrecognise Database format".
>
> Is there any way to open it and read all the assigned IP address?
>
>

Copy it into the proper expected location of an installed DHCP service.
Start the DHCP Service.
Look at the leases in the DHCP MMC.

I would recommend not exposing the test DHCP to the real network during this.

--
Phillip Windell
www.wandtv.com

The views expressed, are my own and not those of my employer, or Microsoft, or
anyone else associated with me, including my cats.
-----------------------------------------------------

"Kam" <(E-Mail Removed)> wrote in message
news:756C9CD2-6CFE-41F8-A240-(E-Mail Removed)...
> DHCP Database is in .mdb extension.
> I try to open it on Microsoft Access 2003, but no luck.
> "Unrecognise Database format".
>
> Is there any way to open it and read all the assigned IP address?
>
>

I don't know how.
I knew I can dump the configuration, but not all the lease IP

"Jeremy" wrote:

> You can use netsh to dump out the dhcp database to a test file
>
> "Kam" <(E-Mail Removed)> wrote in message
> news:756C9CD2-6CFE-41F8-A240-(E-Mail Removed)...
> > DHCP Database is in .mdb extension.
> > I try to open it on Microsoft Access 2003, but no luck.
> > "Unrecognise Database format".
> >
> > Is there any way to open it and read all the assigned IP address?
> >
> >
>

I would like to dump all the lease IP into SQL Database.
Is there any way to do it?

"Phillip Windell" wrote:

> Copy it into the proper expected location of an installed DHCP service.
> Start the DHCP Service.
> Look at the leases in the DHCP MMC.
>
> I would recommend not exposing the test DHCP to the real network during this.
>
> --
> Phillip Windell
> www.wandtv.com
>
> The views expressed, are my own and not those of my employer, or Microsoft, or
> anyone else associated with me, including my cats.
> -----------------------------------------------------
>
> "Kam" <(E-Mail Removed)> wrote in message
> news:756C9CD2-6CFE-41F8-A240-(E-Mail Removed)...
> > DHCP Database is in .mdb extension.
> > I try to open it on Microsoft Access 2003, but no luck.
> > "Unrecognise Database format".
> >
> > Is there any way to open it and read all the assigned IP address?
> >
> >
>
>
>

show client

Look this up here:
http://www.microsoft.com/resources/d....mspx?mfr=true

"Kam" <(E-Mail Removed)> wrote in message
news:ECC94FDE-562D-4822-83E0-(E-Mail Removed)...
>I don't know how.
> I knew I can dump the configuration, but not all the lease IP
>
> "Jeremy" wrote:
>
>> You can use netsh to dump out the dhcp database to a test file
>>
>> "Kam" <(E-Mail Removed)> wrote in message
>> news:756C9CD2-6CFE-41F8-A240-(E-Mail Removed)...
>> > DHCP Database is in .mdb extension.
>> > I try to open it on Microsoft Access 2003, but no luck.
>> > "Unrecognise Database format".
>> >
>> > Is there any way to open it and read all the assigned IP address?
>> >
>> >
>>