GOTIT, Linked table mangaer, and re-link ty
--- In MS_Access_Professionals@yahoogroups.com, "Terence" <buffalome90210@...> wrote:
>
> TY Bill that works, but now another issue. The Database was split. When I attempt to run the application I get a 3044 error indicating "cannot find the be.accdb" How can I re-establish the link to the BE ? Additionally , the physical location of the BE will be relative to the location of the application, ie CurrentProject.Path.
>
> Confussed a little
> Terence
>
> --- In MS_Access_Professionals@yahoogroups.com, "Bill Mosca" <wrmosca@> wrote:
> >
> > Terence
> >
> > VBA has a built-in property to get the directory of the database.
> > CurrentProject.Path
> >
> > Regards,
> > Bill Mosca, Founder - MS_Access_Professionals
> > http://www.thatlldoit.com
> > Microsoft Office Access MVP
> > https://mvp.support.microsoft.com/profile/Bill.Mosca
> >
> >
> >
> >
> > --- In MS_Access_Professionals@yahoogroups.com, "Terence" <buffalome90210@> wrote:
> > >
> > > I madde a mistake, in one of my systems, I hard coded C:\Tapestry\blah blah....
> > >
> > > There are a couple a places within the code where files are referd to.
> > > My code always refres to "C:\TAPESTRY\FileABC", etc.
> > >
> > > Customer is moving to a shared drive and therefore C:\TAPESTRY will not be applicable. I do not want to Hard code a folder address. I prefer to use an implicit indicating The Same Folder that the Database is located".
> > >
> > > What is the prefered way to do this ?
> > >
> > > terence
> > >
> >
>
Tidak ada komentar:
Posting Komentar