Thanks Robin
"RobinS" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> It depends on the complexity of your UI. IMHO, You have more control over
> your UI with a Windows application than you do with a web-based result.
> And with the new ClickOnce deployment available in .Net, you can easily
> deploy a WinForms application and provide incremental updates to your
> customers.
>
> RobinS.
> GoldMail.com
>
> "CAM" <(E-Mail Removed)> wrote in message
> news:uc%(E-Mail Removed)...
>> Thanks, but I am planning to use sql server 2005 for all the tables and
>> queries. What I want to know which will be better Windows Application or
>> ASP Net.Web Application for the front end and why? Thanks you in
>> advance.
>>
>> Regards,
>>
>> "sloan" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>>>
>>> Well, you've learned the hard way that Access(Jet) was never meant to be
>>> a enterprise level database.
>>> ...
>>> Here is one bit of advice.
>>>
>>> A WebApplication can show a frontend to your Jet/Access database...and a
>>> web application will communicate with the Jet/Access database as a local
>>> file.
>>> (Provided you place the mdb file on the web server).
>>>
>>> This would be (not ideal) but perhaps acceptable.
>>>
>>> A winforms application would most likely have to talk to the mdb file
>>> over the network somehow. This is what ends up killing you.
>>> Because Jet/Access is just a file sitting on a server somewhere.....it
>>> has to pull alot of data over the network just to run simple queries.
>>> If you do a join of 3 tables.......(Emp,Dept,JobTitle) for example...
>>> you pull all 3 tables and ALL rows over the network to do a query that
>>> might return 1 row.
>>> That's because Jet/Access is NOT a true RDBMS ... its a file. The
>>> JetEngine sits on the local computer.
>>>
>>> There is a way to develop a software package in a way..that's not
>>> "either/or".
>>>
>>> Check this early preview post:
>>>
>>> http://sholliday.spaces.live.com/Blog/cns!A68482B9628A842A!176.entry
>>>
>>>
>>>
>>>
>>>
>>> "CAM" <(E-Mail Removed)> wrote in message
>>> news:ec%(E-Mail Removed)...
>>>> Hello,
>>>>
>>>> I need to get some advice from a pro or someone who encounters this
>>>> situtation. Currently we are using user friendly MS Access databases
>>>> for two inventory warehouses located in California and New York.
>>>> Unfortunately we cannot connect the two together due to poor
>>>> proformance and distance (table gets corrupted) both warehouses are
>>>> separate entities, which I really wanted to make it a more enterprises
>>>> level. I want to move foward and use MS SQL Server 2005 and 2008 Visual
>>>> Basic.Net. instead of MS Access. I want to have the the ability to
>>>> have the California Warehouse able to see what New York warehouse has
>>>> in stock the same for New York to see what California has in stock. My
>>>> question is should I use Windows Application or ASP Net.Web Application
>>>> for the front end? What are the trade off or which is better? I want
>>>> to have consisted look and able to update easily the forms. Any tips or
>>>> advice will be appreciated. Thank you in advance.
>>>>
>>>> Cheers
>>>>
>>>
>>>
>>
>>
>
|
Similar Threads
