Editing backend file

Can I go into a backend file that contains the tables and add fields to
these tables and even create more tables while the database is being used by
others? I am hoping I can otherwise the only time I can change or add
anything is during off hours.

Thanks,

CEV

Another approach would be to try out your changes in a test copy. Make a
copy of the back-end when nobody's got it open.

Make your changes to your copy. Point your front-end at the test copy and
test.

If everything works, wait 'til everyone's out (or chase them out for 60
seconds) and swap your new version for the old. NOTE: if you make changes
to your test front-end, to accommodate the changes to the test back-end,
you'll need to replace the back-end AND a copy of the front-end on each
user's PC.

Regards

Jeff Boyce
MS Office/Access MVP

CEV wrote in message ...
Can I go into a backend file that contains the tables and add fields to
these tables and even create more tables while the database is being used
by others? I am hoping I can otherwise the only time I can change or add
anything is during off hours.

Thanks,

CEV

Thanks Jeff, that's what I'll do.

CEV


"Jeff Boyce" wrote in message
...
Another approach would be to try out your changes in a test copy. Make a
copy of the back-end when nobody's got it open.

Make your changes to your copy. Point your front-end at the test copy and
test.

If everything works, wait 'til everyone's out (or chase them out for 60
seconds) and swap your new version for the old. NOTE: if you make
changes to your test front-end, to accommodate the changes to the test
back-end, you'll need to replace the back-end AND a copy of the front-end
on each user's PC.

Regards

Jeff Boyce
MS Office/Access MVP

CEV wrote in message ...
Can I go into a backend file that contains the tables and add fields to
these tables and even create more tables while the database is being used
by others? I am hoping I can otherwise the only time I can change or add
anything is during off hours.

Thanks,

CEV

I got to thinking about this more and as I make changes to my copy of the
backend, people are adding data to these table in the original. When I put
my copy back where it should be, any new data they entered will no longer be
there correct?

Thanks,

Chad


"Jeff Boyce" wrote in message
...
Another approach would be to try out your changes in a test copy. Make a
copy of the back-end when nobody's got it open.

Make your changes to your copy. Point your front-end at the test copy and
test.

If everything works, wait 'til everyone's out (or chase them out for 60
seconds) and swap your new version for the old. NOTE: if you make
changes to your test front-end, to accommodate the changes to the test
back-end, you'll need to replace the back-end AND a copy of the front-end
on each user's PC.

Regards

Jeff Boyce
MS Office/Access MVP

CEV wrote in message ...
Can I go into a backend file that contains the tables and add fields to
these tables and even create more tables while the database is being used
by others? I am hoping I can otherwise the only time I can change or add
anything is during off hours.

Thanks,

CEV

Correct.

--
Joan Wild
Microsoft Access MVP

CEV wrote:
I got to thinking about this more and as I make changes to my copy of
the backend, people are adding data to these table in the original.
When I put my copy back where it should be, any new data they entered
will no longer be there correct?

Thanks,

Chad


"Jeff Boyce" wrote in message
...
Another approach would be to try out your changes in a test copy. Make a
copy of the back-end when nobody's got it open.

Make your changes to your copy. Point your front-end at the test
copy and test.

If everything works, wait 'til everyone's out (or chase them out for
60 seconds) and swap your new version for the old. NOTE: if you
make changes to your test front-end, to accommodate the changes to
the test back-end, you'll need to replace the back-end AND a copy of
the front-end on each user's PC.

Regards

Jeff Boyce
MS Office/Access MVP

CEV wrote in message ...
Can I go into a backend file that contains the tables and add
fields to these tables and even create more tables while the
database is being used by others? I am hoping I can otherwise the
only time I can change or add anything is during off hours.

Thanks,

CEV