Accessing Database design mode
in [Tables]
|
Prev: Allen Browne’s Name table design
Next: Modify Northwind
From: luv2bike2 on 21 May 2010 17:40 There is an DB that was create well before my time at my job and I have very little experience with Access and need some help here. Access 2003, XP SP3. The first issue: I need to get into the Form Design page of this particular DB the 2 ways i know how to get into the Form Design or any other design mode is 1) have the DB open and on the main page of the DB you can right click on an open space and than choose Form Design and go about doing what you need to do. However I can not do that in this one particular DB -- i right click in an open area on the main page and nothing happens. 2 i minimize the main page of the one that i can get into the design mode i can see the database design box that has the Objects (tables, queries, forms, etc) on the left side and on the right side is where you can choose the forms (frm_Reports, fr,_SelectDocument, etc.) but on the one that i can not right click this box is not present and i can not get into the design mode. 3) if i click on Tools and database utilities and than click on Switchboard Manager, i get a message saying that "The Switchboard Manager was unable to find a valid switchboard in this database. Would you like to create one?" Of course I don't want to mess anything up, especailly since the DB is working for the people that go into it everyday. There are 2 users that only need to go into it once in a while to do a search and when they do, they get " ' \\....\....mdb' is not valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides. OK" Any help would be greatly appreciated. Thanks,
From: Steve on 21 May 2010 19:11 Hold the Shift Key down when you open the database and you should have no problem getting into design mode. Steve santus(a)penn.com "luv2bike2" <luv2bike2(a)discussions.microsoft.com> wrote in message news:2B2527AC-99B6-4257-9364-CECCB6C6E462(a)microsoft.com... > There is an DB that was create well before my time at my job and I have > very > little experience with Access and need some help here. > > Access 2003, XP SP3. > > The first issue: > I need to get into the Form Design page of this particular DB the 2 ways i > know how to get into the Form Design or any other design mode is > 1) have the DB open and on the main page of the DB you can right click on > an > open space and than choose Form Design and go about doing what you need to > do. However I can not do that in this one particular DB -- i right click > in > an open area on the main page and nothing happens. > > 2 i minimize the main page of the one that i can get into the design mode > i > can see the database design box that has the Objects (tables, queries, > forms, > etc) on the left side and on the right side is where you can choose the > forms > (frm_Reports, fr,_SelectDocument, etc.) but on the one that i can not > right > click this box is not present and i can not get into the design mode. > > 3) if i click on Tools and database utilities and than click on > Switchboard > Manager, i get a message saying that "The Switchboard Manager was unable > to > find a valid switchboard in this database. Would you like to create one?" > Of course I don't want to mess anything up, especailly since the DB is > working for the people that go into it everyday. There are 2 users that > only > need to go into it once in a while to do a search and when they do, they > get > > " ' \\....\....mdb' is not valid path. Make sure that the path name is > spelled correctly and that you are connected to the server on which the > file > resides. > > OK" > > Any help would be greatly appreciated. > > Thanks, >
From: Dan on 22 May 2010 22:30 Also if security and management allows, create a backup and try your alterations on the backup. If you break it, no big deal, the one in production is still running. Never work on the one in production if you can help it. Good Luck Dan "Steve" wrote: > Hold the Shift Key down when you open the database and you should have no > problem getting into design mode. > > Steve > santus(a)penn.com > > > "luv2bike2" <luv2bike2(a)discussions.microsoft.com> wrote in message > news:2B2527AC-99B6-4257-9364-CECCB6C6E462(a)microsoft.com... > > There is an DB that was create well before my time at my job and I have > > very > > little experience with Access and need some help here. > > > > Access 2003, XP SP3. > > > > The first issue: > > I need to get into the Form Design page of this particular DB the 2 ways i > > know how to get into the Form Design or any other design mode is > > 1) have the DB open and on the main page of the DB you can right click on > > an > > open space and than choose Form Design and go about doing what you need to > > do. However I can not do that in this one particular DB -- i right click > > in > > an open area on the main page and nothing happens. > > > > 2 i minimize the main page of the one that i can get into the design mode > > i > > can see the database design box that has the Objects (tables, queries, > > forms, > > etc) on the left side and on the right side is where you can choose the > > forms > > (frm_Reports, fr,_SelectDocument, etc.) but on the one that i can not > > right > > click this box is not present and i can not get into the design mode. > > > > 3) if i click on Tools and database utilities and than click on > > Switchboard > > Manager, i get a message saying that "The Switchboard Manager was unable > > to > > find a valid switchboard in this database. Would you like to create one?" > > Of course I don't want to mess anything up, especailly since the DB is > > working for the people that go into it everyday. There are 2 users that > > only > > need to go into it once in a while to do a search and when they do, they > > get > > > > " ' \\....\....mdb' is not valid path. Make sure that the path name is > > spelled correctly and that you are connected to the server on which the > > file > > resides. > > > > OK" > > > > Any help would be greatly appreciated. > > > > Thanks, > > > > > . >
From: luv2bike2 on 24 May 2010 12:12 Thanks for your suggestion. I was able to get to the design mode. Greatly appreciated! Robin "Steve" wrote: > Hold the Shift Key down when you open the database and you should have no > problem getting into design mode. > > Steve > santus(a)penn.com > > > "luv2bike2" <luv2bike2(a)discussions.microsoft.com> wrote in message > news:2B2527AC-99B6-4257-9364-CECCB6C6E462(a)microsoft.com... > > There is an DB that was create well before my time at my job and I have > > very > > little experience with Access and need some help here. > > > > Access 2003, XP SP3. > > > > The first issue: > > I need to get into the Form Design page of this particular DB the 2 ways i > > know how to get into the Form Design or any other design mode is > > 1) have the DB open and on the main page of the DB you can right click on > > an > > open space and than choose Form Design and go about doing what you need to > > do. However I can not do that in this one particular DB -- i right click > > in > > an open area on the main page and nothing happens. > > > > 2 i minimize the main page of the one that i can get into the design mode > > i > > can see the database design box that has the Objects (tables, queries, > > forms, > > etc) on the left side and on the right side is where you can choose the > > forms > > (frm_Reports, fr,_SelectDocument, etc.) but on the one that i can not > > right > > click this box is not present and i can not get into the design mode. > > > > 3) if i click on Tools and database utilities and than click on > > Switchboard > > Manager, i get a message saying that "The Switchboard Manager was unable > > to > > find a valid switchboard in this database. Would you like to create one?" > > Of course I don't want to mess anything up, especailly since the DB is > > working for the people that go into it everyday. There are 2 users that > > only > > need to go into it once in a while to do a search and when they do, they > > get > > > > " ' \\....\....mdb' is not valid path. Make sure that the path name is > > spelled correctly and that you are connected to the server on which the > > file > > resides. > > > > OK" > > > > Any help would be greatly appreciated. > > > > Thanks, > > > > > . >
From: luv2bike2 on 24 May 2010 12:13
Thank you ! I did make a backup copy of it and will work off of that one. Robin "Dan" wrote: > Also if security and management allows, create a backup and try your > alterations on the backup. If you break it, no big deal, the one in > production is still running. Never work on the one in production if you can > help it. > > Good Luck > > Dan > > > "Steve" wrote: > > > Hold the Shift Key down when you open the database and you should have no > > problem getting into design mode. > > > > Steve > > santus(a)penn.com > > > > > > "luv2bike2" <luv2bike2(a)discussions.microsoft.com> wrote in message > > news:2B2527AC-99B6-4257-9364-CECCB6C6E462(a)microsoft.com... > > > There is an DB that was create well before my time at my job and I have > > > very > > > little experience with Access and need some help here. > > > > > > Access 2003, XP SP3. > > > > > > The first issue: > > > I need to get into the Form Design page of this particular DB the 2 ways i > > > know how to get into the Form Design or any other design mode is > > > 1) have the DB open and on the main page of the DB you can right click on > > > an > > > open space and than choose Form Design and go about doing what you need to > > > do. However I can not do that in this one particular DB -- i right click > > > in > > > an open area on the main page and nothing happens. > > > > > > 2 i minimize the main page of the one that i can get into the design mode > > > i > > > can see the database design box that has the Objects (tables, queries, > > > forms, > > > etc) on the left side and on the right side is where you can choose the > > > forms > > > (frm_Reports, fr,_SelectDocument, etc.) but on the one that i can not > > > right > > > click this box is not present and i can not get into the design mode. > > > > > > 3) if i click on Tools and database utilities and than click on > > > Switchboard > > > Manager, i get a message saying that "The Switchboard Manager was unable > > > to > > > find a valid switchboard in this database. Would you like to create one?" > > > Of course I don't want to mess anything up, especailly since the DB is > > > working for the people that go into it everyday. There are 2 users that > > > only > > > need to go into it once in a while to do a search and when they do, they > > > get > > > > > > " ' \\....\....mdb' is not valid path. Make sure that the path name is > > > spelled correctly and that you are connected to the server on which the > > > file > > > resides. > > > > > > OK" > > > > > > Any help would be greatly appreciated. > > > > > > Thanks, > > > > > > > > > . > > |