Some clarifications required...

Posted on 2000-02-16
Last Modified: 2012-05-04
Que1:        Can we use MS-Acess for Client-Server application? Can multiple users login to a MS Access database ? If yes How is data security? Is MS-ACCESS is efficient to handle large database?

Que2: How we can read any E-Mail using Visual Basic 6.0.? How Login to Internet through Visual Basic application?    

Que3: Is it possible to exports Schema of a MS-Access database to SQL-Server7.0? If today we use MS-ACCESS for developing application. Later is it possible to replace the same database with SQL-Server7.0.  
Question by:ganeshokade
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment

Accepted Solution

paulstamp earned 100 total points
ID: 2528548
Ans 1 - Yes you can use Access for client server although it is not really advisable. Multiple users can log in - just dont try and open the database exclusively. Security is not great but users can be assigned permissions using the Access Workgroup Administrator program.

Ans 2 - You need to use the MAPI control to read/send e-mails - see the components list in the Project menu to add it. There is also a Microsoft internet control you can use for connecting to the web.

Ans 3 - MS Access features an upsizing wizard for exporting DBs to SQL Server (versions 97 and above I think). It it quite simple to import an Access database to SQL Server using it. Using ADO or ODBC will allow you to switch easily between database back ends if you want to change at a later date.

Featured Post

Enroll in June's Course of the Month

June’s Course of the Month is now available! Experts Exchange’s Premium Members, Team Accounts, and Qualified Experts have access to a complimentary course each month as part of their membership—an extra way to sharpen your skills and increase training.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When trying to find the cause of a problem in VBA or VB6 it's often valuable to know what procedures were executed prior to the error. You can use the Call Stack for that but it is often inadequate because it may show procedures you aren't intereste…
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

729 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question