locked
Unable to create new database tables using VWD 2010 RRS feed

  • 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.

    Wednesday, October 20, 2010 10:04 AM

Answers

  • 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.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, October 25, 2010 4:29 AM

All replies

  • 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.

     

    Wednesday, October 20, 2010 10:56 AM
  • 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.

     

    Wednesday, October 20, 2010 11:10 AM
  • User-2109039660 posted

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

    Thursday, October 21, 2010 12:57 PM
  • 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.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, October 25, 2010 4:29 AM
  • User-2109039660 posted

    Thanks David Smile

    Tuesday, October 26, 2010 1:04 PM