Does adding indexes affect how an Access/Jet application functions?

We have an Access application using Jet. I added some new indexes yesterday and now they are being blamed for poor Access application performance. I then dropped the new indexes. The poor performance continued until the Access application was re-linked to the SS2000 database. Then things returned to normal.

Question, does Access/Jet persist SqlServer schema info in its MDB (or elsewhere?) I am told that the MDB is copied from a share to the local PC where it grows during its use. Some people are saying the MDB persists schema info about the SS2000 schema which influences how Jet accesses the SS2000 database. Is that true? Is there a link where I can read about this? I am a dba and am not an Access developer . . .

Thanks!

Michael

For linked tables in a JET database, I believe the schema is cached locally but it's not clear to me how that could result in a performance issue. You might want to post this to a Jet/Access newsgroup.

Regards,

Uwa.

|||

Thanks for your response. Can you suggest an appropriate newsgroup?

Michael

|||access.tablesdbdesign
All Office forums & newsgroups

Does adding a new column cause entire subscription to reinitialize?

Hello,
Some hopefully simple questions for the replication experts!
SQL Server 2000, transactional replication, one publisher, one
subscriber.
I have added a column to an article on the publisher and the publisher
is already published. Initially I tried to do this as follows:
sp_repladdcolumn@.source_object = 'tblA',
@.column = 'NewField',
@.typetext = 'int NULL',
@.publication_to_add = 'MyPublication',
@.force_reinit_subscription = 0
but this gave me an error message:
"Error 21381. Cannot add (drop) column to table 'tblA' because the
table belongs to publication(s) with an active updatable subscription.
Set @.force_reinit_subscription to 1 to force reinitialization"
I then re-ran the above with @.force_reinit_subscription=1. The command
worked and returned the message "subscription(s) reinitliazed" but the
new column hasn't appeared on the subscriber.
My questions are as follows:
1 - Do I have to re-run the Snapshot Agent?
2 - If I do re-run the Snapshot Agent, will it reinitialize all other
tables (and their data) or will it just add the new column?
3 - Is there a way I can view the reinitialization commands that are
queued at the publisher to see whether the queued command is to add the
new column or whether it is to reinitialize everything?
Thanks very much!
Pawel
For information: the snapshot agent ran in the evening. The snapshot
agent copied across the new field ALONG WITH all tables related to
'tblA', so it's just as well that I didn't kick it off manually during
the day.
I would still like to know if there is a way to view the commands which
the snapshot agent is due to execute. Does anyone know?
Thanks
Pawel
Pawel wrote:
> Hello,
> Some hopefully simple questions for the replication experts!
> SQL Server 2000, transactional replication, one publisher, one
> subscriber.
> I have added a column to an article on the publisher and the publisher
> is already published. Initially I tried to do this as follows:
> sp_repladdcolumn@.source_object = 'tblA',
> @.column = 'NewField',
> @.typetext = 'int NULL',
> @.publication_to_add = 'MyPublication',
> @.force_reinit_subscription = 0
> but this gave me an error message:
> "Error 21381. Cannot add (drop) column to table 'tblA' because the
> table belongs to publication(s) with an active updatable subscription.
> Set @.force_reinit_subscription to 1 to force reinitialization"
> I then re-ran the above with @.force_reinit_subscription=1. The command
> worked and returned the message "subscription(s) reinitliazed" but the
> new column hasn't appeared on the subscriber.
> My questions are as follows:
> 1 - Do I have to re-run the Snapshot Agent?
> 2 - If I do re-run the Snapshot Agent, will it reinitialize all other
> tables (and their data) or will it just add the new column?
> 3 - Is there a way I can view the reinitialization commands that are
> queued at the publisher to see whether the queued command is to add the
> new column or whether it is to reinitialize everything?
> Thanks very much!
> Pawel
|||Pawel,
as your test shows, if you are specifying @.force_reinit_subscription=1, the
snapshot will contain everything and if not, it won't. To see the commands
that the snapshot agent runs you can use sp_browsereplcmds. Also you can
look in the distribution working folder to see the actual files.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Paul,
Just to clarify, I don't think the snapshot contained everything. It
looks like it only contained the tables which have a relationship with
'tblA', not all the tables in the published database.
Thanks for the note about sp_browsereplcmds.
Pawel
Paul Ibison wrote:
> Pawel,
> as your test shows, if you are specifying @.force_reinit_subscription=1, the
> snapshot will contain everything and if not, it won't. To see the commands
> that the snapshot agent runs you can use sp_browsereplcmds. Also you can
> look in the distribution working folder to see the actual files.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)

Document Maps

What do I need to do to eliminate the document maps (Drill downs showing on
Left side of the report). I do not remember adding and have checked the
NAVIGATION properties of all the matrices in my report.
ThanksCheck the Label properties in your report. (They may be buried, so a search
through your code may be necessary.)
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Asim" <Asim@.discussions.microsoft.com> wrote in message
news:ECFFFE76-E424-4A56-9F9C-569A59CDE6E1@.microsoft.com...
> What do I need to do to eliminate the document maps (Drill downs showing
> on
> Left side of the report). I do not remember adding and have checked the
> NAVIGATION properties of all the matrices in my report.
> Thanks
>|||By searching through code, I mean using "View Code" in Visual Studio, or
opening the RDL file directly with a text editor.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Jeff A. Stucker" <jeff@.mobilize.net> wrote in message
news:OnRZUGS%23EHA.3416@.TK2MSFTNGP09.phx.gbl...
> Check the Label properties in your report. (They may be buried, so a
> search through your code may be necessary.)
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "Asim" <Asim@.discussions.microsoft.com> wrote in message
> news:ECFFFE76-E424-4A56-9F9C-569A59CDE6E1@.microsoft.com...
>> What do I need to do to eliminate the document maps (Drill downs showing
>> on
>> Left side of the report). I do not remember adding and have checked the
>> NAVIGATION properties of all the matrices in my report.
>> Thanks
>|||Thanks Jeff - I has a similar problem recently when I needed to add a group
to a table. Suddenly I had document maps and couldnt find anywhere that I had
entered labels for them. For clarification - there are many references in
these threads to viewing/editing code (the RDL). That cant be done directly
in reporting services so how do I do that? Being new to RS I guess I dont
quite understand how to use the RDL. If someone submits RDL there is
supposedly a way to "import" it to create a report?
"Jeff A. Stucker" wrote:
> By searching through code, I mean using "View Code" in Visual Studio, or
> opening the RDL file directly with a text editor.
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "Jeff A. Stucker" <jeff@.mobilize.net> wrote in message
> news:OnRZUGS%23EHA.3416@.TK2MSFTNGP09.phx.gbl...
> > Check the Label properties in your report. (They may be buried, so a
> > search through your code may be necessary.)
> >
> > --
> > Cheers,
> >
> > '(' Jeff A. Stucker
> > \
> >
> > Business Intelligence
> > www.criadvantage.com
> > ---
> > "Asim" <Asim@.discussions.microsoft.com> wrote in message
> > news:ECFFFE76-E424-4A56-9F9C-569A59CDE6E1@.microsoft.com...
> >> What do I need to do to eliminate the document maps (Drill downs showing
> >> on
> >> Left side of the report). I do not remember adding and have checked the
> >> NAVIGATION properties of all the matrices in my report.
> >> Thanks
> >>
> >
> >
>
>|||In Visual Studio, you can right-click on a report and select "View Code".
When someone posts RDL, you can save it to a file with an RDL extension, and
open it directly or add it to your project.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"MJ Taft" <MJTaft@.discussions.microsoft.com> wrote in message
news:87CFC489-72ED-41CB-BD80-821D8D2065CB@.microsoft.com...
> Thanks Jeff - I has a similar problem recently when I needed to add a
> group
> to a table. Suddenly I had document maps and couldnt find anywhere that I
> had
> entered labels for them. For clarification - there are many references in
> these threads to viewing/editing code (the RDL). That cant be done
> directly
> in reporting services so how do I do that? Being new to RS I guess I dont
> quite understand how to use the RDL. If someone submits RDL there is
> supposedly a way to "import" it to create a report?
> "Jeff A. Stucker" wrote:
>> By searching through code, I mean using "View Code" in Visual Studio, or
>> opening the RDL file directly with a text editor.
>> --
>> Cheers,
>> '(' Jeff A. Stucker
>> \
>> Business Intelligence
>> www.criadvantage.com
>> ---
>> "Jeff A. Stucker" <jeff@.mobilize.net> wrote in message
>> news:OnRZUGS%23EHA.3416@.TK2MSFTNGP09.phx.gbl...
>> > Check the Label properties in your report. (They may be buried, so a
>> > search through your code may be necessary.)
>> >
>> > --
>> > Cheers,
>> >
>> > '(' Jeff A. Stucker
>> > \
>> >
>> > Business Intelligence
>> > www.criadvantage.com
>> > ---
>> > "Asim" <Asim@.discussions.microsoft.com> wrote in message
>> > news:ECFFFE76-E424-4A56-9F9C-569A59CDE6E1@.microsoft.com...
>> >> What do I need to do to eliminate the document maps (Drill downs
>> >> showing
>> >> on
>> >> Left side of the report). I do not remember adding and have checked
>> >> the
>> >> NAVIGATION properties of all the matrices in my report.
>> >> Thanks
>> >>
>> >
>> >
>>|||Got it ... thanks
"Jeff A. Stucker" wrote:
> In Visual Studio, you can right-click on a report and select "View Code".
> When someone posts RDL, you can save it to a file with an RDL extension, and
> open it directly or add it to your project.
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "MJ Taft" <MJTaft@.discussions.microsoft.com> wrote in message
> news:87CFC489-72ED-41CB-BD80-821D8D2065CB@.microsoft.com...
> > Thanks Jeff - I has a similar problem recently when I needed to add a
> > group
> > to a table. Suddenly I had document maps and couldnt find anywhere that I
> > had
> > entered labels for them. For clarification - there are many references in
> > these threads to viewing/editing code (the RDL). That cant be done
> > directly
> > in reporting services so how do I do that? Being new to RS I guess I dont
> > quite understand how to use the RDL. If someone submits RDL there is
> > supposedly a way to "import" it to create a report?
> >
> > "Jeff A. Stucker" wrote:
> >
> >> By searching through code, I mean using "View Code" in Visual Studio, or
> >> opening the RDL file directly with a text editor.
> >>
> >> --
> >> Cheers,
> >>
> >> '(' Jeff A. Stucker
> >> \
> >>
> >> Business Intelligence
> >> www.criadvantage.com
> >> ---
> >> "Jeff A. Stucker" <jeff@.mobilize.net> wrote in message
> >> news:OnRZUGS%23EHA.3416@.TK2MSFTNGP09.phx.gbl...
> >> > Check the Label properties in your report. (They may be buried, so a
> >> > search through your code may be necessary.)
> >> >
> >> > --
> >> > Cheers,
> >> >
> >> > '(' Jeff A. Stucker
> >> > \
> >> >
> >> > Business Intelligence
> >> > www.criadvantage.com
> >> > ---
> >> > "Asim" <Asim@.discussions.microsoft.com> wrote in message
> >> > news:ECFFFE76-E424-4A56-9F9C-569A59CDE6E1@.microsoft.com...
> >> >> What do I need to do to eliminate the document maps (Drill downs
> >> >> showing
> >> >> on
> >> >> Left side of the report). I do not remember adding and have checked
> >> >> the
> >> >> NAVIGATION properties of all the matrices in my report.
> >> >> Thanks
> >> >>
> >> >
> >> >
> >>
> >>
> >>
>
>|||Data regions (matrix, table, list, etc.), groupings (except chart groups
where Labels have a different meaning), and textboxes have a property called
Label. If the Label property is set on any of these and the expression
returns a value != null, the document map will show up.
Note: Make sure to *not* remove <Label> elements on report parameters or on
chart groupings (because these are the labels shown inside the chart).
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"MJ Taft" <MJTaft@.discussions.microsoft.com> wrote in message
news:95514D4D-A4FC-456C-BC7C-1E94182AEB5E@.microsoft.com...
> Got it ... thanks
> "Jeff A. Stucker" wrote:
> > In Visual Studio, you can right-click on a report and select "View
Code".
> > When someone posts RDL, you can save it to a file with an RDL extension,
and
> > open it directly or add it to your project.
> >
> > --
> > Cheers,
> >
> > '(' Jeff A. Stucker
> > \
> >
> > Business Intelligence
> > www.criadvantage.com
> > ---
> > "MJ Taft" <MJTaft@.discussions.microsoft.com> wrote in message
> > news:87CFC489-72ED-41CB-BD80-821D8D2065CB@.microsoft.com...
> > > Thanks Jeff - I has a similar problem recently when I needed to add a
> > > group
> > > to a table. Suddenly I had document maps and couldnt find anywhere
that I
> > > had
> > > entered labels for them. For clarification - there are many
references in
> > > these threads to viewing/editing code (the RDL). That cant be done
> > > directly
> > > in reporting services so how do I do that? Being new to RS I guess I
dont
> > > quite understand how to use the RDL. If someone submits RDL there is
> > > supposedly a way to "import" it to create a report?
> > >
> > > "Jeff A. Stucker" wrote:
> > >
> > >> By searching through code, I mean using "View Code" in Visual Studio,
or
> > >> opening the RDL file directly with a text editor.
> > >>
> > >> --
> > >> Cheers,
> > >>
> > >> '(' Jeff A. Stucker
> > >> \
> > >>
> > >> Business Intelligence
> > >> www.criadvantage.com
> > >> ---
> > >> "Jeff A. Stucker" <jeff@.mobilize.net> wrote in message
> > >> news:OnRZUGS%23EHA.3416@.TK2MSFTNGP09.phx.gbl...
> > >> > Check the Label properties in your report. (They may be buried, so
a
> > >> > search through your code may be necessary.)
> > >> >
> > >> > --
> > >> > Cheers,
> > >> >
> > >> > '(' Jeff A. Stucker
> > >> > \
> > >> >
> > >> > Business Intelligence
> > >> > www.criadvantage.com
> > >> > ---
> > >> > "Asim" <Asim@.discussions.microsoft.com> wrote in message
> > >> > news:ECFFFE76-E424-4A56-9F9C-569A59CDE6E1@.microsoft.com...
> > >> >> What do I need to do to eliminate the document maps (Drill downs
> > >> >> showing
> > >> >> on
> > >> >> Left side of the report). I do not remember adding and have
checked
> > >> >> the
> > >> >> NAVIGATION properties of all the matrices in my report.
> > >> >> Thanks
> > >> >>
> > >> >
> > >> >
> > >>
> > >>
> > >>
> >
> >
> >