Adding user-defined property to Access db

[Sharon via AccessMonster.com]

Hi,

Does anyone know how can I add a property to the db using ADO.NET?
I need to add a version to my DB. In DAO I added a property to the Database object, but here, I'm stumped.
I will be glad to recieve suggestions...

Thanks!

--
Message posted via http://www.accessmonster.com

[David Schofield]

On Tue, 11 Jan 2005 13:50:13 GMT, "Sharon via AccessMonster.com"
<fo***@AccessMonster.com> wrote:

Hi,

Does anyone know how can I add a property to the db using ADO.NET?
I need to add a version to my DB. In DAO I added a property to the Database object, but here, I'm stumped.
I will be glad to recieve suggestions...

Thanks!

--
Message posted via http://www.accessmonster.com

Hi
Probably not via ADO.
My first reaction was that you could do this without DAO by invoking
the item on the file menu from code, but this is too much of a pig's
ear for me to get working - it would probably require sendkeys or
mega-API programming to simulate sendkeys.
You can use DAO together with ADO, provided you disambiguate common
terms (eg DAO.recordset, ADO.recordset)
David

[Darryl Kerkeslager]

You need to use ADOX for data definition, not ADO.

Darryl Kerkeslager

"David Schofield" <d.***************@blueyonder.co.uk> wrote

Does anyone know how can I add a property to the db using ADO.NET?
I need to add a version to my DB. In DAO I added a property to the Database object, but here, I'm stumped.I will be glad to recieve suggestions...

Probably not via ADO.

[Terry Kreft]

Don't think you can use ADOX to add properties to a Jet database.

If you know different then please show us.
--
Terry Kreft
MVP Microsoft Access
"Darryl Kerkeslager" <Ke*********@comcast.net> wrote in message
news:sp********************@comcast.com...

You need to use ADOX for data definition, not ADO.

Darryl Kerkeslager

"David Schofield" <d.***************@blueyonder.co.uk> wrote

Does anyone know how can I add a property to the db using ADO.NET?
I need to add a version to my DB. In DAO I added a property to the Database object, but here, I'm stumped.I will be glad to recieve suggestions...

Probably not via ADO.

[Terry Kreft]

According to MSDN Database.CreateProperty is not supported by ADO(X).

You'll need to use DAO still I believe.

--
Terry Kreft
MVP Microsoft Access
"Sharon via AccessMonster.com" <fo***@AccessMonster.com> wrote in message
news:98******************************@AccessMonste r.com...

Hi,

Does anyone know how can I add a property to the db using ADO.NET?
I need to add a version to my DB. In DAO I added a property to the Database object, but here, I'm stumped. I will be glad to recieve suggestions...

Thanks!

--
Message posted via http://www.accessmonster.com

[Darryl Kerkeslager]

Oops. Read the "Database Object" as table, field, etc, but overlooked the
'version' part.

Darryl Kerkeslager

"Terry Kreft" <te*********@mps.co.uk> wrote

Don't think you can use ADOX to add properties to a Jet database.

If you know different then please show us.
--
Terry Kreft
MVP Microsoft Access
"Darryl Kerkeslager" <Ke*********@comcast.net> wrote

You need to use ADOX for data definition, not ADO.

Darryl Kerkeslager

"David Schofield" <d.***************@blueyonder.co.uk> wrote

>Does anyone know how can I add a property to the db using ADO.NET?
>I need to add a version to my DB. In DAO I added a property to the

Database object, but here, I'm stumped.

>I will be glad to recieve suggestions...
Probably not via ADO.

[Terry Kreft]

It's easily done.

--
Terry Kreft
MVP Microsoft Access
"Darryl Kerkeslager" <Ke*********@comcast.net> wrote in message
news:vo********************@comcast.com...

Oops. Read the "Database Object" as table, field, etc, but overlooked the
'version' part.

Darryl Kerkeslager

"Terry Kreft" <te*********@mps.co.uk> wrote

Don't think you can use ADOX to add properties to a Jet database.

If you know different then please show us.
--
Terry Kreft
MVP Microsoft Access
"Darryl Kerkeslager" <Ke*********@comcast.net> wrote

You need to use ADOX for data definition, not ADO.

Darryl Kerkeslager

"David Schofield" <d.***************@blueyonder.co.uk> wrote
> >Does anyone know how can I add a property to the db using ADO.NET?
> >I need to add a version to my DB. In DAO I added a property to the
Database object, but here, I'm stumped.
> >I will be glad to recieve suggestions...
> Probably not via ADO.

[Michael \(michka\) Kaplan [MS]]

"Terry Kreft" <te*********@mps.co.uk> wrote...

According to MSDN Database.CreateProperty is not supported by ADO(X).

You'll need to use DAO still I believe.

Yes, you do, there is no Jet Property Manager Support in ADO or ADOX or
JRO -- its DAO or nothing....
--
MichKa [MS]
NLS Collation/Locale/Keyboard Technical Lead
Globalization Infrastructure, Fonts, and Tools
Microsoft Windows International Division

This posting is provided "AS IS" with
no warranties, and confers no rights.