Access or SQL

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
 
M

Michael Nemtsev

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
 
G

Guest

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
 
K

Kevin Spencer

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top