is it possible to develop a client Server environment program using oledb connection to an acess databse
If yes can some one give me some pointers.
Yasho

yvk

__________________
yvk

Along the lines of using access for a client-server program? I'd recommend against it. Save access based applications for programs that will be desktop only. Anything client-server should use a "real" data system like mySql, MSSQL Server or Oracle. If you are concerned with obtaining systems that require licensing, there are some free options: Microsoft SQL Server (2000) Desktop Edition (MSDE); SQL Server 2005 Express (fully functional RDBMS but missing enterprise level features).

What kind of client server app are planning to build?

-Peter

I* am planning to build a point of sale program with a full inventory, Sales and Sales tax reports capacity. Initially it will not have accounting capabilities but later i would like to include it.


yvk

well.. you better use Peter suggestion and try with a more robust database... SQL server 2005 is a good choice...

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========

POS systems, how fun! ><

In any case, SQL Server 2005 Express should work out nicely for you but there are a few limitations to it:
-It can not utilize more then 1GB of RAM
-It can not utilize multiple CPU's
-The Database size can not exceed 4GB
-No Built in Mgmt tools (Though you can download Express Manager for free which gives you Query Analyzer and such)
-No analysis or reporting tools. (DTS)

The POS side of things should have no problem with the above limitations, however, the financial data may be a problem since (in the states any way) you are required to keep 7 years worth of financials on file in the event that you would be audited. 7 Years worth of data is a lot of information so you need to take that 4GB size limitation into account. (Of course you could back up the .mdf file to DVD at the end of the year, trucate the data tables and start the new year fresh)

hth.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html
================================================== =========
Why can't Programmers, program??
http://www.codinghorror.com/blog/archives/000781.html
================================================== =========

just to add.. if you use access aren't you limited to 1 GB??

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========

I believe Access had/has a limit of 2GB but it has been my experience that access starts getting flakey when your database starts getting above 500MB.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html
================================================== =========
Why can't Programmers, program??
http://www.codinghorror.com/blog/archives/000781.html
================================================== =========