Go Premium for a chance to win a PS4. Enter to Win

x

ACT

934

Solutions

939

Contributors

Act! (previously known as Sage ACT!) is a customer relationship management (CRM) software application which is used to keep track of client and prospect details in a single database that can be shared by multiple users. Act! features include contact, company and opportunity management, a calendar, communication tools, the ability to track prospective customers, "dashboards", reports, and the ability to synchronize data from other applications or other Act! users over the web.

Share tech news, updates, or what's on your mind.

Sign up to Post

Hi Experts, I'm not able to  get Act to work on my new server Windows 2016. It’s version 16. The message is: “Unable to connect to the database. Please verify the Act17 SQL instance is running.”

It's working on my old server which is still online. I'd like to get some help on resolving this. I have the database in the old server too invade I need to do something their or invade i didn't back it up correctly please advise on how to.
0
Free Tool: Subnet Calculator
LVL 11
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

I am migrating away from Act! after years of frustration, but I find that the export function within the program is not great as relates to my ability to "carry along" my document attachments to contacts, histories, opportunities, and the like.

Is there a software program that will allow me to export these documents, hopefully whilst still attached/linked to the original item (contact, opportunity, history, etc.)

Many thanks in advance!
0
Hi experts, I have a client looking to move to RDS on premise or azure solution. This is because they are taking more and more remote workers on. Currently they have domain controller with ACT on it. Server 2008.
“ACT. The database sits on there DC server at present. Related to this is how Microsoft Query will work extracting data from the ACT database. If we move ACT onto RDS server (either on premise or Azure) and add Office 365 Pro so they can use remotely.
There are some custom reports in excel which use Microsoft query to look up on the ACT database directly and return the information to excel when we refresh the report in excel. First question is: does office 365 still offer this functionality (or the Microsoft query add on)?
Second Question: if query works with office 365 will it work if the ACT database is housed on the Azure cloud

there are about 13 users.
cheers for advance

Third Question: if all is set up here will the remote working setup still be able to use query with logging on remotely?
0
a 2921 router has suddenly stopped working .. i noticed that the ACT led is off.. it was blinking when the router was working correctly ..
last thing i did is getting into ROMmon mode to restore the router password ..
( confreg 0x2142)  i restarted the router right after this command .. before completing the whole configuration ...

now when i connect the router by serial console using Putty .. all i get is 3 continuous lines .. keep running for about one minute .. then they stop .. i can't type or read any thing .. please tell me what to do ..
0
Can you use azure active directory to connect to a local work-group of PC's that does not have a local DC ?
The aim is to have azure act as the DC for the local machines. We dont want to use virtual desktops.

kind regards
mark
0
 

Author Comment

by:pcstech-mwarren
Thanks Brian , my bad
0
 
LVL 25

Expert Comment

by:Brian B
0
Hi Experts!

Is there a way I can have a proper invoice number on my invoice report , my invoice report is generated from the following tables :

(1) tblInvoice
(2) tblLinedatails

Currently I'm using PK number to act as an invoice number from tblinvoice, what I want is something like "Year & 000000 & PK number ) example something like ( 2017 000001) assuming the 1 represent the tblinvoice PK


Regards

Chris
0
I'm writing a batch file that needs to read In a text file with multiple lines (2-3 or more) and assign them to variables (i.e. Line1, Line2, Line3).  which will then act on those to run jobs based on the variables read in.  What is the easiest way to do this preferably without for loops or delims. etc.

Thx,
Brian
0
Hi Experts, we are looking to introduce a remote desktop server , RDS 2016 , this will provide ACT and Office ,
their setup is as follows 1 x server 2008 (will upgrade eventually) ,20 users in house and 5-10 users remoteing in.
Their main applications are ACT on premise and office. They currently have hosted exchange but we will move them to office 365 eventually. Some of the users access from Africa and even a hotspot in Africa.
Just wondering what type of HP rack server I should be looking at, ideal Raid configuration, memory ?
thanks in advance.
0
I have a device (piece of equipment) on a local LAN that i would like to connect to our LAN remotely.  If i have a laptop connected via VPN over a WiFi connection, can i connect this device to it's extra LAN port and somehow bridge the adapters and have this device act like it's on the LAN?  the laptop is win10.
1
Can someone convert my database over
0
Ask an Anonymous Question!
LVL 11
Ask an Anonymous Question!

Don't feel intimidated by what you don't know. Ask your question anonymously. It's easy! Learn more and upgrade.

We are planning on standing up 2 Exchange 2016 servers. One in the Americas and one in Asia that would also act as failovers.
How can I setup the 2 IronPorts to differentiate between the two locations? Both would be serving the same domain.
0
I would like to demote RODC server (Windows server 2012) to disjoin the domain and act as a local file sharing server only. Please give a brief actions of what I could do? step by step in short brief only would be okay.

Many thanks.
0
My OS is win 10 pro 64 bit and I have a stand alone Lennovo M72e PC.  I also have Office 365 the Business Essentials license and use Outlook the owa version for my msn email.
 I have used previous versions of ACT but due to pc changes, I lost it and the program too.  BTW what is the new version and will it work with my OS  and my present pc set up.  is there a trial version for me to check it out again.Thank u.
0
Hi,

I am Rupesh & I am new to this forum.

I am trying to build a tool in excel which can update database maintained in access.

There will be 3 to 4 user for this excel tool which will be connected to one access database.

The excel will act as the front end tool & access as a backend tool.

I want excel VBA to perform 3 things:

1. It will update data in access based on 2 column which will act as a unique code.
2. It will add any new row if the data doesnt match with previous unique code.
3. If the user wants to delete perticular row / range then it will be deleted from database also.

Below sample of table:

Country      Product code      Sub-Brand      Mfg Base
Russia      SRU030008869020137      Syrups      Own
Russia      SRU030008869020141      Syrups      Own
Russia      SRU030008564220158      Tablets      Own
Russia      SRU030008564220258      Tablets      Own
Russia      SRU030008564220558      Tablets      Own
USA      SRU030008869020137      Syrups      Own
USA      SRU030008869020141      Syrups      Own
USA      SRU030008564220158      Tablets      Own
USA      SRU030008564220258      Tablets      Own
USA      SRU030008564220558      Tablets      Own

1st two column will act as a unique key.

We cannot use a replacement code since there will be multiple user working on different region, replacement option can change  or erase others database.

Thanks for the help in advance.

Regards,

Rupesh.
0
The following code connects only when ODBC is set up with Windows Authentication instead of specific user account. I have set it as User Defined. Is there a difference between User defined and Systen DSN in my case? Here is code the snippet :
OdbcConnection DbConnection = new OdbcConnection("DSN=NRFUsers");
            string UserId;
            string fullname;
            string email;
            string Act;
            string EmpNum;
            string Loc;
            string sDomain;
            try
            {
                DbConnection.Open();
                OdbcCommand DbCommand = DbConnection.CreateCommand();
                DbCommand.CommandText = query;
                OdbcDataReader DbReader = DbCommand.ExecuteReader();
               
                while (DbReader.Read())
                {
                    UserId = DbReader["UserId"].ToString();
                    fullname = DbReader["Full_Name"].ToString();
                    email = DbReader["Email"].ToString();
                    Loc = DbReader["Office"].ToString();
                    EmpNum = DbReader["Emp_Num"].ToString();
                    Act = DbReader["Action"].ToString();
                    sDomain = DbReader["Domain"].ToString();
                    WriteLog("User: " + EmpNum + " " + fullname + " " + Act, "NRFUser.log");
0
Hi,
We experience a problem with Outlook room booking in the following case:
1. I book a reoccurring meeting every Thursday for 5 weeks and add a Meeting Room to the invitation.
2. The meeting room is occupied 1 Thursday out of the 5 Thursdays in question
3. When I send the invitation, Outlook (the meeting room) declines ALL 5 Thursday meetings
What I would like:
4. Instead of Outlook (the meeting room) declining ALL 5 Thursday meetings, I would like the meeting room to accept the 4 thursdays where the meeting room is available and only decline the 1 Thursday where the meeting room is occupied.
In my old company, they had set up Outlook to act as bullet 4. But in my new company no one knows how to set up Outlook correctly, so meeting rooms will not dismiss all meetings in an reoccurring event, but only the one(s) where the meeting room is already booked.
I hope, you can help us with the problem :) Thank you!
0
I have a subdomain that I want to navigate directly to the login page of my ACT website. However, when I type in the domain name I get the IIS7 landing page from the server. Also, I want to redirect from port 80 to port 443.

In essence, my goal is to have the sub-domain land on the ACT login page and route all insecure traffic to the secure ports.

Please help
0
Which Database Choose?

This Article about choose the NOSQL database based on application requirement. Different NoSQL DB’s available, there are three primary concerns you must balance when choosing a data management system: consistency, availability, and partition tolerance.

 

* Consistency means that each client always has the same view of the data. * Availability means that all clients can always read and write.

* Partition tolerance means that the system works well across physical network partitions.

 

Chose the Database system based on your application requirement.

 Example Comparing MongoDB and CouchDB.

As you can see in the diagram, MongoDB and CouchDB are built with a slightly different focus. Both scale across multiple nodes easily, but MongoDB favours consistency while CouchDB favours availability.

In the MongoDB replication model, a group of database nodes host the same data set and are defined as a Replica set. One of the nodes in the set will act as primary and the others will be secondary nodes. The primary node is used for all write operations, and by default all read operations as well. This means that replica sets provide strict consistency. Replication is used to provide redundancy - to recover from hardware failure or service interruptions.

CouchDB uses a replication model called Eventual consistency. In this system, clients can write data to one node of the database without waiting for other nodes to come into agreement. The …
0
Does anyone know about this ADA Website Accessibility regulation?
The U.S. Department of Justice (DOJ) is currently working on regulations regarding website accessibility for visually impaired individuals. The regulations would apply to state and local governments described in Title II of the Americans with Disabilities Act (ADA). On April 29, 2016, the DOJ issued a Supplemental Advance Notice of Proposed Rulemaking (SANPRM) titled “Nondiscrimination on the Basis of Disability; Accessibility of Web Information and Services of State and Local Government Entities.” The DOJ plans to extend rulemaking to all public websites sometime in 2018.
0
 
LVL 2

Administrative Comment

by:Mr. Wolfe
Hi Melinda,

I know this may be confusing, but you posted a "Post" rather than a question. "Posting" is for sharing information where asking a question is for getting answers.

Click the blue "Ask a Question" button and ask that way. I suggest selecting topic for Web Development.

Mr Wolfe
EE Moderator
1
Important Lessons on Recovering from Petya
LVL 11
Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Hi,
I have lost an Excel file several times for not disconnecting an API program.
Therefore I would like a message box saying "Have you logged off?" that appears when I try to close the Excel workbook. This will act as a reminder and save me from hours of file reconstruction.
Many thanks
Ian
0
Hello:

I have created an Excel spreadsheet that pulls data from SQL through a T-SQL query that I created and placed in the Excel "Data" menu's "Connections" section.

I just found out that I need to add a column, to this spreadsheet, that will act as a formula column to eliminate a case sensitivity issue.

Anyway, this column will be a permanent column in the sense that the formula in each row for that column will need to be automatically "copied straight down" the column every time a new row is added to SQL and therefore to the spreadsheet.

How do I go about doing this?

Thank you!

John
0
ransomwareEmail2.png Friday, May 12th, a new Ransomware threat named WannaCry came onto the scene, affecting organizations in over 150 countries. Damage includes more than 200,000 people infected with the malware and roughly $28,463 paid in bitcoin to decrypt files. That number may only rise unless companies act to mitigate the threat.
Though WannaCry wasn’t a targeted attack on any particular company, institutions using Microsoft operating systems no longer supported by Microsoft security updates found themselves affected by the fast-moving malware.
For a more in-depth look at this attack, check out the following resources:
1. Learn how to prevent this threat without paying a dime.
2. Explore ways to plan ahead and prevent against possible future ransomware attacks.
3. Mitigate damage with these tips if your organization has been affected, and more.
6
I have a client who will be running ACT 2012 until his company merges with another early next year.

I've just installed ACT 2012 Pro on a Windows 10 Machine running Office 2016.  With a little tweaking the program works under Windows 10.  However, in the ACT 2012 email setup, Outlook (2016) does not show up as a choice.  I've seen this before with other programs such as old versions of Simply Accounting, and that sort of thing.

Is there a workaround for this? (Actually I'm not sure what's causing it).  I can install Outlook 2007 back on his machine for the time being, but I'd rather not.

Thanks.
Dave
0
Hello!

I am designing a template that sales people will use to log their activity. I want to make it so that, for example, cell D3 changes to "someone@example.com" when email is selected from the drop down list in E3 or "(XXX)-XXX-XXXX" when mobile phone is selected. This is easy to be done, however, when a sales person goes to log the data they will have to erase the formula to put in the info. Is there any way it can display the data I want but then act like an empty cell when a user goes to input data?
0
Our domain controller is down for good. We have 2nd DC which act as backup. Active directory is there but no DNS and when i tried installing DNS, it gives me an error
0

ACT

934

Solutions

939

Contributors

Act! (previously known as Sage ACT!) is a customer relationship management (CRM) software application which is used to keep track of client and prospect details in a single database that can be shared by multiple users. Act! features include contact, company and opportunity management, a calendar, communication tools, the ability to track prospective customers, "dashboards", reports, and the ability to synchronize data from other applications or other Act! users over the web.

Top Experts In
ACT
<
Monthly
>