Access app and ASP.NET

  • Thread starter Thread starter folke liden
  • Start date Start date
F

folke liden

I have a MS Access app - myapp.mdb on a server
I want users to be able to select it and run it by clicking on a link. The web app is on another server.
Not sure how to do it.
How can you start and run myapp.mdb from a webpage??
Do they have to download it to their PC? Or is there a way to invoke it "remote"?
Folke
 
You have an Access database, not an Access app. Access itself is the app.
The database (.mdb) is a database. When you open the .mdb, it opens in
Access, which provides its own desktop user interface for working with the
database. When you want to expose a database in a web browser interface, you
write a server-side app (using ASP.Net in this case) that presents the
end-user with an HTML interface, and communicates with the database on the
server. IOW, you don't have the user download the .mdb file.

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
Neither a follower nor a lender be.
 
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
 
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.
 
Well!
Thanks's for your your answer.
It gave me a very clear answer. You´re a stupid guy. Maybe you think I'm a fool. Wrong! In my opinion guys like you shouln't answer at all. You think all people are stupid. Well, a surprise - I-m not! I know what a database is. Question is - Do You? If you´re a consultant you should be more careful about insulting peoples intelligence! Hope you're not working in Sweden, I'll do my outmost to tell bad things about you. DUMFUCK!
 
It gave me a very clear answer. You´re a stupid guy. Maybe you think I'm
a fool. Wrong! In my opinion guys like you shouln't
Click to expand...

I didn't think you were a fool - until I read this response.

Let me quote you:
How can you start and run myapp.mdb from a webpage??
Click to expand...

A web application is entirely different from a desktop executable. That is
what I tried to tell you. I'm here to help people with my knowledge and
experience of 10 years programming, starting with C. I was trying to help
you, not because I get paid for it (I don't), just out of the goodness of my
heart. But I'm through now. Good luck. You're going to need it.

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
Neither a follower nor a lender be.
 
Back
Top