Database Copy but getting updated

  • Thread starter Thread starter PSULionRP
  • Start date Start date
P

PSULionRP

Ok...Granted, I am an Access novice. But am I going crazy here!!! I copied
the Production Access Database to my own network drive. I just sat with a
Business User of this Database and she updated some things in the Production
version that actually shows up in my copied, personal network drive version.
Is there a hook somewhere that I am not aware of??? I have to do some testing
and I certainly don't want to mess up the Production version of the Access
Database by putting things in what I thought was my standalone copy.

Confused....

Thanks in advance for your review and help trying to help me understand this.

PSULionRP
 
What you're hoping to do and what you have done are ambiguous. Giving
pathnames, where are "the Production Access Database" and "my own
network drive"?

I'm assuming that you copied both the FrontEnd and BackEnd of a split
application to the new location on your network.. I'll further assume
that you *don't* want both FrontEnds talking to the same BackEnd ....

Open your new copy of the FrontEnd; Tools/Addins/Linked Table Manager.
Check "Select All" and check "Ask Me". Click OK. In the dialog box
that comes up, navigate to the new copy of the BackEnd and click OK.
That should update all of your tables with the proper location.

HTH
 
Within the copied Access Database on my own network drive, which I'd like as
"stand alone", when I do...

Tools ==> Add Ins it only displays Add-In manager and when I go there, there
is nothing displayed.

I am working with Microsoft Access 2003 SP3.
 
PSULionRP said:
Within the copied Access Database on my own network drive, which I'd like as
"stand alone", when I do...

Tools ==> Add Ins it only displays Add-In manager and when I go there, there
is nothing displayed.

I am working with Microsoft Access 2003 SP3.
Click to expand...

For Access 2003, you should be able to find the linked table manager
from Tools->Database Utilities.
 
Ok...Granted, I am an Access novice. But am I going crazy here!!! I copied
the Production Access Database to my own network drive. I just sat with a
Business User of this Database and she updated some things in the Production
version that actually shows up in my copied, personal network drive version.
Is there a hook somewhere that I am not aware of??? I have to do some testing
and I certainly don't want to mess up the Production version of the Access
Database by putting things in what I thought was my standalone copy.

Confused....

Thanks in advance for your review and help trying to help me understand this.

PSULionRP
Click to expand...

It is quite possible that Windows created a *shortcut* to the production
database, rather than copying the entire database. Use Windows Explorer in
View... Details mode; how big is the file on your disk?

And... if your "production" database is unsplit and is shared among multiple
users, you're in for some real trouble. Any production database should (MUST!)
be split.
 
I DEFINTELY did NOT create a shortcut....it's the whole Access Database. I
was sitting with the business user, she added something and then it showed up
on my local copy. What she added was thru a form and a row added to an Access
Table. So I was like shocked when I opened up my copy and version and saw the
row within the table.

Could you expand a little more about this whole "split" business???

Thanks John!
 
I DEFINTELY did NOT create a shortcut....it's the whole Access Database. I
was sitting with the business user, she added something and then it showed up
on my local copy. What she added was thru a form and a row added to an Access
Table. So I was like shocked when I opened up my copy and version and saw the
row within the table.
Click to expand...

This makes no sense to me. She added a row to the *PRODUCTION* table and it
was then visible in your copy!?
Could you expand a little more about this whole "split" business???
Click to expand...

A split database has a "Frontend" containing forms, reports, code, and
queries, with *links* to the tables in the backend. The (usually shared)
backend contains only the tables; it can have many frontends linked to it. If
you open your frontend and look at the Tables window you will see a little
dark arrowhead icon next to each table name if it is a split database. You can
also hover the mouse over the tablename and if it's linked you'll see the path
and filename to the linked table; you can also use Tools... Database
Utilities... Linked Table Manager to see if the tables are linked and where.

For more details about split applications see
http://www.granite.ab.ca/access/splitapp.htm and references therein.
 
Back
Top