Front End Access and Back End as SQL Server

Dear Friends,

We have MS Access database with Forms and Reports, which was started 10 years ago by users and now the data is growing very rapidly.

Did anyone tried by having MS Access as front end and SQL Server 2000/2005 as backend with minimum modifications to the forms and reports in MS Access?

Please let me know, your ideas and if there are any links in the web or in Microsoft please provide here.

Thanks in advance,

Wrong forum for this - you might try the Database Engine forum (http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=93&SiteID=1)

or the Getting Started forum (http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=158&SiteID=1)

framework 1.1 update + ssmse: get warning!?

Hello, friends,
here is my problem:
I installed sql server express on a naked Windows xp pro with SP2; of course, framework 2.0 installed, and MS-installer 3.1 installed as well. I also installed ssmse. Everything worked fine.
Then I installed all windows updates via Windows Update in internet.
Now suddenly, when starting ssmse, I get a Warning Textbox with Header "Microsoft SQL Server Management Studio Express", then the yellow triangle with the exklamation mark, but NO TEXT AT ALL, and the OK-button. So unfortunately, I do not know what to do. Only thing I found out was, that in all updates, the culprit surely is framework 1.1 update. Before installing this, everything worked fine, afterwards, well, see above.
When I click the ok-button, everything works fine, I can log in into sql server express and do what I have to do.
So my only solution at the moment is just to ignore the warning - not the best way.
Couldn't find a better solution until now.
Could anybody help?

Kind regards from
Axolotl, Mellendorf, Germany

Have you tried to reinstall / repair the management tools again. This would not take long and should re connect any links or references that were lost.

|||

Hello, Glenn,
thanks a lot for your answer.
Unfortunately, I tried that several times, also with a brand new installed windows xp pro sp2.
But, must tell you, I DID find a solution:
I downloaded the sqlexpr_toolkit_ger.exe, installed it, and now this strange message has disappeared, and ssmse is working without any problems...
I think, there might be any file destroyed by updating framework 1.1 which is reinstalled by the toolkit!?
Doesn't matter, it works.

Kind regards from
Axolotl

fragmentation question

Hi friends,
Is it possible that over any period of time page split occur thus increasing
logical fragmentation, but Avg. Page density whis is shown in DBCC
SHOWCONTIG remains relatively at the same level ? In another words, what is
exactly relationship between those two?
Thanks in advance
AlexAlex
Read this article
http://www.sql-server-performance.com/rd_index_fragmentation.asp
"Alex" <me@.isp.net> wrote in message news:9Q9If.17$Nr5.1@.clgrps13...
> Hi friends,
> Is it possible that over any period of time page split occur thus
> increasing logical fragmentation, but Avg. Page density whis is shown in
> DBCC SHOWCONTIG remains relatively at the same level ? In another words,
> what is exactly relationship between those two?
> Thanks in advance
> Alex
>|||Yes. Imagine you start with 75% full pages. As a page becomes full, it is split onto two half full
pages. So, assuming the data is spread evenly across the pages, you will end up with the middle of
100% and 50% full pages.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Alex" <me@.isp.net> wrote in message news:9Q9If.17$Nr5.1@.clgrps13...
> Hi friends,
> Is it possible that over any period of time page split occur thus increasing logical
> fragmentation, but Avg. Page density whis is shown in DBCC SHOWCONTIG remains relatively at the
> same level ? In another words, what is exactly relationship between those two?
> Thanks in advance
> Alex
>|||Thanks Uri
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%23GZtGOTMGHA.1536@.TK2MSFTNGP11.phx.gbl...
> Alex
> Read this article
> http://www.sql-server-performance.com/rd_index_fragmentation.asp
>
>
> "Alex" <me@.isp.net> wrote in message news:9Q9If.17$Nr5.1@.clgrps13...
>> Hi friends,
>> Is it possible that over any period of time page split occur thus
>> increasing logical fragmentation, but Avg. Page density whis is shown in
>> DBCC SHOWCONTIG remains relatively at the same level ? In another words,
>> what is exactly relationship between those two?
>> Thanks in advance
>> Alex
>>
>|||That means that table can have Avg Page Density(or internal fragmentation)
within desirable range (say 88-92) being at the same time somewhat heavily
defragmented (so called external fragmentattion in terms of the article Uri
refered) when logical fragmentation is way more than 10, right?
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uTYgJVUMGHA.3960@.TK2MSFTNGP09.phx.gbl...
> Yes. Imagine you start with 75% full pages. As a page becomes full, it is
> split onto two half full pages. So, assuming the data is spread evenly
> across the pages, you will end up with the middle of 100% and 50% full
> pages.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Alex" <me@.isp.net> wrote in message news:9Q9If.17$Nr5.1@.clgrps13...
>> Hi friends,
>> Is it possible that over any period of time page split occur thus
>> increasing logical fragmentation, but Avg. Page density whis is shown in
>> DBCC SHOWCONTIG remains relatively at the same level ? In another words,
>> what is exactly relationship between those two?
>> Thanks in advance
>> Alex
>>
>|||Yes. "Internal fragmentation" (how full your pages are) basically has no relationship with external
fragmentation.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Alex" <me@.isp.net> wrote in message news:aSoIf.1213$n67.425@.edtnps89...
> That means that table can have Avg Page Density(or internal fragmentation) within desirable range
> (say 88-92) being at the same time somewhat heavily defragmented (so called external
> fragmentattion in terms of the article Uri refered) when logical fragmentation is way more than
> 10, right?
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
> news:uTYgJVUMGHA.3960@.TK2MSFTNGP09.phx.gbl...
>> Yes. Imagine you start with 75% full pages. As a page becomes full, it is split onto two half
>> full pages. So, assuming the data is spread evenly across the pages, you will end up with the
>> middle of 100% and 50% full pages.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> Blog: http://solidqualitylearning.com/blogs/tibor/
>>
>> "Alex" <me@.isp.net> wrote in message news:9Q9If.17$Nr5.1@.clgrps13...
>> Hi friends,
>> Is it possible that over any period of time page split occur thus increasing logical
>> fragmentation, but Avg. Page density whis is shown in DBCC SHOWCONTIG remains relatively at the
>> same level ? In another words, what is exactly relationship between those two?
>> Thanks in advance
>> Alex
>>
>|||thanks you guys for clarification, - you confirmed my thoughts.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OUBlLCZMGHA.1028@.TK2MSFTNGP11.phx.gbl...
> Yes. "Internal fragmentation" (how full your pages are) basically has no
> relationship with external fragmentation.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Alex" <me@.isp.net> wrote in message news:aSoIf.1213$n67.425@.edtnps89...
>> That means that table can have Avg Page Density(or internal
>> fragmentation) within desirable range (say 88-92) being at the same time
>> somewhat heavily defragmented (so called external fragmentattion in terms
>> of the article Uri refered) when logical fragmentation is way more than
>> 10, right?
>>
>> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
>> in message news:uTYgJVUMGHA.3960@.TK2MSFTNGP09.phx.gbl...
>> Yes. Imagine you start with 75% full pages. As a page becomes full, it
>> is split onto two half full pages. So, assuming the data is spread
>> evenly across the pages, you will end up with the middle of 100% and 50%
>> full pages.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> Blog: http://solidqualitylearning.com/blogs/tibor/
>>
>> "Alex" <me@.isp.net> wrote in message news:9Q9If.17$Nr5.1@.clgrps13...
>> Hi friends,
>> Is it possible that over any period of time page split occur thus
>> increasing logical fragmentation, but Avg. Page density whis is shown
>> in DBCC SHOWCONTIG remains relatively at the same level ? In another
>> words, what is exactly relationship between those two?
>> Thanks in advance
>> Alex
>>
>>
>

fragmentation question

Hi friends,
Is it possible that over any period of time page split occur thus increasing
logical fragmentation, but Avg. Page density whis is shown in DBCC
SHOWCONTIG remains relatively at the same level ? In another words, what is
exactly relationship between those two?
Thanks in advance
Alex
Alex
Read this article
http://www.sql-server-performance.co...gmentation.asp
"Alex" <me@.isp.net> wrote in message news:9Q9If.17$Nr5.1@.clgrps13...
> Hi friends,
> Is it possible that over any period of time page split occur thus
> increasing logical fragmentation, but Avg. Page density whis is shown in
> DBCC SHOWCONTIG remains relatively at the same level ? In another words,
> what is exactly relationship between those two?
> Thanks in advance
> Alex
>
|||Yes. Imagine you start with 75% full pages. As a page becomes full, it is split onto two half full
pages. So, assuming the data is spread evenly across the pages, you will end up with the middle of
100% and 50% full pages.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Alex" <me@.isp.net> wrote in message news:9Q9If.17$Nr5.1@.clgrps13...
> Hi friends,
> Is it possible that over any period of time page split occur thus increasing logical
> fragmentation, but Avg. Page density whis is shown in DBCC SHOWCONTIG remains relatively at the
> same level ? In another words, what is exactly relationship between those two?
> Thanks in advance
> Alex
>
|||Thanks Uri
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%23GZtGOTMGHA.1536@.TK2MSFTNGP11.phx.gbl...
> Alex
> Read this article
> http://www.sql-server-performance.co...gmentation.asp
>
>
> "Alex" <me@.isp.net> wrote in message news:9Q9If.17$Nr5.1@.clgrps13...
>
|||That means that table can have Avg Page Density(or internal fragmentation)
within desirable range (say 88-92) being at the same time somewhat heavily
defragmented (so called external fragmentattion in terms of the article Uri
refered) when logical fragmentation is way more than 10, right?
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uTYgJVUMGHA.3960@.TK2MSFTNGP09.phx.gbl...
> Yes. Imagine you start with 75% full pages. As a page becomes full, it is
> split onto two half full pages. So, assuming the data is spread evenly
> across the pages, you will end up with the middle of 100% and 50% full
> pages.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Alex" <me@.isp.net> wrote in message news:9Q9If.17$Nr5.1@.clgrps13...
>
|||Yes. "Internal fragmentation" (how full your pages are) basically has no relationship with external
fragmentation.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Alex" <me@.isp.net> wrote in message news:aSoIf.1213$n67.425@.edtnps89...
> That means that table can have Avg Page Density(or internal fragmentation) within desirable range
> (say 88-92) being at the same time somewhat heavily defragmented (so called external
> fragmentattion in terms of the article Uri refered) when logical fragmentation is way more than
> 10, right?
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
> news:uTYgJVUMGHA.3960@.TK2MSFTNGP09.phx.gbl...
>
|||thanks you guys for clarification, - you confirmed my thoughts.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OUBlLCZMGHA.1028@.TK2MSFTNGP11.phx.gbl...
> Yes. "Internal fragmentation" (how full your pages are) basically has no
> relationship with external fragmentation.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Alex" <me@.isp.net> wrote in message news:aSoIf.1213$n67.425@.edtnps89...
>

fragmentation question

Hi friends,
Is it possible that over any period of time page split occur thus increasing
logical fragmentation, but Avg. Page density whis is shown in DBCC
SHOWCONTIG remains relatively at the same level ? In another words, what is
exactly relationship between those two?
Thanks in advance
AlexAlex
Read this article
http://www.sql-server-performance.c...agmentation.asp
"Alex" <me@.isp.net> wrote in message news:9Q9If.17$Nr5.1@.clgrps13...
> Hi friends,
> Is it possible that over any period of time page split occur thus
> increasing logical fragmentation, but Avg. Page density whis is shown in
> DBCC SHOWCONTIG remains relatively at the same level ? In another words,
> what is exactly relationship between those two?
> Thanks in advance
> Alex
>|||Yes. Imagine you start with 75% full pages. As a page becomes full, it is sp
lit onto two half full
pages. So, assuming the data is spread evenly across the pages, you will end
up with the middle of
100% and 50% full pages.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Alex" <me@.isp.net> wrote in message news:9Q9If.17$Nr5.1@.clgrps13...
> Hi friends,
> Is it possible that over any period of time page split occur thus increasi
ng logical
> fragmentation, but Avg. Page density whis is shown in DBCC SHOWCONTIG rema
ins relatively at the
> same level ? In another words, what is exactly relationship between those
two?
> Thanks in advance
> Alex
>|||Thanks Uri
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%23GZtGOTMGHA.1536@.TK2MSFTNGP11.phx.gbl...
> Alex
> Read this article
> http://www.sql-server-performance.c...agmentation.asp
>
>
> "Alex" <me@.isp.net> wrote in message news:9Q9If.17$Nr5.1@.clgrps13...
>|||That means that table can have Avg Page Density(or internal fragmentation)
within desirable range (say 88-92) being at the same time somewhat heavily
defragmented (so called external fragmentattion in terms of the article Uri
refered) when logical fragmentation is way more than 10, right?
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uTYgJVUMGHA.3960@.TK2MSFTNGP09.phx.gbl...
> Yes. Imagine you start with 75% full pages. As a page becomes full, it is
> split onto two half full pages. So, assuming the data is spread evenly
> across the pages, you will end up with the middle of 100% and 50% full
> pages.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Alex" <me@.isp.net> wrote in message news:9Q9If.17$Nr5.1@.clgrps13...
>|||Yes. "Internal fragmentation" (how full your pages are) basically has no rel
ationship with external
fragmentation.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Alex" <me@.isp.net> wrote in message news:aSoIf.1213$n67.425@.edtnps89...
> That means that table can have Avg Page Density(or internal fragmentation)
within desirable range
> (say 88-92) being at the same time somewhat heavily defragmented (so calle
d external
> fragmentattion in terms of the article Uri refered) when logical fragmenta
tion is way more than
> 10, right?
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote i
n message
> news:uTYgJVUMGHA.3960@.TK2MSFTNGP09.phx.gbl...
>|||thanks you guys for clarification, - you confirmed my thoughts.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OUBlLCZMGHA.1028@.TK2MSFTNGP11.phx.gbl...
> Yes. "Internal fragmentation" (how full your pages are) basically has no
> relationship with external fragmentation.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Alex" <me@.isp.net> wrote in message news:aSoIf.1213$n67.425@.edtnps89...
>