G
Guest
I hate to even start to ask this question because I know as a rule, you do not support Access 97 files, but I am going to talk fast so I can get the whole question out before you tell me no
Here is the situationâ€
At the La Porte site we have several Access databases that are shared plant wide. For years we have just had a system of sending out shortcuts to them to be saved on peoples desktop and although, not a very slick way of doing it, it has worked. Lately I have been hearing some people say that their shortcuts are not following their profile when they logon to a different workstation
We have recently implemented an Environmental Event Reporting database that is used for making time sensitive reports to various government agencies. If there is an event after regular work hours, this may be done by a non-environment person or on a workstation that is not normally used. The logical solution would seem to be to put a link to the database on ION where everyone would always have access to it
Here is the problemâ€
The problem is that when you use a hyperlink on a web page to open an Access97 file, it opens two sessions of the same file. As you can see from the e-mails below, we have been scratching our heads for a while on this trying to figure out something that will work but nothing has so far
Requestâ€
Is there any other resource available to us that may have an answer to this
***********************************************************************************
I would say contact 4500 as this might be a time for us to contact Microsoft, and get some answers from them
******************************************************************************
Thank you for your help. I hate this because it does not look like there is a fix for it. Here is how I understand the article is sayingâ€
CAUS
This problem may occur if the following conditions are true:
<< OLE Object: Picture (Metafile) >> The Web page is being accessed from Microsoft Internet Explorer versions 3.x or later. This is tru
<< OLE Object: Picture (Metafile) >> The Startup form has its HasModule property set to True I removed all code from my start up form (on another database) and set the HasModule property to False. I even shut my computer down and restarted it to test this but that did not solve the problem
<< OLE Object: Picture (Metafile) >> or the form is calling a function referencing VBA332.DLL. This would have to happen from some internal function that I am not causing my code
<< OLE Object: Picture (Metafile) >> The hyperlink is a file reference. I assume it has to be a file reference
RESOLUTIO
To work around this problem, change the link from a file reference to a URL as described in the following example.
Exampl
1. Close all instances of Microsoft Access.
2. Move or copy the database to a folder on the Web server Not an option
or make the current folder a virtual directory. I don't know what this is
3. Edit the Web page, changing the file reference to a URL.
***********************************************************************************
Here is the answer on Microsoft's web site
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q18630
The file has some code that's causing the problem to happen
**********************************************************************************
OK, the web page is out there. There are several database links on this page but the only database that I have been working with to resolve this problem is the Environmental Event Tracking database. I have removed all the code from the opening screen except the event procedure attached to the command button on it. That code does not run until someone presses enter or clicks it with the mouse
http://ion/mfg/mfg_LPO/Body/dept_body7-database.htm
********************************************************************************
<\\***fs02\groups\Everyone\HSE\Databases\EnvironmentalReports.mdb
****************************************************************************************
I worked with Fadi , IT support guru, on the opening two copies of the mdb. Click the link he sent. The answer is in the last posting. BUT I tried taking it off the splash screen only, and it still tries to open 2. I wonder if you can't use "docmd.Maximize" at all??? See what you think
Thanks, ************************************************************************************
This thread confirms that the problem is in the way the MDB file was designed:
http://groups.google.com/groups?hl=...&selm=%23RB9ckVrBHA.1816%40tkmsftngp07&rnum=2
You can share this with your DB guru and see what she/he says.
***************************************************************************************8
I've been trying each of the different types to see if one would behave differently, and not launch 2 copies of the mdb.
The server path would be \\***fs02\groups\everyone\lpoctg\databases\SEMS\sems.mdb
Thanks, *****************************************************************************************
When I look at your link, I see the following piece of code: target="_blank"
This means the link will open in a new window.
*****************************************************************************************
Fadi,
The original hyperlink Target was set to default, and was opening two copies of the database, so we tried the new window option. But I will change it to the path, but the database is only for LPO folks.
Also, it tends so open it in the background. You'll see the icon on your status bar, but the window is behind the current/launching window???
*****************************************************************************************
The reason your link is opening two files is because the target frame is set to new window. If you set it to default, it should only open one.
The way you created the link will only allow those who's G:\ drive is set as the ION author's mapping to work. Everyone else within the company will not be able to link to the database. The correct linking should be to the \\server\\RestOfThePath
***************************************************************************************
I was not able to get the link to work. The issue could be because you are opening an access database, which is not always seamless from ION. Fadi, do you have any ideas on this?
****************************************************************************************
Hi,
On our Useful Links webpage (******, Useful Links (bottom left), we have a hyperlink to SEMS, one of our databases here at the plant. And the hyperlinks works, BUT it launches 2 copies of the database.
Any suggestions of how to correct to it only launches one copy?.
Here is the situationâ€
At the La Porte site we have several Access databases that are shared plant wide. For years we have just had a system of sending out shortcuts to them to be saved on peoples desktop and although, not a very slick way of doing it, it has worked. Lately I have been hearing some people say that their shortcuts are not following their profile when they logon to a different workstation
We have recently implemented an Environmental Event Reporting database that is used for making time sensitive reports to various government agencies. If there is an event after regular work hours, this may be done by a non-environment person or on a workstation that is not normally used. The logical solution would seem to be to put a link to the database on ION where everyone would always have access to it
Here is the problemâ€
The problem is that when you use a hyperlink on a web page to open an Access97 file, it opens two sessions of the same file. As you can see from the e-mails below, we have been scratching our heads for a while on this trying to figure out something that will work but nothing has so far
Requestâ€
Is there any other resource available to us that may have an answer to this
***********************************************************************************
I would say contact 4500 as this might be a time for us to contact Microsoft, and get some answers from them
******************************************************************************
Thank you for your help. I hate this because it does not look like there is a fix for it. Here is how I understand the article is sayingâ€
CAUS
This problem may occur if the following conditions are true:
<< OLE Object: Picture (Metafile) >> The Web page is being accessed from Microsoft Internet Explorer versions 3.x or later. This is tru
<< OLE Object: Picture (Metafile) >> The Startup form has its HasModule property set to True I removed all code from my start up form (on another database) and set the HasModule property to False. I even shut my computer down and restarted it to test this but that did not solve the problem
<< OLE Object: Picture (Metafile) >> or the form is calling a function referencing VBA332.DLL. This would have to happen from some internal function that I am not causing my code
<< OLE Object: Picture (Metafile) >> The hyperlink is a file reference. I assume it has to be a file reference
RESOLUTIO
To work around this problem, change the link from a file reference to a URL as described in the following example.
Exampl
1. Close all instances of Microsoft Access.
2. Move or copy the database to a folder on the Web server Not an option
or make the current folder a virtual directory. I don't know what this is
3. Edit the Web page, changing the file reference to a URL.
***********************************************************************************
Here is the answer on Microsoft's web site
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q18630
The file has some code that's causing the problem to happen
**********************************************************************************
OK, the web page is out there. There are several database links on this page but the only database that I have been working with to resolve this problem is the Environmental Event Tracking database. I have removed all the code from the opening screen except the event procedure attached to the command button on it. That code does not run until someone presses enter or clicks it with the mouse
http://ion/mfg/mfg_LPO/Body/dept_body7-database.htm
********************************************************************************
<\\***fs02\groups\Everyone\HSE\Databases\EnvironmentalReports.mdb
****************************************************************************************
I worked with Fadi , IT support guru, on the opening two copies of the mdb. Click the link he sent. The answer is in the last posting. BUT I tried taking it off the splash screen only, and it still tries to open 2. I wonder if you can't use "docmd.Maximize" at all??? See what you think
Thanks, ************************************************************************************
This thread confirms that the problem is in the way the MDB file was designed:
http://groups.google.com/groups?hl=...&selm=%23RB9ckVrBHA.1816%40tkmsftngp07&rnum=2
You can share this with your DB guru and see what she/he says.
***************************************************************************************8
I've been trying each of the different types to see if one would behave differently, and not launch 2 copies of the mdb.
The server path would be \\***fs02\groups\everyone\lpoctg\databases\SEMS\sems.mdb
Thanks, *****************************************************************************************
When I look at your link, I see the following piece of code: target="_blank"
This means the link will open in a new window.
*****************************************************************************************
Fadi,
The original hyperlink Target was set to default, and was opening two copies of the database, so we tried the new window option. But I will change it to the path, but the database is only for LPO folks.
Also, it tends so open it in the background. You'll see the icon on your status bar, but the window is behind the current/launching window???
*****************************************************************************************
The reason your link is opening two files is because the target frame is set to new window. If you set it to default, it should only open one.
The way you created the link will only allow those who's G:\ drive is set as the ION author's mapping to work. Everyone else within the company will not be able to link to the database. The correct linking should be to the \\server\\RestOfThePath
***************************************************************************************
I was not able to get the link to work. The issue could be because you are opening an access database, which is not always seamless from ION. Fadi, do you have any ideas on this?
****************************************************************************************
Hi,
On our Useful Links webpage (******, Useful Links (bottom left), we have a hyperlink to SEMS, one of our databases here at the plant. And the hyperlinks works, BUT it launches 2 copies of the database.
Any suggestions of how to correct to it only launches one copy?.