[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

ACCESS 2007 Runtime Warning Windows Issue

Posted on 2008-02-07
7
Medium Priority
?
730 Views
Last Modified: 2011-10-19
I have a data form developed in ACCESS 2007 and I have set it up for the runtime mode.  It works perfectly on the machine I created it on, but I get warning windows when it is first opened and I get ten warning windows in a row when I send 10 table to an external database.  I get the errors with DoCmd.TransferDatabase  but I don't get the errors when I export an Excel spreadsheet with DoCmd.TransferSpreadsheet.  The code below is what gives the error, but for documentation, here is the code that created the file to receive the exported tables.

Private Sub cmdExportMDB_Click()
'This refresh is necessary since the refresh rate is the frequency of saving changes back to the table.
'The default refresh rate can be set by the user but the default value is 60 seconds so if the data are
'copies to a file less than 60 seconds after a change, the change does not occur in the output file.
Me.Refresh
Dim db As DAO.Database
'create a string variable to use as a test for the presence of the WF87Link.mdb file
Dim TestLinkFile As String
'If the file exists, DIR will return the file name, if not it will be a blank string
TestLinkFile = Dir("C:\WetForm\WF87Link.mdb")
'This tests for the existence of the file, if the file doesn't exist then it is created.
If TestLinkFile = "" Then
Set db = CreateDatabase("C:\WetForm\WF87Link.mdb", dbLangGeneral, dbVersion40)
db.Close
Set db = Nothing
End If
DoCmd.SetWarnings False
DoCmd.TransferDatabase acExport, "Microsoft Access", "C:\WetForm\WF87Link.mdb", acTable, "WetForm", "WetForm", False
DoCmd.TransferDatabase acExport, "Microsoft Access", "C:\WetForm\WF87Link.mdb", acTable, "WetForm2", "WetForm2", False
DoCmd.TransferDatabase acExport, "Microsoft Access", "C:\WetForm\WF87Link.mdb", acTable, "SpeciesLookup", "SpeciesLookup", False
DoCmd.TransferDatabase acExport, "Microsoft Access", "C:\WetForm\WF87Link.mdb", acTable, "SoilInfo", "SoilInfo", False
DoCmd.TransferDatabase acExport, "Microsoft Access", "C:\WetForm\WF87Link.mdb", acTable, "State_County", "State_County", False
DoCmd.TransferDatabase acExport, "Microsoft Access", "C:\WetForm\WF87Link.mdb", acTable, "VegRemark", "VegRemark", False
DoCmd.TransferDatabase acExport, "Microsoft Access", "C:\WetForm\WF87Link.mdb", acTable, "SoilRemark", "SoilRemark", False
DoCmd.TransferDatabase acExport, "Microsoft Access", "C:\WetForm\WF87Link.mdb", acTable, "SprintDB_SysTable", "SprintDB_SysTable", False
DoCmd.TransferDatabase acExport, "Microsoft Access", "C:\WetForm\WF87Link.mdb", acTable, "PhotoLocations", "PhotoLocations", False
DoCmd.TransferDatabase acExport, "Microsoft Access", "C:\WetForm\WF87Link.mdb", acTable, "HydRemark", "HydRemark", False
DoCmd.SetWarnings True

Open in new window

0
Comment
Question by:phmurphy
  • 4
  • 2
7 Comments
 
LVL 85
ID: 20847034
What are the "warning windows"? Can you post the exact message you receive?

What OS are you running this on?

0
 

Author Comment

by:phmurphy
ID: 20847095
It had a lot of text and a screen shot of it is attached.
Security Notice
A Potential security concern has been identified.
Warning: It is not possible to determine that this contend came from a trustworth source......

File Path: C:\.....
error1.doc
0
 
LVL 85
ID: 20848996
The .Doc file won't open. Please post an Image file (.jpg or .png) instead - I really, really don't like opening .doc files, had too many bad experiences with them.

You can get a free screenshot capture tool here:

http://www.mirekw.com/winfreeware/mwsnap.html

Again: What operating system are you running this on? Vista, XP, etc?

The database you're trying to export to - is this in a Trusted Location? This can be checked in the Access Options section ... if it's NOT in a Trusted Location then I'm not sure how you can get those warnings to go away.
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 

Author Comment

by:phmurphy
ID: 20849435
Thank you for your response,
The .jpg is attached. - I get this same type of error when the runtime opens.
I have Windows XP Pro Sp2 on my main machine,, the others have the same.

The folder where the .mdb is coming from and the folder where the files/tables are being copied to are in trusted locations.  Does the trusted location travel with the runtime?  In other words, if C:\WetForm and its subfolders is trusted on the main machine, is the same path trusted on the others?  Since the other machines don't have ACCESS 2007 loaded on them, there is no way to set the trusted locations on the other machines.  They do happen to have ACCESS 2003 loaded on them, but there is no "Trusted Zone" settings in 2003 as far as I know.
error1.jpg
0
 

Author Comment

by:phmurphy
ID: 20849571
Also, no errors occur when I run the same file as an .mdb in ACCESS 2003 on the other machines.
0
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 2000 total points
ID: 21016472
How about this:

http://blogs.msdn.com/access/archive/2007/08/10/access-database-engine-redistributable.aspx

And

http://support.microsoft.com/kb/937999

I found this on Google

Try this:

In Registry Editor, locate the following registry subkey:
HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Common

1) Click the registry subkey, point to New on the Edit menu, and then click Key.
2) Type Security, and then press ENTER to name the key.
3) On the Edit menu, point to New, and then click DWORD Value.
4) Type DisableHyperlinkWarning, and then press ENTER to name the entry.
5) In the right pane, right-click DisableHyperlinkWarning, and then click Modify.
6) In the Edit DWORD Value dialog box, click Decimal, and then type 1 under Value data.

Note A value of 0 enables the hyperlink warning message. A value of 1 disables the hyperlink warning message.
7) Click OK.
8) Exit Registry Editor.

0
 

Author Comment

by:phmurphy
ID: 21229304
I need to have something that doesn't require the client to go to the registry.  However the link to the microsoft site identifies the bug and provides some work arounds.

Thanks
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
Beware when using the ListIndex and the Column() properties of a listbox in Access 2007.  A bug has been identified in the Access 2007 listbox code which can cause the .ListIndex property to return a -1, and the .Columns(#) property to return a NULL…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Suggested Courses

590 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question