Monday, March 19, 2012

Access vs. MSDE

I understand how msde is more powerfull than assess but is the only way to use MSDE through the web matrix. If I want to update a table or change data how can I open the file and work with it or is this when I buy SQL server. I travel full time and do all my work from my laptop so I do not want to install any server software on it. Or should I just us access and use the upsize wizard to use MSDE.

Adam TaylorCould use a little more info.

It all depends:

Are you developing applications for other people?
Is it for personal/business use, contact management, etc?
What exactly is it that you are trying to accomplish?

Thanks.|||You can get to the tables etc using Access (At least you can with access 2002)

start Access
select the New Project (Existing Data)

Then select the machine (or type it) where the tables are
Supply login details (should be same as you require when using web matrix)

click the drop down to select a database to work on

It should work - does on mine

then you can use all access tools to manipulate the data - plus add tables and stored procedures

Pk

No comments:

Post a Comment