Unable to create new database tables using VWD 2010

Question

User-2109039660 posted

 Hi,

hopefully this will be a simple question to answer. I have an ASP.net security database which is normally ASPNetDB.MDF however I have created the same database structure in MS Access. All works great. However, I need to add a couple of other tables but I can't find how to do that in VWD. I'm pretty sure I was able to when the first database I created was an MDF file but not in MS Access.

 

Cheers Rob.

Answer 1

User-1528094326 posted

Fire up Visual Web Developer, click on View -> Server Explorer

Right click Data Connections -> Add Connection

click the Change... button next to Data Source: and select Microsoft Access Database File, and hit OK.

Specify the location of the name, and any login information you need. Hit the Test COnnection button to make sure it succeeds then hit ok.

Now in the Server Explorer under Data COnnections you will notice your access file listed there, you may now expand it and add tables or anything else you need to do.

 

Answer 2

User-2109039660 posted

In my website I have the Database Explorer open and I can see the tables listed with aspnet_Aplications, profiles,membership, roles users etc

That was always there, but I can't add new tables there is no way to add them. If I right click the Tables icon all I get is new Query, refresh and properties. When I right-click an existing table I can retrieve the data.

Like I said, this did work when it was an MDF file I'm pretty sure of that, now it's an MDB file (same structure) I can't add a table. I can only do it in MSAccess itself, but I dont have the application.

 

Answer 3

User-2109039660 posted

I'm assuming that this can't be done in VWD 2010 

Answer 4

User1716267170 posted

I tested it and got the same result. Thus, I think this function doesn't be supported in VS2010 for now. But after some mins' research, I couldn't find any official document referring this. If there's, I'll let you know and post it here. Thanks.

Answer 5

User-2109039660 posted

Thanks David