PC Review


Reply
Thread Tools Rate Thread

Accessing Database design mode

 
 
luv2bike2
Guest
Posts: n/a
 
      21st May 2010
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,

 
Reply With Quote
 
 
 
 
Steve
Guest
Posts: n/a
 
      22nd May 2010
Hold the Shift Key down when you open the database and you should have no
problem getting into design mode.

Steve
(E-Mail Removed)


"luv2bike2" <(E-Mail Removed)> wrote in message
news:2B2527AC-99B6-4257-9364-(E-Mail Removed)...
> 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,
>



 
Reply With Quote
 
Dan
Guest
Posts: n/a
 
      23rd May 2010
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
> (E-Mail Removed)
>
>
> "luv2bike2" <(E-Mail Removed)> wrote in message
> news:2B2527AC-99B6-4257-9364-(E-Mail Removed)...
> > 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,
> >

>
>
> .
>

 
Reply With Quote
 
luv2bike2
Guest
Posts: n/a
 
      24th May 2010
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
> (E-Mail Removed)
>
>
> "luv2bike2" <(E-Mail Removed)> wrote in message
> news:2B2527AC-99B6-4257-9364-(E-Mail Removed)...
> > 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,
> >

>
>
> .
>

 
Reply With Quote
 
luv2bike2
Guest
Posts: n/a
 
      24th May 2010

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
> > (E-Mail Removed)
> >
> >
> > "luv2bike2" <(E-Mail Removed)> wrote in message
> > news:2B2527AC-99B6-4257-9364-(E-Mail Removed)...
> > > 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,
> > >

> >
> >
> > .
> >

 
Reply With Quote
 
luv2bike2
Guest
Posts: n/a
 
      27th May 2010
I have a couple more questions/issues that could be related to each other:

I can log in to another computer as myself, open up the DB have the design
mode there (w/o holding down the shift key). i have compared the Workgroup
Administrator settings on both computers (one that is working correctly and
the one that is not) to make sure that the workgroup settings are the same
and they are.
What would be causing this issue? I am a novice in Access and i know bits
and pieces, there must be something else that i am not seeing. Also the
drive mappings are identical on both computers. The comparing I did are on
two computers that are located in my office.

The database pulls all its information from that db and no other db.

The next issue is going to be hard to explain so I will try my best to
explain it:
Just to clarify, this next issue could be related to the above because it is
only happening on the same computers (there are 4 that I know of) that has
this issue.
There are 7 other people who use this DB and are not having any issues.

Once the db is open, the user clicks on a button, lets call it "A", once the
"A" window appears, they click on a Button, lets call it "B", Once the "B"
window appears, they click on "C" which there they would see on the right
side 2 boxes that one will have a list of part numbers and the other will
have a list of vendors. This is normal on a working computer. The lists are
not showing up on the computers that are having the issue in the above
section.

What I am thinking is that there has be a setting on the computers that is
not set correctly, but I don't know.

I sure hope someone can help me out on this. I was not the one who created
this DB and the person who did has been long gone from the company. If
anything needs to be clairfied, please ask me and i will find out what i can.

Thanks so much!




"Steve" wrote:

> Hold the Shift Key down when you open the database and you should have no
> problem getting into design mode.
>
> Steve
> (E-Mail Removed)
>
>
> "luv2bike2" <(E-Mail Removed)> wrote in message
> news:2B2527AC-99B6-4257-9364-(E-Mail Removed)...
> > 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,
> >

>
>
> .
>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Prevent users from accessing report design mode Mommybear Microsoft Access Reports 1 12th May 2010 03:46 PM
Problem accessing query in the design mode MS access shieldguy Microsoft Access 0 7th Nov 2006 02:38 PM
Accessing Master Page Custom Properties in Design Mode =?Utf-8?B?U3VyZXNo?= Microsoft ASP .NET 4 21st Oct 2006 06:37 AM
Preventing Users accessing in design mode =?Utf-8?B?V2F5bmU=?= Microsoft Access Security 2 14th Oct 2004 03:51 PM
Accessing Web.Config from design mode in VS.NET Patrik Löwendahl Microsoft ASP .NET 2 8th Apr 2004 06:30 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:18 PM.