By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,486 Members | 2,061 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,486 IT Pros & Developers. It's quick & easy.

Can't Backup database

P: n/a
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.

Aug 24 '06 #1
Share this Question
Share on Google+
4 Replies


P: n/a
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

<fs*************@yahoo.comwrote in message
news:11**********************@74g2000cwt.googlegro ups.com...
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.

Aug 24 '06 #2

P: n/a
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:
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

<fs*************@yahoo.comwrote in message
news:11**********************@74g2000cwt.googlegro ups.com...
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.
Aug 24 '06 #3

P: n/a
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
<fs*************@yahoo.comwrote in message
news:11*********************@m73g2000cwd.googlegro ups.com...
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:
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

<fs*************@yahoo.comwrote in message
news:11**********************@74g2000cwt.googlegro ups.com...
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.
>

Aug 24 '06 #4

P: n/a

The Backup database is under Tools - Database Utilities

Aug 25 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.