Connecting Tech Pros Worldwide Forums | Help | Site Map

Can't Backup database

fstenoughsnoopy@yahoo.com
Guest
 
Posts: n/a
#1: Aug 24 '06
I have a database on a server, not split into FE/BE and it has the user
level security set up. I do have one problem. I need to back up the
database. According to Microsoft and other books and links I've read,
the should be a Back Up Database link under the File button at the top
of Access. However, I dont see it anywhere. I tried backing it up using
Windows back up and recovery, but would like something more accessible.
Please let me know if you can help me.


Fred Zuckerman
Guest
 
Posts: n/a
#2: Aug 24 '06

re: Can't Backup database


You can just use the regular "copy" feature in windows, or a DOS batch file.
You should copy the "mdb" file and the "mdw" file.
Fred Zuckerman

<fstenoughsnoopy@yahoo.comwrote in message
news:1156431742.985617.116030@74g2000cwt.googlegro ups.com...
Quote:
I have a database on a server, not split into FE/BE and it has the user
level security set up. I do have one problem. I need to back up the
database. According to Microsoft and other books and links I've read,
the should be a Back Up Database link under the File button at the top
of Access. However, I dont see it anywhere. I tried backing it up using
Windows back up and recovery, but would like something more accessible.
Please let me know if you can help me.
>

fstenoughsnoopy@yahoo.com
Guest
 
Posts: n/a
#3: Aug 24 '06

re: Can't Backup database


I tried, however if the server goes down and i try running that backup,
it says that it needs the server to access the file. i need the copy so
that we can access the info when the server is down or for working on
it at home.

Fred Zuckerman wrote:
Quote:
You can just use the regular "copy" feature in windows, or a DOS batch file.
You should copy the "mdb" file and the "mdw" file.
Fred Zuckerman
>
<fstenoughsnoopy@yahoo.comwrote in message
news:1156431742.985617.116030@74g2000cwt.googlegro ups.com...
Quote:
I have a database on a server, not split into FE/BE and it has the user
level security set up. I do have one problem. I need to back up the
database. According to Microsoft and other books and links I've read,
the should be a Back Up Database link under the File button at the top
of Access. However, I dont see it anywhere. I tried backing it up using
Windows back up and recovery, but would like something more accessible.
Please let me know if you can help me.
Fred Zuckerman
Guest
 
Posts: n/a
#4: Aug 24 '06

re: Can't Backup database


I do it all the time. So there must be something else....
What >exactly< does the error message say?

1. Does your database have all its tables internal, or do you have external
links to other data sources?
2. Since you have user-level security, you are probably using a shortcut to
open the database and the workgroup file. Be sure to review the CmdLine in
the shortcut to confirm that it:
a) references MSACCESS.exe on the local disk
b) references the proper mdb
c) references the proper mdw
3. When you attempt to use your backup copy, then you need a different
shortcut that points to the backup copies.
Good Luck,
Fred Zuckerman


<fstenoughsnoopy@yahoo.comwrote in message
news:1156436420.472769.82760@m73g2000cwd.googlegro ups.com...
Quote:
I tried, however if the server goes down and i try running that backup,
it says that it needs the server to access the file. i need the copy so
that we can access the info when the server is down or for working on
it at home.
>
Fred Zuckerman wrote:
Quote:
You can just use the regular "copy" feature in windows, or a DOS batch
file.
Quote:
Quote:
You should copy the "mdb" file and the "mdw" file.
Fred Zuckerman

<fstenoughsnoopy@yahoo.comwrote in message
news:1156431742.985617.116030@74g2000cwt.googlegro ups.com...
Quote:
I have a database on a server, not split into FE/BE and it has the
user
Quote:
Quote:
Quote:
level security set up. I do have one problem. I need to back up the
database. According to Microsoft and other books and links I've read,
the should be a Back Up Database link under the File button at the top
of Access. However, I dont see it anywhere. I tried backing it up
using
Quote:
Quote:
Quote:
Windows back up and recovery, but would like something more
accessible.
Quote:
Quote:
Quote:
Please let me know if you can help me.
>
>

Rick
Guest
 
Posts: n/a
#5: Aug 25 '06

re: Can't Backup database



The Backup database is under Tools - Database Utilities

Closed Thread