By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,961 Members | 1,301 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,961 IT Pros & Developers. It's quick & easy.

Some features not installed A2K, will any CD work to add same?

P: n/a
Hello
The person responsible for installing software at work believes in
installing the bare minimum., which does not include the option to
split a data base into a front and back end.
So, rather than "beg" will any CD work to install more features. Or,
will the add features look for the original CD only. Office 2000
installed and I would use my copy of the same program.
Thanks
Nov 13 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
On Wed, 08 Sep 2004 00:11:47 GMT, Ralph2 <no*******@hotmail.com>
wrote:

Using yours can cause problems in the long run, e.g. when installing a
new service pack. Assuming you used yours to install at home, it is
also illegal.
The IT department is responsible for providing you with the needed
software. Explore that avenue first. If uncooperative, escalate to
your manager.

-Tom.

Hello
The person responsible for installing software at work believes in
installing the bare minimum., which does not include the option to
split a data base into a front and back end.
So, rather than "beg" will any CD work to install more features. Or,
will the add features look for the original CD only. Office 2000
installed and I would use my copy of the same program.
Thanks


Nov 13 '05 #2

P: n/a
On Wed, 08 Sep 2004 00:11:47 GMT, Ralph2 <no*******@hotmail.com> wrote:
Hello
The person responsible for installing software at work believes in
installing the bare minimum., which does not include the option to
split a data base into a front and back end.
So, rather than "beg" will any CD work to install more features. Or,
will the add features look for the original CD only. Office 2000
installed and I would use my copy of the same program.
Thanks


As Tom suggested it would be inadvisable to use your own CD to install missing features, however if all you want to do
is split your db then the wizards are not really required as it is trivially easy to do the split manually.

1. Take a backup copy of your db before you start (for safety)
2. Make a copy of your database so you have 2 identical files.
3. Rename the copy to the name you want for your datafile (MyDbData.mdb)
4. Open this file and delete all objects except the tables (delete all queries, forms, reports, macros, modules etc)
5. Open your original file (front end) and delete all the tables. leave all other objects as they are.
6. Right click inside the tables section of the database window and select Link Tables ...
7. Browse to the location of your new datafile and select it.
8. Select All tables from the list that appears and click OK

The tables will be linked and you now have a split database.
Wayne Gillespie
Gosford NSW Australia
Nov 13 '05 #3

P: n/a
On Wed, 08 Sep 2004 02:24:40 GMT, Wayne Gillespie
<be*****@NObestfitsoftwareSPAM.com.au> wrote:
On Wed, 08 Sep 2004 00:11:47 GMT, Ralph2 <no*******@hotmail.com> wrote:
Hello
The person responsible for installing software at work believes in
installing the bare minimum., which does not include the option to
split a data base into a front and back end.
So, rather than "beg" will any CD work to install more features. Or,
will the add features look for the original CD only. Office 2000
installed and I would use my copy of the same program.
Thanks


As Tom suggested it would be inadvisable to use your own CD to install missing features, however if all you want to do
is split your db then the wizards are not really required as it is trivially easy to do the split manually.

1. Take a backup copy of your db before you start (for safety)
2. Make a copy of your database so you have 2 identical files.
3. Rename the copy to the name you want for your datafile (MyDbData.mdb)
4. Open this file and delete all objects except the tables (delete all queries, forms, reports, macros, modules etc)
5. Open your original file (front end) and delete all the tables. leave all other objects as they are.
6. Right click inside the tables section of the database window and select Link Tables ...
7. Browse to the location of your new datafile and select it.
8. Select All tables from the list that appears and click OK

The tables will be linked and you now have a split database.
Wayne Gillespie
Gosford NSW Australia


Will try this but... suspect it will not work. But, your method links
from inside the tables, I never tried it that way.
Let me backup..At home I split my database. Then, took my split copy
to work, placed the back end on our server and the front end on the
local computer. But I get an error message about the link to my back
end not being valid. (it seems to default to the default location of
the files i.e. \\my documents\\) Anyway trying to link my tables is
where I run into the problem with "that" feature not being installed.
Thus the desire to have the split data base feature, my reasoning is
that because I can not split, I can not update links either.

Nov 13 '05 #4

P: n/a
On Wed, 08 Sep 2004 03:52:47 GMT, Ralph2 <no*******@hotmail.com>
wrote:

Links can also be updated programmatically. Many commercial-grade
applications do this. Refer to the Connect property and the
RefreshLink method in the help file.

-Tom.

On Wed, 08 Sep 2004 02:24:40 GMT, Wayne Gillespie
<be*****@NObestfitsoftwareSPAM.com.au> wrote:
On Wed, 08 Sep 2004 00:11:47 GMT, Ralph2 <no*******@hotmail.com> wrote:
Hello
The person responsible for installing software at work believes in
installing the bare minimum., which does not include the option to
split a data base into a front and back end.
So, rather than "beg" will any CD work to install more features. Or,
will the add features look for the original CD only. Office 2000
installed and I would use my copy of the same program.
Thanks


As Tom suggested it would be inadvisable to use your own CD to install missing features, however if all you want to do
is split your db then the wizards are not really required as it is trivially easy to do the split manually.

1. Take a backup copy of your db before you start (for safety)
2. Make a copy of your database so you have 2 identical files.
3. Rename the copy to the name you want for your datafile (MyDbData.mdb)
4. Open this file and delete all objects except the tables (delete all queries, forms, reports, macros, modules etc)
5. Open your original file (front end) and delete all the tables. leave all other objects as they are.
6. Right click inside the tables section of the database window and select Link Tables ...
7. Browse to the location of your new datafile and select it.
8. Select All tables from the list that appears and click OK

The tables will be linked and you now have a split database.
Wayne Gillespie
Gosford NSW Australia


Will try this but... suspect it will not work. But, your method links
from inside the tables, I never tried it that way.
Let me backup..At home I split my database. Then, took my split copy
to work, placed the back end on our server and the front end on the
local computer. But I get an error message about the link to my back
end not being valid. (it seems to default to the default location of
the files i.e. \\my documents\\) Anyway trying to link my tables is
where I run into the problem with "that" feature not being installed.
Thus the desire to have the split data base feature, my reasoning is
that because I can not split, I can not update links either.


Nov 13 '05 #5

P: n/a
Thanks to all, linking indeed does work as described by others. Wish I
knew this when I first made my database...

On Wed, 08 Sep 2004 00:11:47 GMT, Ralph2 <no*******@hotmail.com>
wrote:
Hello
The person responsible for installing software at work believes in
installing the bare minimum., which does not include the option to
split a data base into a front and back end.
So, rather than "beg" will any CD work to install more features. Or,
will the add features look for the original CD only. Office 2000
installed and I would use my copy of the same program.
Thanks


Nov 13 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.