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
--
-Larry-
--

"PSULionRP" <(E-Mail Removed)> wrote in message
news:1F24758A-EFBD-436C-82E3-(E-Mail Removed)...
> 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

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.

"Larry Daugherty" wrote:

> 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
> --
> -Larry-
> --
>
> "PSULionRP" <(E-Mail Removed)> wrote in message
> news:1F24758A-EFBD-436C-82E3-(E-Mail Removed)...
> > 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
>
>
>

PSULionRP wrote:
> 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.

For Access 2003, you should be able to find the linked table manager
from Tools->Database Utilities.

On Wed, 22 Apr 2009 07:29:01 -0700, PSULionRP
<(E-Mail Removed)> wrote:

>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

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.

--

John W. Vinson [MVP]

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!

"John W. Vinson" wrote:

> On Wed, 22 Apr 2009 07:29:01 -0700, PSULionRP
> <(E-Mail Removed)> wrote:
>
> >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
>
> 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.
>
> --
>
> John W. Vinson [MVP]
>

On Wed, 22 Apr 2009 11:27:03 -0700, PSULionRP
<(E-Mail Removed)> wrote:

>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.

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???

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.
--

John W. Vinson [MVP]

Prueba mexicana


On 22/04/09 04:42 p.m., in article
(E-Mail Removed), "John W. Vinson"
<jvinson@STOP_SPAM.WysardOfInfo.com> wrote:

>