I went too fast, it is working only working when importing the source data not for linking to the data source.
.
and in order to update records in the table, source data has to be linked
Still trying to figure out, why when linking to the data source the results show #Deleted for all records
Hello,
I use sometimes MS Access to link Sage 300 tables using ODBC from SQL database server. Most of the time it works fine. For a few tables, like APPYM, the results are "#Deleted" for all records, while opening the same table with Excel works fine.
SQL database properties options:
I...
- less than 5 users (ACCPAC)
- Dell PowerEdge T410 with Intel Xeon E5620 12M Cache, 32 GB, RAID 1, 2 x 450GB 15K RPM
- less than 10 users on the network (including ACCPAC users)
Hi,
I have to make a decision between Windows Server 2008 or Windows Small Business Server 2011 with Exchange, and I would like to know your experience.
Thank you,
I switched Tax Calculation Method to "by detail" but still doesn't work.
If the invoice type is "summary" and not "item" will that make a difference. In my case invoice type is "summary".
The other system calculate the tax by detail line.
I try to import to A/R 5.5A invoices from another system.
Here is a sample of a summary invoice :
RTTCode RTDate RTCCode RTDesc RTTAmt RTAmt RTTax1Amt RTTax2Amt
CUST 01-Feb-11 DIST Description $2,426.60 $2,130.00 $106.50 $190.10
CUST 01-Feb-11 DIST Description $135,478.75 $118,919.25 $5,945.96...
We use Sage Accpac ERP 200 version 5.5A with Pervasive SQL. Each year we pay for PJC module but we don't use it. It was used only for a short time a few years ago.
How this change will affect databases, future use of Accpac?
Is it recommanded?
Hi,
My question wasn't good. Actually is when the people try to retreive their messages using Outlook and Call Pilot installed as a service on the computer, the time is not good (computers time it is good), is only the time when the message was left which not right. I tried to restart like...
Hi,
How can I set time (BCM200) because is 15 minutes late ?
Also we have in the office a phone which rings (I think is call auto attendant, when 0 is pressed the call is forwarded to this phone) every time somebody calls before the caller listen the options. Is it possible that when somebody...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.