[AccessD] BE, Back Up Question

ACC2000: How to Use the OpenDatabase Method to Open
                        Password-Protected Databases
http://support.microsoft.com/default.aspx?scid=kb;EN-US;209953

Michael R. Mattys
www.mattysconsulting.com

----- Original Message -----
From: "Robert Gracie" <Subscriptions at servicexp.com>
To: <accessd at databaseadvisors.com>
Sent: Sunday, May 18, 2003 9:43 PM
Subject: RE: [AccessD] BE, Back Up Question


>
> Thanks Michael,
>  One last question, if you don't mind....
>
>   How would I use this "objAcc.OpenCurrentDatabase sToPath" with User
Level
> Security turned on?
>
>   The "third" db used is managed under the same security group as the db
> that I want to backup...
>
> Thanks A Million
> Robert Gracie
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Michael R
> Mattys
> Sent: Sunday, May 18, 2003 9:03 PM
> To: accessd at databaseadvisors.com
> Subject: Re: [AccessD] BE, Back Up Question
>
>
> Ah, now I think I see the answer.
> Use a function like this to copy desired objects:
>
> Function CopyFromTo(sToPath, sNewName, lngObjType, sOldName)
>     Dim objAcc As New Access.Application
>     objAcc.OpenCurrentDatabase sToPath
>     objAcc.DoCmd.CopyObject _
>             sToPath, sNewName, lngObjType, sOldName
>     objAcc.CloseCurrentDatabase
>     objAcc.Quit
>     Set objAcc = Nothing
> End Function
>
> Michael R. Mattys
> www.mattysconsulting.com
>
> ----- Original Message -----
> From: "Robert Gracie" <Subscriptions at servicexp.com>
> To: <accessd at databaseadvisors.com>
> Sent: Sunday, May 18, 2003 1:31 PM
> Subject: RE: [AccessD] BE, Back Up Question
>
>
> >
> > Thanks, but no go.
> >  Why will it work if I copy the table into the "calling" db?
> >
> >
> >
> > Robert Gracie
> >
> >
> >
> > -----Original Message-----
> > From: accessd-bounces at databaseadvisors.com
> > [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Michael R
> > Mattys
> > Sent: Saturday, May 17, 2003 10:38 PM
> > To: accessd at databaseadvisors.com
> > Subject: Re: [AccessD] BE, Back Up Question
> >
> >
> > Robert,
> >
> > Perhaps simply starting with
> > RefreshDatabaseWindow...?
> >
> > Michael R. Mattys
> > www.mattysconsulting.com
> >
> > ----- Original Message -----
> > From: "Robert Gracie" <Subscriptions at servicexp.com>
> > To: <accessd at databaseadvisors.com>
> > Sent: Saturday, May 17, 2003 10:02 PM
> > Subject: RE: [AccessD] BE, Back Up Question
> >
> >
> > >
> > > I'm trying to backup an open split back-end using the code below. This
> is
> > a
> > > "third" db that is opening up a back-end and copying the tables and
data
> > to
> > > a newly created db. However I keep getting this error.
> > >
> > > 7874 SXP Maintenance System can't find the object 'Customer.' Note:
SXP
> > > Maintenance is the name of the calling db
> >
> > _______________________________________________
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
> >
> >
> > _______________________________________________
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com