Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Client Server Apps using Access as the Backend
Message
 
To
13/09/2000 11:09:53
Christopher Pinnock
United General Insurance Company
Kingston, Jamaica
General information
Forum:
Visual Basic
Category:
Database DAO/RDO/ODBC/ADO
Miscellaneous
Thread ID:
00415231
Message ID:
00416012
Views:
35
>Okay George, I am writing a Broker System for a client. Now I'm thinking of doing this thing general purpose where it can be re-sold.
>
>So the issues are
>1. Deployment
>2. Scalability
>3. Connectivity (Client/Server)
>4. Speed
>
>There are about 20 Users.
>
>I'm used to SQl Server 6.5. When I installed MSDE I don't see any interface or anything, just a screen where i can start the server.
>
>1. I don't see where I can manage a database; be it creating one or otherwise.
>
>
>I'm try it out on my personal computer with Win 98.
>
>I'm a bit confused about this thing works. HELP ????
>
>Chris

I'd like to add a couple of things to Éric's response.

MSDE allows you to scale easily to SQL Server. There are other thing to consider to ensure your app is scaleable. One other is to ensure that your app is modular. Separate your app into tiers. Do not allow your UI to talk directly to your database, use business classes to be the intermediaries. Process all your business rules in these classes. So if later you need to change the UI to IE of something else, or if you need to make changes to any part of your app it is not a major chore. There are several other advantages I could go into but my point is that you should start out with a solid approach. More work up front but pays itself back very well later.
George
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform