Re: Access app and ASP.NET

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Kevin Spencer (kevin_at_DIESPAMMERSDIEtakempis.com)
Date: 02/03/05 

Date: Thu, 3 Feb 2005 11:01:03 -0500

You don't need Access at all to get data out of an Access database. You only
need the .Net OleDb provider and classes. Again, starting Access doesn't
"start" an Access database. It starts the Access executable. If you want
programmatic access to Access, you;ll have to use the Access COM object. But
I seriously doubt that you have to do that. It is extremely important for
you to understand the difference between a database and a user interface.
Access is a user interface. An .mdb file is simply a container for data
(also known as a database). Access is, furthermore, a single-user desktop
application. All it does is "talk to" the database, and display the data
contained therein in a desktop UI. 

-- 
HTH,
Kevin Spencer
Microsoft MVP
.Net Developer
Neither a follower nor a lender be.
"folke liden" <eklofnedil@-NOSPAM-hotmail.com> wrote in message 
news:OoJzFagCFHA.1932@TK2MSFTNGP14.phx.gbl...
> Ok, fair enough!
> Perhaps you can answer another question.
> I've written a C# Windows Application that starts and stops MS Access 
> (myApp.mdb). I'm using System.Diagnostics.Process. Code:
>
> private void btnStart_Click(object sender, System.EventArgs e)
> {
> myProcess.Start();
> }
> private void btnStop_Click(object sender, System.EventArgs e)
> {
> System.Diagnostics.Process[] myProcesses;
> myProcesses =
> System.Diagnostics.Process.GetProcessesByName("MSAccess");
>         foreach (System.Diagnostics.Process
>             instance in myProcesses)
> {
> instance.WaitForExit(3000);
>         instance.CloseMainWindow();
> }
> }
> I also set FileName in StartInfo to "c:\x\myApp.mdb".
> This code doesn't work in a similiar ASP.NET Application I wrote.
> I get an error - Can't find the filename!
> Why?
> Folke
>
> ---
> Posted using Wimdows.net Newsgroups - http://www.wimdows.net/newsgroups/
Quantcast