[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