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 » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Back up a Split Database's Backend



 
 
Thread Tools Display Modes
  #1  
Old February 20th, 2006, 03:41 PM posted to microsoft.public.access.gettingstarted
external usenet poster
 
Posts: n/a
Default Back up a Split Database's Backend

I did a little searching in the groups but have been unable to find this
information. If someone could offer advice I would really appreciate it.

I have split the database so that multiple people can use it and so I can
continue to develop the front end. I want a button on my swithcboard to
back up the database . I have no problem with that, a simple macro
accomplishes this. My problem is I need away to backup the actual linked
tables int the backend too.

I played around with open database command in macros but I don't understand
what's going on. Any thougts or ideas on the best way to accomplish this.

TIA


  #2  
Old February 20th, 2006, 03:45 PM posted to microsoft.public.access.gettingstarted
external usenet poster
 
Posts: n/a
Default Back up a Split Database's Backend

All you have to do to backup the back-end database is to copy the MDB file.
However, you need to ensure that you do this when no one is using the
back-end database. Otherwise, you run the risk of your backup being
inconsistent, and hence of little use to you.

You can tell whether anyone's using the back-end by looking for the locking
file. If anyone's using the back-end database, the locking file will have
the same name as the database itself, but with an extension of .LDB, rather
than .MDB, and will be in the same folder as the back-end MDB file.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"scs" wrote in message
...
I did a little searching in the groups but have been unable to find this
information. If someone could offer advice I would really appreciate it.

I have split the database so that multiple people can use it and so I can
continue to develop the front end. I want a button on my swithcboard to
back up the database . I have no problem with that, a simple macro
accomplishes this. My problem is I need away to backup the actual linked
tables int the backend too.

I played around with open database command in macros but I don't

understand
what's going on. Any thougts or ideas on the best way to accomplish this.

TIA




  #3  
Old February 20th, 2006, 05:06 PM posted to microsoft.public.access.gettingstarted
external usenet poster
 
Posts: n/a
Default Back up a Split Database's Backend

Thank you. I don't anticipate any more than two people using this at a
time. It's really going to be used primarily by one person. I mainly just
want them to be able to use it while I'm working on the front-end. However,
it will probably remain split in the end and used by two folks occasionally
at the same time.

I'm looking for a way that a user could enter the front-end and, through a
very user friendly interface, backup the back-end. If I'm understanding you
correctly, this would not be possible because the backend would be in use at
that time by that user.

I was hoping the user could make a quick backup of the data from within
Access before making a bunch of changes. I guess I'll have to develop some
other means outside of Access. Is this correct?

Thanks again.

"Douglas J Steele" wrote in message
...
All you have to do to backup the back-end database is to copy the MDB
file.
However, you need to ensure that you do this when no one is using the
back-end database. Otherwise, you run the risk of your backup being
inconsistent, and hence of little use to you.

You can tell whether anyone's using the back-end by looking for the
locking
file. If anyone's using the back-end database, the locking file will have
the same name as the database itself, but with an extension of .LDB,
rather
than .MDB, and will be in the same folder as the back-end MDB file.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"scs" wrote in message
...
I did a little searching in the groups but have been unable to find this
information. If someone could offer advice I would really appreciate it.

I have split the database so that multiple people can use it and so I can
continue to develop the front end. I want a button on my swithcboard to
back up the database . I have no problem with that, a simple macro
accomplishes this. My problem is I need away to backup the actual linked
tables int the backend too.

I played around with open database command in macros but I don't

understand
what's going on. Any thougts or ideas on the best way to accomplish
this.

TIA






  #4  
Old February 20th, 2006, 05:15 PM posted to microsoft.public.access.gettingstarted
external usenet poster
 
Posts: n/a
Default Back up a Split Database's Backend

scs wrote:
Thank you. I don't anticipate any more than two people using this at
a time. It's really going to be used primarily by one person. I
mainly just want them to be able to use it while I'm working on the
front-end. However, it will probably remain split in the end and
used by two folks occasionally at the same time.

I'm looking for a way that a user could enter the front-end and,
through a very user friendly interface, backup the back-end. If I'm
understanding you correctly, this would not be possible because the
backend would be in use at that time by that user.

I was hoping the user could make a quick backup of the data from
within Access before making a bunch of changes. I guess I'll have to
develop some other means outside of Access. Is this correct?


If your app is split then you can still do this from the front end providing
that no bound forms or reports are open at the time you do it. Testing for
the existence of the LDB file will let you know if any bound objects are
currently connected to the back end. When it is not there then it would be
safe to copy the file.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com


  #5  
Old February 20th, 2006, 11:34 PM
Bob Miller Bob Miller is offline
Senior Member
 
First recorded activity by OfficeFrustration: May 2005
Posts: 358
Default

I create a Backup database and then use Make Table Queries to create tables in the Backup db of the linked tables in the front end. You can create a macro or code that runs each query from a switchboard or menu bar. I usually open a form that says "Running Backup" before opening the Make Table Queries and close that form after the last Make Table query has been run.
You can probably find some code somwhere that checks to see if the Backend is open before running the Queries.

Quote:
Originally Posted by scs
Thank you. I don't anticipate any more than two people using this at a
time. It's really going to be used primarily by one person. I mainly just
want them to be able to use it while I'm working on the front-end. However,
it will probably remain split in the end and used by two folks occasionally
at the same time.

I'm looking for a way that a user could enter the front-end and, through a
very user friendly interface, backup the back-end. If I'm understanding you
correctly, this would not be possible because the backend would be in use at
that time by that user.

I was hoping the user could make a quick backup of the data from within
Access before making a bunch of changes. I guess I'll have to develop some
other means outside of Access. Is this correct?

Thanks again.
snip
  #6  
Old February 21st, 2006, 01:49 AM posted to microsoft.public.access.gettingstarted
external usenet poster
 
Posts: n/a
Default Back up a Split Database's Backend

Thank you. I undersand what you are saying. If I close all forms in my
frontend the ldb file goes away in the backend directory. Could a macro
close all open forms and somehow copy that backend database somewhere?
Could I do it with VBA? Can you tell me how or point me to more info on the
subject.

Thanks again.

"Rick Brandt" wrote in message
. com...
scs wrote:
Thank you. I don't anticipate any more than two people using this at
a time. It's really going to be used primarily by one person. I
mainly just want them to be able to use it while I'm working on the
front-end. However, it will probably remain split in the end and
used by two folks occasionally at the same time.

I'm looking for a way that a user could enter the front-end and,
through a very user friendly interface, backup the back-end. If I'm
understanding you correctly, this would not be possible because the
backend would be in use at that time by that user.

I was hoping the user could make a quick backup of the data from
within Access before making a bunch of changes. I guess I'll have to
develop some other means outside of Access. Is this correct?


If your app is split then you can still do this from the front end
providing that no bound forms or reports are open at the time you do it.
Testing for the existence of the LDB file will let you know if any bound
objects are currently connected to the back end. When it is not there
then it would be safe to copy the file.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com



  #7  
Old February 21st, 2006, 02:49 AM posted to microsoft.public.access.gettingstarted
external usenet poster
 
Posts: n/a
Default Back up a Split Database's Backend

scs wrote:
Thank you. I undersand what you are saying. If I close all forms in
my frontend the ldb file goes away in the backend directory. Could a
macro close all open forms and somehow copy that backend database
somewhere? Could I do it with VBA? Can you tell me how or point me
to more info on the subject.


You don't have to close all forms, only all forms bound to tables in the back
end. So you could still have a form opened that has a button that performs the
backup. Code in that button could loop through the Reports collection and the
Forms collection (backwards) closing all reports and all forms except for the
one running the code. Then the code can look for the presence of the LDB file.
If not found, make the backup copy. If found you can report that instead (which
would mean someone else might be in the file).

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com


  #8  
Old February 24th, 2006, 05:34 AM posted to microsoft.public.access.gettingstarted
external usenet poster
 
Posts: n/a
Default Back up a Split Database's Backend

Thanks! That's pretty easy and works well.

"Bob Miller" wrote in message
. ..

I create a Backup database and then use Make Table Queries to create
tables in the Backup db of the linked tables in the front end. You can
create a macro or code that runs each query from a switchboard or menu
bar. I usually open a form that says "Running Backup" before opening
the Make Table Queries and close that form after the last Make Table
query has been run.
You can probably find some code somwhere that checks to see if the
Backend is open before running the Queries.

scs Wrote:
Thank you. I don't anticipate any more than two people using this at a
time. It's really going to be used primarily by one person. I mainly
just
want them to be able to use it while I'm working on the front-end.
However,
it will probably remain split in the end and used by two folks
occasionally
at the same time.

I'm looking for a way that a user could enter the front-end and,
through a
very user friendly interface, backup the back-end. If I'm
understanding you
correctly, this would not be possible because the backend would be in
use at
that time by that user.

I was hoping the user could make a quick backup of the data from
within
Access before making a bunch of changes. I guess I'll have to develop
some
other means outside of Access. Is this correct?

Thanks again.
snip



--
Bob Miller



 




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

Similar Threads
Thread Thread Starter Forum Replies Last Post
Back End Tables PeterM General Discussion 3 December 6th, 2005 06:21 AM
Is it possible to split an MDE file? Douglas J. Steele New Users 1 November 13th, 2005 02:30 AM
Update BE Split Databases bondtk General Discussion 4 October 26th, 2005 06:01 PM
Front and Back Don't Align CJ Mailmerge 1 January 19th, 2005 12:36 AM
have split a table with Ctrl/Enter - need to get it back together. DebbieD Tables 1 January 6th, 2005 07:41 PM


All times are GMT +1. The time now is 10:11 AM.


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