473,387 Members | 1,789 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

How to create access database backup

Please help me regarding this,

I'm new to access,
can any one tell me
1. how to create a backup as well as
2.how to connect to server

I have already created a database but, i don't know how to connect existing database to server.
Dec 18 '07 #1
1 1914
Hi,

Not sure about access - server connections, but you might be able to use File/Get External Data/Link tables to find the server data, if that's what you want.

As far as a backup, i only know of two ways.

1. Just take a copy of the database and put it on a flash drive
or
2. Create append queries to copy you data to a different database
Dec 18 '07 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: Allcomp | last post by:
Hello, I try to make a backup of a access database. To make it, I make a Filecopy, but some of my custommers have a problem : They work at 2 or 3 on the database, but when a user want to make a...
0
by: Wolfgang Reissenberger | last post by:
I am trying to create a database from a backup. setup: - windows xp professional (german) - db2 version 8.1.6 when I try to create a database from the control center, it fails with...
3
by: MLH | last post by:
I'm developing an app that I'd like to backup each time I open it for modifications. Is it too late to do so after opening the file with Access? Here's what I've been trying... Trevor Best posted...
70
by: Neil Ginsberg | last post by:
Does anyone know if a new version of Access is due to come out anytime soon? Thanks, Neil
9
by: fishbaugher | last post by:
I have encountered some interesting crashes lately (Access97). Here is the symptom (after several days of different kinds of rebuilds including import and LoadFromText, all resulting in databases...
9
by: khan | last post by:
can any one help me how to create an automatic backup of ms access database. Actually I want it to be done either by just clicking on a button or automatally make a backup at 6pm every day. plz help
2
by: Auddog | last post by:
Hello all, I'm fairly new to access database(s), but I work a lot with mysql. I was wondering if there is a script file out there that I can get a hold of that will create a dump file. I need...
1
by: learning_codes | last post by:
Hi , I'm wondering if there is a way for me to export some tables including data and structure from old database to a new database and then save as new database name. I try to create a marco...
2
by: Chris Gilpin | last post by:
Hey everybody. While running a Query, Access crashed (The 'Send Error Report' window came up) I clicked the option to have access repair and reopen my database. Now in the database folder, I...
9
by: javedsai | last post by:
Hi, I need to build a functionality which can take backup of my database periodically, i.e. admin must able to set the timer in how many days he wants to run database backup. For example, If admin...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.