Editing backend file

G

Guest

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
 
J

Jeff Boyce

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>
 
G

Guest

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

CEV


Jeff Boyce said:
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>
 
G

Guest

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
 
J

Joan Wild

Correct.

--
Joan Wild
Microsoft Access MVP
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
 
Top