switchboard

[weazer via AccessMonster.com]

After you split a database how do you modify the switchboard and make it the
current switchboard for the front and back end?

Also, I tried to edit it using a copy of my front and back end and it looked
liked it was working and then I copied it to my working front and back end
and all of a sudden It was running on Acess 2003.

I am currently using Access 1997 and have 2003 loaded on my machine. All the
changes that I made were to DB's in 97. How can I fix this - It will not let
me edit it saying it was written in an earlier version of Access.

Thanks again.

 

[Douglas J. Steele]

I'm not sure what you mean by "make it the current switchboard for the front
and back end"

Access 2003 cannot make design changes to a file in Access 97 format
(although it can make data changes). You either need to use Access 97 or you
can convert to Access 2003, make the changes, then convert back to Access 97
(note that this really isn't recommended as a normal course of action)

To ensure that your front-end is pointing to the correct back-end, use the
Linked Table Manager, or put code like
http://www.mvps.org/access/tables/tbl0009.htm at "The Access Web" into your
front-end.

 

[weazer via AccessMonster.com]

Sorry for not being clear. The front end is on everyones c drive and the back
end is on the network. The path was set up using network places. I am using
the switchboard add-in for my menu.

My question was how do I edit the switchboard?

How would I go about converting to Acess 2003 and then back again to 97.

I guess you would use the pop up when you open the database - either to open
it up or convert. I am still confused on how to convert back to 97.

Thanks again for your help.

I'm not sure what you mean by "make it the current switchboard for the front
and back end"

Access 2003 cannot make design changes to a file in Access 97 format
(although it can make data changes). You either need to use Access 97 or you
can convert to Access 2003, make the changes, then convert back to Access 97
(note that this really isn't recommended as a normal course of action)

To ensure that your front-end is pointing to the correct back-end, use the
Linked Table Manager, or put code like
http://www.mvps.org/access/tables/tbl0009.htm at "The Access Web" into your
front-end.

After you split a database how do you modify the switchboard and make it
the

[quoted text clipped - 12 lines]

Thanks again.

 

[Douglas J. Steele]

You can convert back under Tools | Database Utilities | Convert Database

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

Sorry for not being clear. The front end is on everyones c drive and the
back
end is on the network. The path was set up using network places. I am
using
the switchboard add-in for my menu.

My question was how do I edit the switchboard?

How would I go about converting to Acess 2003 and then back again to 97.

I guess you would use the pop up when you open the database - either to
open
it up or convert. I am still confused on how to convert back to 97.

Thanks again for your help.

I'm not sure what you mean by "make it the current switchboard for the
front
and back end"

Access 2003 cannot make design changes to a file in Access 97 format
(although it can make data changes). You either need to use Access 97 or
you
can convert to Access 2003, make the changes, then convert back to Access
97
(note that this really isn't recommended as a normal course of action)

To ensure that your front-end is pointing to the correct back-end, use the
Linked Table Manager, or put code like
http://www.mvps.org/access/tables/tbl0009.htm at "The Access Web" into
your
front-end.

After you split a database how do you modify the switchboard and make it
the

[quoted text clipped - 12 lines]

Thanks again.