ACT Help

I'm trying to list the relevant regulations/acts that are applicable to

a) a CRM (Customer Relationship Mgmt) system : guess PDPA (Personal
Data Protection Act) is applicable; if it contains a US customer's data,
guess GDPR is applicable. What else?

b) for a procurement system, Goods & Services Tax Act is applicable.
What else?

c) for a HR/Payroll, "Computer Misuse Act" & what else? Guess PDPA
is not applicable for Payroll but applicable to HR (as Date of Birth
& NRIC# is there)

1 Comment

Build an E-Commerce Site with Angular 5

LVL 12

Learn how to build an E-Commerce site with Angular 5, a JavaScript framework used by developers to build web, desktop, and mobile applications.

We have a client that has ACT 2011 on Windows Server 2012 R2. They have somehow managed to damaged all of their ADF files by messing with ACT 2011 and SQL server. We have no idea what was done except that it is not working.

1. We are getting this error message with all the current database/files when we try to open them:

This database cannot be opened because the SQLServer version of this database cannot be identified.

2. When we restore backup files from before this issue occurred and try to open them we get a dialog box that say it will verify the database. However, the next moment. we get an error message:

The log scan number (1201:656:1) passed the log scan in database 'Sales' is not valid, The error may indicate data corruption or that the log file (.ldf) does not match the data file (.mdf). ......

3. Finally, when we try to attach the file (that the client "messed with") to the database (via ACTDiag) I get this error message:

"The database was created with a version of SQL Server that is neither SQL Server 2005 or Server 2008. Attaching a non-SQL 2005 or 2008 database is not supported." However, I do not believe SQL version about 2008 R2 has been on this machine.

We are doing what seems to be endless research and multiple solutions for SQL and/or ACT and nothing seems to be working. Any thoughts or advice?

9 Comments

Excel Table Support.
I have created a Table in an excel worksheet where users will be expected to add new rows manually. Note that this document will be a shared document on Sharepoint - so I cannot use any VBA etc.

I have created a number of other tables in the workbook that act as Data Validation lists. The data validation etc is working fine.

However - this is my problem. The user only has to enter two pieces of information in the table - and both pieces of data are entered into the first two cells/columns of the table. Normally this works perfectly - you just go to the first row under the table and begin typing - and when you tab to the next cell - the table automatically expands to add the row etc.
However, the first column (and second column) are both controlled by a Data Validation list.

The issue is - if you click on the cell below the table - the data validation is not available yet (as the table has not expanded) - so the person cannot "Select" from the list. If they attempt to type something - if they get it wrong and tab to the next column then they will of course get an error - because the table will expand and the cell now contains validation - so they either have to retry or cancel - both of which "remove" the new table row added - so the validation goes away - so they cannot select from the drop list (as it no longer exists on the cell).
So I am kind of between a rock and a hard place. I want to make it as simple as possible - basically being able …

10 Comments

Question by

hodgem

2018-10-18

Syncrronizing ACT with Outlook

Has anyone successfully used software to sync ACT contacts and activities? Apparently there has been an ongoing issue with the built in feature in ACT to sync contacts/calendars with Outlook 2016. Any help would be much appreciated. Hopefully someone has had a good experience with an add-on software of some type - thank you!

2 Comments

I am working in Access 2010. I have a main form with subform1 and subform2 (this is a continuous form) on subform1. The problem is with the tab order of subform2. There are only two fields on the form. They are phone, with an input mask, and phone type. The tab order is correct and it should go to phone but the tab moves it from subform1 to the phone type field and completely bypasses the phone field. The next tab takes you to the phone field. This only happens on the first record. Once the phone and type are filed in it advances to the second record's phone field first.

I set up forms like this a lot and have never seen it act this way. Any ideas why this is happening?

3 Comments

LVL 1

Question by

GeeMoon

2018-06-15Solved

Lost email history/notes with GoldMine Premium

My client lost email history and notes within his Goldmine Premium Edition version 2017.1.0.422. I have image backups running. If I grab an earlier copy of the data base, he will lose data he has entered for the last 7 to 10 days (since he noticed the issue). Is it possible to just restore the missing email history/notes without having to resort to an older GB DB copy?

3 Comments

I am running the act reader utility first time. It is asking current password which I am keeping blank and then providing new password .
But when I click on Reset button it throws error saying "Current password is not valid". Please see attachmentActReaderUtility_error.docx for detail.

Please help.

5 Comments

LVL 1

Question by

beavoid

2018-04-25Solved

Help me Unenroll from pitiful dating site - trouble !

Hi
singleparentmeet.com is a really pitiful dating site. I want to unenroll, but their site is truly pathetic.
They don't have tech support and their help page requires 3rd party cookies.
Dating is a hotbed of scammers. Enabling 3rd party cookies doesn't appeal to me, especially from a crappy site that might have vultures, or Nigerians waiting for idiots to allow them access to info. Nigerian vultures!? How can I safely unenroll from this site? Can I get VISA to read them the riot act? They will probably charge me soon, month end!

Thanks

3 Comments

Question by

Nick Collins

2018-04-24Solved

Act - Outlook Address Book

When I load up Outlook I get the following error message. The Act address book service is not properly configured or the configured database is locked. How do you uninstall this

1 Comment

LVL 4

Question by

Alexandre Michel

2018-04-10Solved

Install IIS on RDS - Yes or No???

Hi Experts

What is the Best Practice re IIS & RDS services?

We have 2 VMs on a HyperV: DC + RDS (both WIndows 2016)
Our CRM, ACT! from Sage, is currently installed on the RDS but is only used internally.
We need to install a IIS / Web Server to give remote access to ACT! via the web

Can I use the RDS to install these additional components? My instinct is to build a new VM and install ACT! on that VM.

What says you?

Alex

8 Comments

Why Diversity in Tech Matters

LVL 12

Kesha Williams, certified professional and software developer, explores the imbalance of diversity in the world of technology -- especially when it comes to hiring women. She showcases ways she's making a difference through the Colors of STEM program.

Hi - We are running a terminal services/Citrix server 2016 with about 25 users, and use the CRM software ACT version 20 (latest). When we launch ACT, after about 10 seconds, we get the error "The requested performance counter is not a custom counter, it has to be initialized as read only" (pcerror.png - attached) . Of course, this being a terminal services/Citrix environment, happens for all users logging in and using the software. I've contacted ACT support, and they are claiming its a Windows problem. ACT Support did send me an article that has instructions on how to replace/reset the performance counters on the server, but it hasn't fixed the issue. Also, when the error occurs, there are about 6 or 7 miscellaneous events that show in the event viewer, which I've attached as well. I'm just not sure where this error is coming from, and any help with this would be greatly appreciated.
pcerror.png
perf1.png
perf2.png
perf3.png
perf4.png
perf5.png
perf6.png

14 Comments

LVL 3

Question by

SAM IT

2018-02-08Solved

sort-object -descending the lastlogondate

Below mentioned script fine. I am trying to sort-object -descending the lastlogondate but output not getting as expected, getting output in generic .

Can any one assist to sort the lastlogondate in to – descending.

Thanks in advance

$DCs = 'DC01','DC02'

$ADObjects = @{}
ForEach ($DC in $DCs) {
	Write-Host "Processing logons at $($DC) ..."
	Get-ADComputer -Filter * -Property lastLogon -SearchBase "DC=test,DC=com" -Server $DC | ForEach-Object {
		If ($ADObjects.ContainsKey($_.SamAccountName)) {
			If ($ADObjects[$_.SamAccountName].LastLogon -lt $_.lastLogon) {
				$ADObjects[$_.SamAccountName].LastLogon = $_.lastLogon
				$ADObjects[$_.SamAccountName].LastLogonAt = $DC
			}
		} Else {
			$ADObjects.Add($_.SamAccountName, ($_ | Select-Object SamAccountName, Name, LastLogon, @{Name='LastLogonAt'; Expression={$DC}}))
		}
	}
}
$ADObjects.Values |
	Sort-Object Name, SamAccountName, @{Name='Last Logon Date'; Expression={If ($_.lastLogon) {[datetime]::FromFileTime($_.lastLogon)} Else {'None'}}}, LastLogonAt |
	Export-CSV C:\temp\LastLogonReport.csv -NoTypeInformation

Open in new window

3 Comments

LVL 1

Post by

Giridhara Raam M

2017-12-12

TeamViewer hacked: Here’s how to protect your systems

Hi there,

TeamViewer can be exploited using a vulnerability allowing users to switch between viewer and presenter side, or remotely control the server. If you are using TeamViewer in your enterprise, do act now.

Read more: https://goo.gl/2E65yX

TeamViewer hacked: Here’s how to protect your systems « ManageEngine Blog
After reports of a serious bug, the developers behind the popular remote desktop management software TeamViewer has released an important patch t...

0 Comments

Hi,

I just wanted to create a batch script which should act as a watch folder, whenever a pdf file is landed in a specific folder it should open automatically and if possible it should get delete on its own after 2 days exactly...

So whenever the new file is created it should open on its own to the viewer..

thanks in advance

Logesh S

6 Comments

I currently have an SBS2011 running domain1.com in native mode (i.e. mx records domain1.com->public IP, ptr -> domain1.com) and I have another two domains which I've added as authoritive domains and use SBS POP3 connector to get email for them.

Lately one of the domains has been losing email and I want to make it native with the current host as a backup using mx records. To do this I've thought of the following:

1. mx records domain2.com -> public IP priority 0
mx records domain2.com -> current host priority 100
2. Change current host to act as backup in case public IP goes down and forward email to it once it comes back up.
3. Make PTR changes.

Now my main issues are 2 and 3. Will I need to use cpanel to create the exchange email accounts in the current host or will it keep the email in a general store and send them to the correct recipients once the public IP comes back on. And will I need to make any changes to PTR? Some say yes others just say that I need to make changes to the SPF to allow sending from public IP. Will multiple PTR pointing to one public IP mess things up?

4 Comments

LVL 3

Post by

Abraham Deutsch

2017-12-06

Optimum installed a modem (with one port on it) do their modems act as a router or do I need to add a router?

1 Comment

LVL 27

Expert Comment

by:Brian B2017-12-07

Hi Abraham. You have entered this as a post, but it looks like you are asking for help. To get the best response from the Experts, you should probably re-submit this as a question using the "ask a question" button at the top of the page, or this link: https://www.experts-exchange.com/askQuestion.jsp

If you do ask a question, please post the link to it back here so others can find your question and help you more quickly.

Please see here for further details: http://support.experts-exchange.com/customer/portal/articles/756544-how-to-succeed-at-ee-as-an-asker

LVL 2

Post by

Ryan

2017-11-30

This is a copy of part of the article located here:
http://www.tomshardware.com/news/how-to-fight-fcc-net-neutrality,36017.html

net neutrality
vote takes place 12/14/17:

Even so, it is the work of but a moment, so we all may as well do it. Go to www.fcc.gov/ecfs/filings/express, and under Proceeding, enter 17-108 (the dystopian-named “Restoring Internet Freedom” order). Fill in the form very, very, very carefully, ensure you get an email confirmation, and submit.

Your voice will be louder, as it were, with a phone call. Call the FCC and leave a message letting the agency know that you want to keep net neutrality as it is. Dial 1-888-225-5322, and be polite, patient, and persistent. You want Option 1, Option 4, Option 2, Option 0. Enter a complaint on proceeding 17-108.

Here’s a sample script: “Hi, my name is ___, and I live in [city], [state]. I’m registering a complaint about the proposed repeal of net neutrality, because it will hurt American consumers, reduce internet access, and restrict the open flow of information. I strongly oppose the undoing of net neutrality, which is at the core of proceeding 17-108. Thank you.”

Then call your members of Congress. The FCC commission is appointed and makes these decisions, but Congress can pressure the agency to do the right thing, and it can also put forward legislation to make net neutrality law instead of just policy. Find your congresscritter at https://contactingcongress.org/, and call the local office …

How To Fight The FCC On Net Neutrality (Opinion) Net neutrality is no laughing matter, and the future of the internet is currently at stake.

0 Comments

LVL 2

Question by

infedonetwork

2017-11-29Solved

Sage Act can't connect to database

Few days ago users start to complain that nobody can connect to the database located on the server.
So I start with the basics.
Verify that all the Act and SQL services are start it on both the client and the server. Make sure the Act sync is running on the server.
I reboot both server and client machine.
I move the database from the server on the local client machine to test it locally.
I even install Act on the server where the database reside. I also restore the Database from backup like few days before all this happens. Still the same error no matter from where I try to run it.

3 Comments

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.

2 Comments

Exploring SharePoint 2016

LVL 12

Explore SharePoint 2016, the web-based, collaborative platform that integrates with Microsoft Office to provide intranets, secure document management, and collaboration so you can develop your online and offline capabilities.

Question by

chris massey

2017-11-14Solved

exporting from Act!

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!

ACT
Software

3 Comments

LVL 1

Question by

unrealone1

2017-10-24Solved

RDS solution that may impact Act/ Microsoft query

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?

2 Comments

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

3 Comments

load previous comments (1)

Author Comment

by:pcstech-mwarren2017-10-13

Thanks Brian , my bad

LVL 27

Expert Comment

by:Brian B2017-10-13

No problem. Link to question is here: https://www.experts-exchange.com/questions/29062388/Azure-and-AD.html

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

5 Comments

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

3 Comments

LVL 1

Question by

unrealone1

2017-09-07Solved

Advice on RDS server

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.

5 Comments

ACT

Related Topics

TeamViewer hacked: Here’s how to protect your systems

ACT

Related Topics