ACCESS FEED: [MS_AccessPros] Re: best way to use an implicit folder location of SAME PLACE DB is located ?

Rabu, 19 Oktober 2011

[MS_AccessPros] Re: best way to use an implicit folder location of SAME PLACE DB is located ?

Terence

You can make it even more fancy by using a function to link the tables. If you open the MSysObjects system table you will see a field named Database.

By using a file dialog box to let the user browse to the back end, you can update that field.

Let me know if you want to pursue this. I can write up a module for you.

Hint: There is a Common Dialog module in our files>Modules and Classes named basCommDlg.bas. You can import it into your code project and use it to get the path and then update the database field where Type = 6. All local tables have a Type of 1.

Bill

--- In MS_Access_Professionals@yahoogroups.com, "Terence" <buffalome90210@...> wrote:
>
> 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
> > > >
> > >
> >
>