Copying a database

[Guest]

Hi
I was working in a database and needed to try out few things. But I am not supposed to touch the original database. So I wanted to make a local copy of the database on my drive. As there was no such option of save as for the database, I ended up making a replica of it. Now I have found that I could make a copy of it by simply dragging it. Now I have these problem
1) is there any way, I can undo it
2) If I delete the replica on my local folder, will the original data/ database on the network drive remain there
3) Can I change the Design Master to its previous state (there was no design master before I replicated it

Please someone help me
TI
Shilps

 

[Guest]

Hi Shilps

If you have really copied it and the original database is still where it should be and unchanged, it is no problem to delete your copy of the database. They are independant from each other

If you have moved the original database to your local folder - move it back. ;-

I'm sorry, I'm not sure what you mean with design master - never came across something named like this in Access
And didn't saw something in help

Bern

 

[Cheryl Fischer]

If you actually used the Tools|Replication menu to create a Replica (and it
sounds as if you did), you need to tell the individual responsible for this
database (the programmer, your IT manager) what you have done. It is
possible to undo a Replication, but it should be left to the experts.

--

Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX

Hi,
I was working in a database and needed to try out few things. But I am not

supposed to touch the original database. So I wanted to make a local copy of
the database on my drive. As there was no such option of save as for the
database, I ended up making a replica of it. Now I have found that I could
make a copy of it by simply dragging it. Now I have these problems

1) is there any way, I can undo it?
2) If I delete the replica on my local folder, will the original data/

database on the network drive remain there.

3) Can I change the Design Master to its previous state (there was no

design master before I replicated it)

 

[Guest]

Hi Cheryl,
Unfortunately, the kind of fix I am in right now, I need to undo this myself. If you could please tell me how to do it, I'd be really thankful.
TIH
Shilps

 

[Cheryl Fischer]

I recommend STRONGLY that you that you follow my earlier advice and contact
your IT Dept or the original database programmer. Everyone, at one time or
another, has pressed the wrong key or selected the wrong menu option and
received unexpected results. If your organization has a backup system, it
is possible that the database can be restored from an earlier backup. Yes,
you may have to deal with the fact that you were in a database that you were
instructed "not to touch", but you won't do any *further* damage.

Instructions for turning a replicated database into a regular database can
be found at the links listed below. Please note that each of these articles
points out that the techniques are described as: "Advanced: Requires expert
coding, interoperability, and multi-user skills."

1. Select the article that applies to the version of Access in which the
database was written.

2. Read and re-read each article to assure that you understand the steps.

3. If you have any questions about anything found in the article, post them
to the following newsgroup devoted to Access Replication

microsoft.public.access.replication BEFORE you attempt to do
anything with the replicated database.


Access 2002: How to make a replicated database a regular database
http://support.microsoft.com/default.aspx?scid=kb;en-us;290052

Access 2000: How to make a replicated database a regular database
http://support.microsoft.com/default.aspx?scid=kb;EN-US;208394

Access 95/97: How to make a replicated database a regular database
http://support.microsoft.com/default.aspx?scid=kb;en-us;153526



--

Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX

Hi Cheryl,
Unfortunately, the kind of fix I am in right now, I need to undo this

myself. If you could please tell me how to do it, I'd be really thankful.