A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Accessing Database design mode



 
 
Thread Tools Display Modes
  #1  
Old May 21st, 2010, 10:40 PM posted to microsoft.public.access.tablesdbdesign
luv2bike2
external usenet poster
 
Posts: 45
Default Accessing Database design mode

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,

Ads
  #2  
Old May 22nd, 2010, 12:11 AM posted to microsoft.public.access.tablesdbdesign
Steve[_77_]
external usenet poster
 
Posts: 1,017
Default Accessing Database design mode

Hold the Shift Key down when you open the database and you should have no
problem getting into design mode.

Steve



"luv2bike2" wrote in message
...
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,



  #3  
Old May 23rd, 2010, 03:30 AM posted to microsoft.public.access.tablesdbdesign
dan
external usenet poster
 
Posts: 1,408
Default Accessing Database design mode

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



"luv2bike2" wrote in message
...
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,



.

  #4  
Old May 24th, 2010, 05:12 PM posted to microsoft.public.access.tablesdbdesign
luv2bike2
external usenet poster
 
Posts: 45
Default Accessing Database design mode

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



"luv2bike2" wrote in message
...
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,



.

  #5  
Old May 24th, 2010, 05:13 PM posted to microsoft.public.access.tablesdbdesign
luv2bike2
external usenet poster
 
Posts: 45
Default Accessing Database design mode


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



"luv2bike2" wrote in message
...
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,



.

  #6  
Old May 27th, 2010, 09:12 PM posted to microsoft.public.access.tablesdbdesign
luv2bike2
external usenet poster
 
Posts: 45
Default Accessing Database design mode

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



"luv2bike2" wrote in message
...
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,



.

 




Thread Tools
Display Modes

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

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 06:37 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 OfficeFrustration.
The comments are property of their posters.