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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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:
|
#6
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Back End Tables | PeterM | General Discussion | 3 | December 6th, 2005 05:21 AM |
Is it possible to split an MDE file? | Douglas J. Steele | New Users | 1 | November 13th, 2005 01: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 18th, 2005 11:36 PM |
have split a table with Ctrl/Enter - need to get it back together. | DebbieD | Tables | 1 | January 6th, 2005 06:41 PM |