Access or SQL

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have some MS Access databases linked to SQL db's.
I need to create a Web Form with Visual Studio 5.0 for useres to enter and
edit data. Would it be better to establish a new connection to the SQL table
from VS Web site or should I create a connection to the MS Access database?

Is there a way to connect the MS Access Form to the new web page?

Suggestions
 
Hello Dan (e-mail address removed),

It depends on your requirements to DB.
If u gonna store several small tables for internal purposes - without any
communication from other machine, then Access is appropriate solution

---
WBR, Michael Nemtsev [.NET/C# MVP].
My blog: http://spaces.live.com/laflour
Team blog: http://devkids.blogspot.com/

"The greatest danger for most of us is not that our aim is too high and we
miss it, but that it is too low and we reach it" (c) Michelangelo

D> I have some MS Access databases linked to SQL db's.
D> I need to create a Web Form with Visual Studio 5.0 for useres to
D> enter and
D> edit data. Would it be better to establish a new connection to the
D> SQL table
D> from VS Web site or should I create a connection to the MS Access
D> database
 
Blue Cross blocks access to Blogs....

From what I'm doing adnd your comment I beleive Access will work.

Any good documentaion or advice on replicating Access Forms in Visual Studio??

Thanks
 
Hi Dan,

You should *definitely* connect directly to the SQL Server. Also, your
Access forms will not work in an ASP.Net web application. You will need to
create web forms to provide your interface.

--
HTH,

Kevin Spencer
Microsoft MVP

Printing Components, Email Components,
FTP Client Classes, Enhanced Data Controls, much more.
DSI PrintManager, Miradyne Component Libraries:
http://www.miradyne.net

Dan @BCBS said:
Blue Cross blocks access to Blogs....

From what I'm doing adnd your comment I beleive Access will work.

Any good documentaion or advice on replicating Access Forms in Visual
Studio??

Thanks



Michael Nemtsev said:
Hello Dan (e-mail address removed),

It depends on your requirements to DB.
If u gonna store several small tables for internal purposes - without any
communication from other machine, then Access is appropriate solution

---
WBR, Michael Nemtsev [.NET/C# MVP].
My blog: http://spaces.live.com/laflour
Team blog: http://devkids.blogspot.com/

"The greatest danger for most of us is not that our aim is too high and
we
miss it, but that it is too low and we reach it" (c) Michelangelo

D> I have some MS Access databases linked to SQL db's.
D> I need to create a Web Form with Visual Studio 5.0 for useres to
D> enter and
D> edit data. Would it be better to establish a new connection to the
D> SQL table
D> from VS Web site or should I create a connection to the MS Access
D> database?
Click to expand...
Click to expand...
 
Back
Top