Advertisement

02.07.2008 at 09:28AM PST, ID: 23145132
[x]
Attachment Details

ACCESS 2007 Runtime Security Problem

Asked by phmurphy in Microsoft Access Database, Access Forms, Access Coding/Macros

I have an ACCESS Form that I have packaged as a RunTime and it works perfectly on the computer where it was created.  This computer has Office 2007 Pro.  When I install the package that includes the runtime files on computer with Office 2003 Pro it opens with a security warning that I would like to get rid of, but more importantly the program crashes when it tries to export a set of tables to an /mdb file.  See the code below.   I suspect there might be a write permission thing going on.

Thanks,
PatStart Free Trial 
1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:

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
[+][-]02.07.2008 at 09:33AM PST, ID: 20842882

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]02.07.2008 at 10:29AM PST, ID: 20843451

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]02.07.2008 at 10:57AM PST, ID: 20843798

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]02.07.2008 at 11:18AM PST, ID: 20844051

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: Microsoft Access Database, Access Forms, Access Coding/Macros
Sign Up Now!
Solution Provided By: phmurphy
Participating Experts: 0
Solution Grade: A
 
 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628