[AccessD] BE, Back Up Question

Michael R Mattys michael.mattys at adelphia.net
Sun May 18 20:03:19 CDT 2003


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
>



More information about the AccessD mailing list