Thanks,
I tried doing a search earlier (for year 2004) but got all sorts of stuff back that didn't seem to relate. I figured asking a question myself was a bit quicker than sifting through all the results. <g>

I'll give it another shot though. Thanks for your input!

Rodd

>Rodd,
>I don't think ADS local server has any advantages over VFP tables. Hmm well I take that back <s> I just thought of one advantage. If you want to move your datastore to a database server (as in client server) it would be extreemly easy to do going from ADS local server to full version ADS.
>
>I see you are a PUTM so you can do a search for Advantage Database Server here on UT. I remember getting some hits on that a long time ago.
>
>Einar
>
>>Is there really much of a difference between Visual Fox tables and ADS local server version? What advantages are there?
>>
>>>Rodd,
>>>Advantage Database Server (ADS) is well known in the Borland comunity and is a great replacement for Paradox tables. I have not used ADS with VFP, but they support both ODBC and OLE DB so it should be easy to integrate with VFP. There are two "versions": ADS which is a true database server, and loacl server which is their free version and works similarly to VFP tables (i.e. not true database server).
>>>The biggest difference between MSSQL and ADS is probably the price <s>, ADS is a lot cheaper and provide good support.
>>>ADS has a devloper conference once or twice a year in Boise, Idaho that you can attend for a reasonable price.
>>>
>>>Einar
>>>
>>>>I just saw an add for Advantage Database Server. I had never heard of this product before. Does anybody have any experience with this product (especially in relation to VFP)? Is it everything it claims to be? How would you compare it to SQL Server? What drawbacks have you run across with this product?
>>>>
>>>>Thanks for your input.
>>>>
>>>>Rodd