Access Data Projects Uniqueidentifier problem

Hi,

I am designing a SQL server backend, MS Access (ADP) frontend
application and I came across an interesting problem.
Lets say I have a table T with the following fields(columns)
[a] (int Not Null, Primary key, Identity auto increment)
[b] (uniqueidentifier, Allow Nulls)
[c] (text)

When I open the table in datasheet view using Access and type a value
in [c], [a] and [b] get populated automatically. [a] getting filled
with incremental integers is understandable. But, I have not set the
ISRowGUID or a default value for [b] and still it gets popullated with
a random GUID. If I use SQL Server enterprise manager to enter data
into the table T, [b] does not get filled and stays Null. I forgot to
mention that there are no relationships between the tables yet.
Is it MS access that is responsible or is it me? In any case can
something be dont to prevent this? Also should there be something else
in relation to this that I have to look for in the future.

My best
Ibrahim MMSSQL itself won't put in a value unless you have a column default or a
trigger on the table, so it seems likely that Access is doing this. You
could use Profiler to see exactly what commands Access sends to the
server when you use the datasheet, but if you want to know why it does
that, then I guess you'll get a better answer in an Access group.

Simon|||Thanks Simon,

The "problem" in fact does lie in MS Access.

I found a fix here
http://www.developersdex.com/sql/me...p=581&r=3822184

Thanks a lot for all the help !
My best
Ibrahim M

Access ADP integration?

I'm sorry but Management Studio is slow, cumbersome and difficult to
quickly make changes while designing a new system. It is directly and
very visibly impacting my teams production. The same can be said for
developing databases though the Visual Studio IDE.
We are at our highest production when using Access ADP projects to
modify the database. It's intuitive, familiar and very responsive. Do
we have to wait until Office 12 before we have Access ADP / SQL 2005
integration?
Please PLEASE don't say this is not going to happen. We are highly
dependent on this and have alot of infrasture in place based on this
setup.
CI would like to expand on my dislike of Management Studio. There is no
copy / paste for tables or views. There is in Access. There is no
Search / Replace in the SQL window. You have to copy all to a text
editor to search and replace.
But I do really like the View Dependancies option though.
C|||Hi
Well, do you have SQL Server 2005 installled as a named instance? I you do
, so a named instance is consumed memory which amy hurt a performance. Also
check out whether you have AutoClose of the database option checked.
In order to make 'copy /paste' as you like in Access you will have to learn
some T-SQL commands as
SELECT * INTO NewTable FROM OldTable
In addition you have a great option in my opinon as Script Table As to make
changes and DML operations

> Search / Replace in the SQL window. You have to copy all to a text
> editor to search and replace.
Have you tried CTRL-F option in the Query Builder?
"The Cornjerker" <addoty@.gmail.com> wrote in message
news:1140311969.961191.275270@.g47g2000cwa.googlegroups.com...
>I would like to expand on my dislike of Management Studio. There is no
> copy / paste for tables or views. There is in Access. There is no
> Search / Replace in the SQL window. You have to copy all to a text
> editor to search and replace.
> But I do really like the View Dependancies option though.
> C
>|||Uri,
Thanks for helping. I'm trying hard to work with Management Studio. I
know I can do anything with SQL commands, but I think the point of
having a tool like Management Studio is to make things visual and
easier. It just doesn't seem very intuitive for rapid development.
CTRL-F is grayed out for me. I can't seem to find the AutoClose option
plus I'm not for sure what it does.
I guess my frustration comes from the fact that I'm constantly being
forced to change my development process. I'm spending more and more my
time and my development team's time learning new processes to do
basically the same thing. VB6 to VB.NET, ASP to ASP.NET, FrontPage to
Visual Studio.NET, now Access ADP to Management Studio. The products
we produce are basically the same, they just take longer to develop and
seem more difficult to maintain. I think there is something to be said
about incrementally improving technologies instead of these huge
revolutionary leaps and then abandoning previous technologies.
Sorry for the rant,
C

Accesing cube browser

My boss saw the Browser tab of a cube in an Analysis Services project in BIDS. He says he want to access it for designing his own reports in real time. I suppose the cube browser is not intended to be used directly by the users but if the boss says he want it, he means he want it.

So I wonder if there is any way to access the cube browser from managed code. Is it any kind of ActiveX control or any other thing callable by code?

Hi,

I am also facing the same problem.

Ronald

|||The cube browser in BIDS contains different controls, which were not developed for public use. One can still use its major part - Office Pivot Table, which is a part of the Office WEB Components, but in order to write programs with it one needs to have the "design time license". Otherwise the component will switch to view only mode.

Besides the license problems with OWC one would have to write additional code to expose the metadata according to AS2005 rules. The metadata browser of the pivot table shows maps the metadata according to AS2000 rules and we make it hidden.|||One more comment. If the boss will be content with calling "something" while the "report model" would be right in the BIDS's Cube Browser page then it is possible to write Visual Studio Add - In, which would access the pivot table throught its documented object model.

Write me at andrewgaATmsnDOTcom and i will send back a zip with a short C# project, which can be used as a starting point. Although i did not go any further that starting point myself (the goal was different).

Accesing cube browser

My boss saw the Browser tab of a cube in an Analysis Services project in BIDS. He says he want to access it for designing his own reports in real time. I suppose the cube browser is not intended to be used directly by the users but if the boss says he want it, he means he want it.

So I wonder if there is any way to access the cube browser from managed code. Is it any kind of ActiveX control or any other thing callable by code?

Hi,

I am also facing the same problem.

Ronald

|||The cube browser in BIDS contains different controls, which were not developed for public use. One can still use its major part - Office Pivot Table, which is a part of the Office WEB Components, but in order to write programs with it one needs to have the "design time license". Otherwise the component will switch to view only mode.

Besides the license problems with OWC one would have to write additional code to expose the metadata according to AS2005 rules. The metadata browser of the pivot table shows maps the metadata according to AS2000 rules and we make it hidden.|||One more comment. If the boss will be content with calling "something" while the "report model" would be right in the BIDS's Cube Browser page then it is possible to write Visual Studio Add - In, which would access the pivot table throught its documented object model.

Write me at andrewgaATmsnDOTcom and i will send back a zip with a short C# project, which can be used as a starting point. Although i did not go any further that starting point myself (the goal was different).