Diffficulty with split database

[DickW]

I have database program split into a FE and BE. The BE is on a server. I
have installed the FE on five computers in various locations. On three of
the computers the program works great. On the other two, I have the
following problem/situation.

If the FE is opened by using a shortcut with a target similar to "C:\Program
Files\Microsoft Office\OFFICE10\MSACCESS.EXE" "C:\FE.mdb", the FE opens but
data cannot be retrieved. If the FE.mdb is opened directly using Windows
Explorer, the same thing happens. It acts as if none of the queries are
being executed.

If MSAccess is first opened and then the FE is opened using File-Open, the
program works as designed.

There are no discernable differences in the operating system on the five
computers (Windows XP) or the version of MSAccess. Since I need to put an
Icon on the desktop for routine users, this causes a problem.

This situation has me stumped. Any ideas would be appreciated.

Dick

 

[Douglas J. Steele]

When you say "data cannot be retrieved", exactly what do you mean? Do you
get any error message or prompt? If so, what is it?

Do you have code in the front-end that tries to relink the tables? If so,
what's the code?

 

[DickW]

Thanks for your prompt reply. Sorry that I hit the wrong button.

There are no error messages. The FE looks normal and fields can be entered.
I have a textbox to enter search terms to select data but no data is
retrieved. I also have a list box to select entries to retrieve details.
This also is dead. As I say, it works if Access is opened first.

I am using code from the "Access 2002 Enterprise Developer's Handbook" to
relink the tables. Note, however, that the tables have been linked properly
before the problem occurs.

 

[DickW]

I should also mention that the program was originally installed using the MS
Packaging Wizard. I wonder if there is a register entry causing the
problems.

 

[gllincoln]

Hi Dick,

Just a thought...

Were these machines upgraded from an older version of Access? Or do they
have 2003 installed locally and also have Runtime 2007 installed on them?
Ran into this one recently - certain file associations can get messed up.
Runtime 2007 appears to have some issues about peacefully cohabitating with
older, full versions of Access. The effect can be exactly like what you
described. Same exact FE will not run on this machine but will over there.
In one case, I nagivated to the Office XX folder and clicked directly on
msaccess.exe - the windows installer box popped up, said it was installed
Office 2003 Professional, showed a status bar that whipped through whatever
in a few seconds (probably registry entries), and everything started working
again.

Hope this helps...
Gordon