OK I will take some of my "angered statements" back

I
did get an auto-response that confirmed my submittion of comments but that's where it ended. I was hopeing that they will explore it more and parhaps test it or something....anyhow.
I have abandoned the idea of going through ODBC as not all the fields were avaialable that I wanted to use for some of my calcuations and multi-warehousing approach...but just imagine what can it be done if the PT "opens up though ODBC" ;-)
here is some of my old notes:
------about ODBC------
Prevaisve.SQL 2000i does provide ODBC connection to those tables that are not 'proteced' and SQL statements can be executed from other application or databases that support SQL execution.
Your PeachTree (2004) has not beed "tested with the Btrives 7.x engine" but one does get the opion to update (OR NOT) exsiting engines and registry files (not suggested by my side).
Not only that this ODBC connection works (100+ conncurrent connections is defualted) but one can programm on the top of the PT layer on platforms that can publish dynamic data over the web (ASP,JPS,VB...).
ODBC is not the fastest way when it comes to data pull but it sure is a gatway to publishing data over....hm

....I think you called it (=integrated it) along with your peachtreewebaccounting.com that runs on ASP......now, ASP CAN use ODBC to connect to most of the DBs....2+2=?
The only problem is that not all the fields and tables are accesible (hint hint) and DDE or Export/Import is the ONLY way to pull data into yet antoher application(DB) that supports appropriate import of files.
Now, if only PT programmers would realise the potential of ODBC then 10+ yrs old of a DB engine might be more apprechiated in develeopers community.
----------------------------------------
Again, I got so little help that I gave up on trying to poke information so decided to simply make "Server Specific" export/import forms and then execute them using windows scheduler along with "auto_it_file.exe".
Ones my exports are done I can use the CSV file and import it into my other application. BTW, CSV files CAN also be accessed through ODBC if u setup txt driver correctly ;-)
---about backup----
I am aware of data corrutoin on auto-backup concept but that is just antoher reson to build a small function that will run on theory:
eg.
-start backup from server side
-IF curruent user count >1 THEN
send MSG to connected users and give 20-30 sec. to save their work
ELSE drop or save their work
or something like that.
I can live with the fact that my "last user" has to re-enter an invoice...what I can't live with is the fact that just because 1 user forgot to close PT will ruin my backup.
so, in lack of PT's ablity
What I have been trying to implment now is actually a "fake" STARTPeach.exe which again is my little Autoit file that:
1. Mapps a network drive to my compnay's folder
2. Starts the actual PeachT.exe
and STOPPeach.exe that:
1.kills the users PT and also disconnects the Mapped drive
then on the Server Side backup would run on:
1. check to see if "sessions/shares" are opend
IF NOT ???? drop them anyways? eeeek :-|
2. then use PT to save a compressed backup of company data
------------------------------
it needs some work but... hey its better than "we are sorry" from Support.
my true frustration is that I have to come up with this and spend my time doing it vs. a team of programmers that works for PT making it a function.
Anyhow, it is part of the battle ;-)
take care!
All the best!
:--------------------------------------------------------------------------:
ok,ok...I did shoot the deputy but he told me he was the sheriff!
:--------------------------------------------------------------------------: