I have a client whose database is large, who wnats to reduce the size of the
database and create a new databse for the old information.
Is this possible and how?
We have done this. First create a second company as a clone of the first.
This will be the historical company. Then remove historical data in the Live
company. There is quite a bit of work in doing this but it can be done with
> I have a client whose database is large, who wnats to reduce the size of the
> datab...Syncing CRM and Outlook after Importing
If I create a CRM Contact it will sync with my Outlook Contacts and
show up in Outlook as a CRM Contact. This is good. If I export my
Outlook contacts, go through the Migration process and import them
into CRM, they do not sync back with my Outlook contacts. Is there a
way to make this happen?
...CRM 3.0 - Web UI
Just wondering if anyone else has had this problem occur with their install
of CRM 3.0. When you try to access the WorkPlace >> Calender page within the
web application, i always get an error message when it tries to open the aspx
page (home_calender.aspx). The error states "Unexpected error - an error has
occured contact your system administrator"
Any ideas as to why i would not be able to open this page ?? The user
trying to open it has all roles assigned to it within CRM, and is a domain
(Windows 2003 server, running Sql 2005, Exchange 2003)
I am experienci...In CRM 3.0 is there a way to Hide the Sales or Maketing or Service
I want to be able to control users access to different sections of CRM.
So I want Jane Smith to see Sales and Marketing, and Scott Riley to only see
Sales and Service. Doing by team would also work. I was able to create
custom Roles and control entiy access but I don't see a way of controlling
Sections only appear if the user has access to one of the items within that
section. Unfortunately, there are some shared objects across the sections
(like Account/Contact) that prevent them from disappearing totally.
MVP - Microsoft CRM
"Hotwheels...SQL View duplicating records
I've created a view on inventory transactions linking IV30300 and
IV30400, wanting to pull the lot number information into the view for
each inventory trx. I have a transaction that was an INVADJ, with one
item on it, recorded at 3 different quantities, 3 different costs, and
3 different lot numbers. In my results pane, this transaction is
listed 9 times, once for each combination of qty, cost, and lot
What causes this to happen and how do I change my query to pull only
one line per combination of qty, cost and lot number in this
Thanks for the help.
Frank Hamelly...Record Locking 03-17-10
For a Ms Access 2003 Db, Split, multi-user (10 users or so) in a peer-2-peer
I read that it can be beneficial to remove record locking on the forms and
I thought edited record was what should be setup. Why not? If you remove
it, then how are updates managed in the rare even 2 user work on the same
Thank you for the clarifications.
"QB" <QB@discussions.microsoft.com> wrote in message
> For a Ms Access 2003 Db, Split, multi-user (10 users or so) in a
&g...Compact Archive Folder in Outlook 2000
How do I compact the Archive folder in Outlook 2000? I deleted a lot of
messages in it but the size has not changed. Using Advanced Personal
Folders properties does not seem to compact the archive.
Why don't you start using a new archive file? What is the current size
of the archive file? Try to keep your .pst files under 2 GB.
> How do I compact the Archive folder in Outlook 2000? I deleted a lot of
> messages in it but the size has not changed. Using Advanced Personal
> Folders properties does not seem to compact the archive.
The...CRM SQL Jobs
We have been running CRM3.0 in production for 7 months now and we just
noticed that the following SQL jobs have been failing:
MSCRM.update contract states
MSCRM Identity Reseeding
MSCRM Index Defragmentation
MSCRM Index Reindexing
MSCRM Stored Procedure Priming
I think it is just because they have been pointing towards the wrong
database within SQL.
1) Is it normal to have these jobs running on SQl for CRM?
2) Which database do I want these to point at? Metabase or MSCRM?
We use v1.2 and have re...CRM 3.0 #2
Many times i try built new campaign and i have a problem with template, i
want use some "template" to mailing action, because i don't want do 100
e-mails by foot. please help me email@example.com
...Integration between MS CRM 3.0 and OA2007
Have you heard of any tool that provides integration between MS CRM 3.0
and OA2007? Recently, it seems that a number of people are looking
forward to have this tool.
In line with this, we are currently developing a connector between
Microsoft Dynamics CRM 3.0 and Microsoft Office Accounting 2007, and we
are looking for CRM users, small business specialists and interested
professionals who are willing to be advisors for this endeavor.
Advisors will have the chance to influence the features of the software
we are building and will get to evaluate pre-release versions of our
applicatio...HTML Email templates in MS CRM 1.2
In MS CRM version 1.0 there was the possibility to include HTML in an email template. When you would include some table, link or image html tags in the email they would be converted and diplayed as html.
Our problem is that version 1.2 doesn't seem to support this any longer.
Is this true or is there another way to do this. If it is remover, why has that been done.
Yes this is a removal in v 1.2 to disallow scripting via the editor.
Priya J...Access Denied when connecting to CRM 1.0
When accessing the MS CRM 1.0 Server I am always receiving the 401.3
error, access denied/unauthorised to access this resource etc... I am
a domain user on a computer connected to the domain (SBS2003 with CRM
running on a Win2K Server). IIS 5 is configured for Windows
Authentication only and the web page is prompting for a username and
password but failing for my domain user account however it succeeds
for the domain administrator account. I have an MSDN edition of CRM
and have licensed it successfully using the MSDN Subscriber
Organisation etc. I am registered in the CRM as a user with ...How do I set the focus for a field after new (blank) record ?
When I click the "new (blank) record" icon at the bottom of a form,
the cursor disappears. How can I make the cursor go to the first
field on the form like it does when I first go to the form.
Thanks in advance
Use the form's Current event to run a macro that contains the GoToControl
action, and use that to set the focus to the desired field.
<MS ACCESS MVP>
<firstname.lastname@example.org> wrote in message
> When I click the "new (bla...Deleting records in Access 2007 Runtime
I run my application in Access 2007 Runtime, but I can not delete any
records. How can I delete records in Access 2007 Runtime? How can I make all
the menus concerning data manipulation available in Access 2007 Runtime?
The runtime is free but stripped-down version of access.
The menus are one thing that are not available in the rutime.
You will need to build your own menus to use in the runtime.
Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia
"alex" <email@example.com> wrote in message
news:16B9B95A-327B-47B3-884D-7AA64D88AB3...CRM Mobile 07-20-05
I wonder if someone can give a definitive answer for me regarding CRM
If a sales guy is out in the field using a PDA with Pocket PC and CRM mobile
installed, can he syncronise over GPRS with the server? It looks to me that
he may have to lug a notebook around with him and have to fire that up,
tunnel a VPN and then sync through that - surely not!
......brings back a joke I once heard about a a guy who bought a wrist watch
that could do everything but couldn't pick up the suitcase that had the
Any one using it can tell me if this is right?
I mi...question on CRM Server license
We have an existing CRM 3.0 installation. We want to build a back up CRM
server / database server for disaster recovery. This will be used only if the
main server goes down some some reason. My question is, do I need to buy a
second CRM server license for this scenario?
I need to make an application that does basicly this:
- Receiving Demands from Clients for some Products
- Searching in the DataBase which Suppliers (may) have these Products
- Contacting these Suppliers (by Contact Person) for a Price Offer
- Grouping the best Price Offers and doing an Offer to the Client
- If they Client want the Offer: Ordering them by the Suppliers
- Take care of Shipping/Controls etc
- The Management of all these Clients, Suppliers, Products, Carriers,
- Printing Reports
I should make this in VB.NET, but because a lot of these action seem to b...SSRS report published in CRM 3.0
I have developed a report in SSRS, when I view the report in VS 2005 it looks
but when I publish the same report in CRM 3.0 , the format gets messed up.
Any idea? Its really frustrating..spending more time in formating than in
> I have developed a report in SSRS, when I view the report in VS 2005 it
> fine but when I publish the same report in CRM 3.0 , the format gets
> Any idea? Its really frustrating...Disable "Track in CRM" for emails
Is it possible to disable the "Track in CRM" feature in the Outlook client? I
still want emails to be able to go out from CRM, i.e. via workflows, and I
also want users to be able to attach other types of activities to records. I
just don't want users to be able to promote an Outlook email up to CRM. Not
sure if this is even possible.
On Nov 24, 2:11=A0pm, jdstento <jdste...@discussions.microsoft.com>
> Is it possible to disable the "Track in CRM" feature in the Outlook clien=
> still want emails to be able to go out from CRM...Assigning records in Offline Mode
Is "Assigning records " available in offline ?
if yes, how to download entity "User" ?
the entity is not in "Look for" list (in loacl data screen) even
though flag "offline availability" is marked?
just check this
sorry for that. ;-)
> Is "Assigning records " available in offline ?
> if yes, how to download entity "User" ?
...Database Deleting Record Problem
Just launched a new database. Using an Autonumber field to generate document
numbers (sequence is not important - just need a unique identifier). There
are a number of fields that are required fields based on an option group
selection. Problem; If all required fields (they are required fields
programmatically) are not completed and you attempt to exit the form, a
message box appears asking " Do you want to save changes". If you say "Yes"
the form closes, does not save, and the record is deleted - but users are not
aware of this deletion - and they think the recor...CRM 3.0 Contract Template
I've created several CRM contract which all worked fine. When I go to assign
a date range contract to an account it says "Allotment Type" is "Number of
Tickets" it seems to do this no matter what template you select. Is this a
bug or have I done something wrong.
ITT Europe Limited
...Does MS CRM 3.0 use Impersonation/Delegation model...?
I wanted to check on the authentication method used by MS CRM web
server in communicating with the database when they are installed on
Does it use trusted sub system model (where Db trusts the web/app
server for authentication of orginal callers) OR delegation model
(where original caller's credentails are passed to the DB)..?
CRM 3.0, SQL 2000 SP4, Windows 2003 SP1
We upgraded our CRM to 3.0 back in January and now I am thinking of
upgrading the SQL Server to SQL 2005. Has anyone gone through this, either
successfully or unsuccessfully? I'm having trouble finding info online as to
whether this is a good or bad idea.
Any feedback would be appreciated.
We have Crm 3.0 running with an Sql 2005 server and Sql 2005 reporting
service for over 6 months without any problems.
We upgraded our 1.2 install without problems.
Patrick Verbeeten (MCSD)
Web: aviva-it....Record Counts
I built a simple form using the wizard (it's easier...) Its record source is
a table (tblBoM). I use a combo box in the header to filter the form. I need
to display in a combo box the number of records in the form. Me.Count is
giving me some number which may or may not be the UnFiltered record count,
but in any case, it's wrong.
What can I use? I've bludgeoned it to death with a dCount() reference as the
control source of the text box, but I just can't imagine that's the best way
On Fri, 13 Nov 2009 09:33:06 -0800, JimS wrote:
> I ...