Re: Relink question

"BruceM" <bamoob@xxxxxxxxxxxxxxxx> wrote:

Thanks again, Graham.. It will be some time before I can sort this out. In
particular it seems I need to use something like GetPrivateProfileString to
read from the ini file,

And the equivalent to write to the INI file once you've found the
correct BE.

Or you could use the registry. I initially chose to use INI files
because I figured that it would be easier for the users if they ever
had to manually update the file. But in over ten years I don't think
I've ever had the need.

I think I'll look for a way to
relink all tables every time and leave it at that for now.

Note that for best performance you should do either one of the
following:

1) Open a database variable against the backend
or
2) Once you've relinked the first table open a recordset variable
against that table and continue relinking all the other tables.

This will make a huge difference in performance when someone else is
already in the FE linked to the BE in question.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
.

Relevant Pages

  • Re: Tonys Auto FE updater and Runtime
    ... Tony Toews, Microsoft Access MVP ... appear at all and I edit the ini file as necessary. ... Runtime by just using the command switch by adding it to ... haven't been able to test the package on an Access-less computer ...
    (comp.databases.ms-access)
  • Re: 2007 Runtime and Linked Table Manager
    ... Relink Access tables from code ... I store the path in an INI file in the same folder as the FE. ... Tony Toews, Microsoft Access MVP ...
    (microsoft.public.access.gettingstarted)
  • Re: Deploying linked tables
    ... backend on my development machine is established. ... If either the INI file doesn't exist or the location and name of the ... Tony Toews, Microsoft Access MVP ...
    (microsoft.public.access.developers.toolkitode)
  • Re: Front-end / Back-end - Vista
    ... says the BE is located in "my computer/my application". ... I don't distribute an INI file. ... a demo MDB in %userapps%Granite Fleet Mgr folder ... Tony Toews, Microsoft Access MVP ...
    (microsoft.public.access.modulesdaovba)
  • Re: Trying to use *.ini file as a database record
    ... >GetPrivateProfileString and WritePrivateProfileString APIs ... >as a way of creating and manipulating a database file. ... Provided your INI file is not planned to grow too much, ...
    (comp.lang.basic.visual.misc)
Loading