473,725 Members | 1,720 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Converting A2K to Access 03

Hi and TIA. I developed several A2K dbs which are now being run on my
clients computer which have been upgraded to Access 03. I'm not sure
exactly what they mean but of you know or could point me in a direction
to find info on how to prevent and/or fix the db's so that these
message don't pop up when the app is started. Error messages below:

1. Microsoft Jet 4.0 service pack 8 must be installed to block unsafe
expressions without affecting common functionality.

2. Opening C:\AMRR\AMRR.md b
This file may not be safe if it contains code intended to harm your
computer.
Do you want to open this file or cancel the operation?

3. Security warning: Unsafe expression are not blocked.
Do you want to block usafe expressions?

Thanks for your time.

Jun 9 '06 #1
23 2648
Hi, Reggie.
1. Microsoft Jet 4.0 service pack 8 must be installed to block unsafe
expressions without affecting common functionality.
Since your client has Access 2003 installed, Jet 4.0 SP-8 is also installed,
so this is not really very useful information. It's the message intended
for Access 2002 users, because they _don't_ have SP-8 installed by default,
so they'd need to know that for security purposes, if they want to block
unsafe expressions, then they're going to have to ensure that SP-8 is
installed first.
2. Opening C:\AMRR\AMRR.md b
This file may not be safe if it contains code intended to harm your
computer.
Do you want to open this file or cancel the operation?
This means that the file contains VBA code, or action queries, or an
expression in a query, or form, or report, or a control property that is on
the list of potentially harmful expressions, such as "Quit," which will
close an application. The software isn't sophisticated enough to tell
whether a virus is embedded in the file, or the VBA code, action queries, or
expressions are actually harmful, though. If your client is going to get
any work done, then he'd better open the file and look inside to see whether
there actually _is_ any harmful content. Oh, wait. _You_ built the
application for them. Why not just tell them over the phone or by E-mail
whether or not you put malicious expressions in there, so that they won't
lose any more sleep?
3. Security warning: Unsafe expression are not blocked.
Do you want to block usafe expressions?
If you intentionally put malicious expressions in there, then this is your
client's chance to block those expressions when they open the file. If you
didn't put malicious expressions in the file, then they don't need to block
the potentially harmful expressions -- because there aren't any. If you put
malicious code in there, then they're SOL, because the VBA code can't be
blocked with the security features of Jet 4.0, SP-8.
you know or could point me in a direction
to find info on how to prevent and/or fix the db's so that these
message don't pop up when the app is started.
Access 2003's Macro Security level is set to medium, the default. They need
to change it to low in order to avoid these messages when opening your
application. To do so, open Access and select the Tools -> Macro ->
Security... menu to open the Security dialog window. Select the "Low"
option and select the "OK" button to save the change.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.
"Reggie" <rs****@resourc econsultants.co m> wrote in message
news:11******** **************@ j55g2000cwa.goo glegroups.com.. . Hi and TIA. I developed several A2K dbs which are now being run on my
clients computer which have been upgraded to Access 03. I'm not sure
exactly what they mean but of you know or could point me in a direction
to find info on how to prevent and/or fix the db's so that these
message don't pop up when the app is started. Error messages below:

1. Microsoft Jet 4.0 service pack 8 must be installed to block unsafe
expressions without affecting common functionality.

2. Opening C:\AMRR\AMRR.md b
This file may not be safe if it contains code intended to harm your
computer.
Do you want to open this file or cancel the operation?

3. Security warning: Unsafe expression are not blocked.
Do you want to block usafe expressions?

Thanks for your time.

Jun 9 '06 #2
Gunny, Thanks for the awesome info. My clients know that there is no
malicious code because they've been using my apps for years (A2K), but
they are military/government clients and are pretty limited on what
they are able to configure on their machines. I've never used 2003 so
was unaware. I also came across the Sandbox setting which is new to
me. Been doing a lot of .net stuff so been out of the loop for a
little while. You said to change the setting for macros under the
tools menu should stop the popup messages. I also read something about
having to change the registry setting of the Sandbox attribute to 0.
Do I need to do both? Looks like I need to get back aquinted with the
2003 version. Lastly, I have the following Jet version installed
(4.0.8618.0 Windows XP SP2 and Security Bulletin MS04-014) Could you
tell me if this includes SP8? I think it does, but not real sure.
Thanks again for your time Gunny.
'69 Camaro wrote:
Hi, Reggie.
1. Microsoft Jet 4.0 service pack 8 must be installed to block unsafe
expressions without affecting common functionality.


Since your client has Access 2003 installed, Jet 4.0 SP-8 is also installed,
so this is not really very useful information. It's the message intended
for Access 2002 users, because they _don't_ have SP-8 installed by default,
so they'd need to know that for security purposes, if they want to block
unsafe expressions, then they're going to have to ensure that SP-8 is
installed first.
2. Opening C:\AMRR\AMRR.md b
This file may not be safe if it contains code intended to harm your
computer.
Do you want to open this file or cancel the operation?


This means that the file contains VBA code, or action queries, or an
expression in a query, or form, or report, or a control property that is on
the list of potentially harmful expressions, such as "Quit," which will
close an application. The software isn't sophisticated enough to tell
whether a virus is embedded in the file, or the VBA code, action queries, or
expressions are actually harmful, though. If your client is going to get
any work done, then he'd better open the file and look inside to see whether
there actually _is_ any harmful content. Oh, wait. _You_ built the
application for them. Why not just tell them over the phone or by E-mail
whether or not you put malicious expressions in there, so that they won't
lose any more sleep?
3. Security warning: Unsafe expression are not blocked.
Do you want to block usafe expressions?


If you intentionally put malicious expressions in there, then this is your
client's chance to block those expressions when they open the file. If you
didn't put malicious expressions in the file, then they don't need to block
the potentially harmful expressions -- because there aren't any. If you put
malicious code in there, then they're SOL, because the VBA code can't be
blocked with the security features of Jet 4.0, SP-8.
you know or could point me in a direction
to find info on how to prevent and/or fix the db's so that these
message don't pop up when the app is started.


Access 2003's Macro Security level is set to medium, the default. They need
to change it to low in order to avoid these messages when opening your
application. To do so, open Access and select the Tools -> Macro ->
Security... menu to open the Security dialog window. Select the "Low"
option and select the "OK" button to save the change.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.
"Reggie" <rs****@resourc econsultants.co m> wrote in message
news:11******** **************@ j55g2000cwa.goo glegroups.com.. .
Hi and TIA. I developed several A2K dbs which are now being run on my
clients computer which have been upgraded to Access 03. I'm not sure
exactly what they mean but of you know or could point me in a direction
to find info on how to prevent and/or fix the db's so that these
message don't pop up when the app is started. Error messages below:

1. Microsoft Jet 4.0 service pack 8 must be installed to block unsafe
expressions without affecting common functionality.

2. Opening C:\AMRR\AMRR.md b
This file may not be safe if it contains code intended to harm your
computer.
Do you want to open this file or cancel the operation?

3. Security warning: Unsafe expression are not blocked.
Do you want to block usafe expressions?

Thanks for your time.


Jun 9 '06 #3
Hi, Reggie.
I also read something about
having to change the registry setting of the Sandbox attribute to 0.
The default is 2, which means that Sandbox mode is used for non-Access
applications, but not for Access applications. If they change Sandbox mode
to 0, then Sandbox mode will be disabled for all applications that use Jet
4.0. I'd leave the setting at 2 (or change it back to 2 if it's currently
on another setting).
Looks like I need to get back aquinted with the
2003 version.
If you've waited this long, then probably not. Many folks skipped this
version due to the overly cautious, annoying security messages. Set the
Macro Security level to low, and the security feature works just like all
the previous versions, so this annoyance really isn't a good reason to avoid
this version.

Access 2007 is coming out early next year, and it promises a Macro Security
feature that's a little more manageable.
Lastly, I have the following Jet version installed
(4.0.8618.0 Windows XP SP2 and Security Bulletin MS04-014) Could you
tell me if this includes SP8?
Yes. msjet40.dll version 4.0.8618.0 contains Jet 4.0 SP-8.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.
"Reggie" <rs****@resourc econsultants.co m> wrote in message
news:11******** **************@ u72g2000cwu.goo glegroups.com.. . Gunny, Thanks for the awesome info. My clients know that there is no
malicious code because they've been using my apps for years (A2K), but
they are military/government clients and are pretty limited on what
they are able to configure on their machines. I've never used 2003 so
was unaware. I also came across the Sandbox setting which is new to
me. Been doing a lot of .net stuff so been out of the loop for a
little while. You said to change the setting for macros under the
tools menu should stop the popup messages. I also read something about
having to change the registry setting of the Sandbox attribute to 0.
Do I need to do both? Looks like I need to get back aquinted with the
2003 version. Lastly, I have the following Jet version installed
(4.0.8618.0 Windows XP SP2 and Security Bulletin MS04-014) Could you
tell me if this includes SP8? I think it does, but not real sure.
Thanks again for your time Gunny.
'69 Camaro wrote:
Hi, Reggie.
> 1. Microsoft Jet 4.0 service pack 8 must be installed to block unsafe
> expressions without affecting common functionality.


Since your client has Access 2003 installed, Jet 4.0 SP-8 is also
installed,
so this is not really very useful information. It's the message intended
for Access 2002 users, because they _don't_ have SP-8 installed by
default,
so they'd need to know that for security purposes, if they want to block
unsafe expressions, then they're going to have to ensure that SP-8 is
installed first.
> 2. Opening C:\AMRR\AMRR.md b
> This file may not be safe if it contains code intended to harm your
> computer.
> Do you want to open this file or cancel the operation?


This means that the file contains VBA code, or action queries, or an
expression in a query, or form, or report, or a control property that is
on
the list of potentially harmful expressions, such as "Quit," which will
close an application. The software isn't sophisticated enough to tell
whether a virus is embedded in the file, or the VBA code, action queries,
or
expressions are actually harmful, though. If your client is going to get
any work done, then he'd better open the file and look inside to see
whether
there actually _is_ any harmful content. Oh, wait. _You_ built the
application for them. Why not just tell them over the phone or by E-mail
whether or not you put malicious expressions in there, so that they won't
lose any more sleep?
> 3. Security warning: Unsafe expression are not blocked.
> Do you want to block usafe expressions?


If you intentionally put malicious expressions in there, then this is
your
client's chance to block those expressions when they open the file. If
you
didn't put malicious expressions in the file, then they don't need to
block
the potentially harmful expressions -- because there aren't any. If you
put
malicious code in there, then they're SOL, because the VBA code can't be
blocked with the security features of Jet 4.0, SP-8.
> you know or could point me in a direction
> to find info on how to prevent and/or fix the db's so that these
> message don't pop up when the app is started.


Access 2003's Macro Security level is set to medium, the default. They
need
to change it to low in order to avoid these messages when opening your
application. To do so, open Access and select the Tools -> Macro ->
Security... menu to open the Security dialog window. Select the "Low"
option and select the "OK" button to save the change.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.
"Reggie" <rs****@resourc econsultants.co m> wrote in message
news:11******** **************@ j55g2000cwa.goo glegroups.com.. .
> Hi and TIA. I developed several A2K dbs which are now being run on my
> clients computer which have been upgraded to Access 03. I'm not sure
> exactly what they mean but of you know or could point me in a direction
> to find info on how to prevent and/or fix the db's so that these
> message don't pop up when the app is started. Error messages below:
>
> 1. Microsoft Jet 4.0 service pack 8 must be installed to block unsafe
> expressions without affecting common functionality.
>
> 2. Opening C:\AMRR\AMRR.md b
> This file may not be safe if it contains code intended to harm your
> computer.
> Do you want to open this file or cancel the operation?
>
> 3. Security warning: Unsafe expression are not blocked.
> Do you want to block usafe expressions?
>
> Thanks for your time.
>

Jun 9 '06 #4
"'69 Camaro" <Fo************ **************@ Spameater.orgZE RO_SPAM>
wrote in news:Sf******** *************** *******@adelphi a.com:
Yes. msjet40.dll version 4.0.8618.0 contains Jet 4.0 SP-8.


The first digit of the build number is the SP level, in this case
build 8618. All build numbers 8NNN will be SP 8 or higher.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
Jun 9 '06 #5
In our environment users don't have the abilty to change macro settings or
install things themselves. To get past the prompts you're talking about we
experimented with Certificates, but we could not get them set up properly.
I'm still convinced that certificates are a better answer than this, but to
get around the problem until we can revisit certificates, I use this
vbscript file to open our app:

dim o
set o=createobject ("Access.Applic ation")
o.automationsec urity=1 'set macro security LOW.
o.opencurrentda tabase "\\ourfileserve r\files\myappdi rectory\myapp.m de"
o.usercontrol=t rue
set o=nothing

A shortcut on the user's desktop points to the script.

We still have an occasional problem related to some Windows update that does
not accomplish its full mission unless the user can log on to his
workstation as an Admin. The symptom that we get an error message when the
user trys to run the app via the vbscript:

Microsoft Access can't open database because it is missing, or opened
exclusively by another User.

The app is neither missing nor opened exclusively. The cure is to have the
user log out of the workstation, make the user an Admin on his or her own
workstation, have the user log back in. Try once to open the app and get
the same failure again. Try a second time to open the app, this time
successfully. Have the user log out of the workstation. Make the user NOT
an admin on the workstation, and then carry on as usual from then on. If I
remember correctly, the process fixes the problem even for other users,
meaning that if any user goes through the recovery steps I described, then
all users will find that they can open the app from that workstation.

I don't think IT ever found out what part of these updates is not "running
to completion" ( my opinion of the situation) and causing this.
Jun 9 '06 #6
"Rick Wannall" <wa*****@notado main.de> wrote in
news:_v******** ***********@new ssvr12.news.pro digy.com:
In our environment users don't have the abilty to change macro
settings or install things themselves. To get past the prompts
you're talking about we experimented with Certificates, but we
could not get them set up properly. I'm still convinced that
certificates are a better answer than this, but to get around the
problem until we can revisit certificates, I use this vbscript
file to open our app:


Doesn't the self-certification thingie do the job?

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
Jun 9 '06 #7
I can self-certify to prevent something on my own workstation from annoying
me, but my little certificate is of no value to other users. It's not
present on their workstations, and it would not be valid if it were.
Jun 9 '06 #8
Hi, Rick.
but my little certificate is of no value to other users. It's not
present on their workstations, and it would not be valid if it were.
Export your SelfCert's Public Key and install it on the target computer, and
it will be valid -- at least for Medium level Macro Security. High level
requires a certificate issued by a Certificate Authority for authentication.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.
"Rick Wannall" <wa*****@notado main.de> wrote in message
news:kF******** ************@ne wssvr29.news.pr odigy.net...I can self-certify to prevent something on my own workstation from annoying
me, but my little certificate is of no value to other users. It's not
present on their workstations, and it would not be valid if it were.

Jun 9 '06 #9
Aaaahhhh!!!!

Thank you!!

We'll give this a shot.
Jun 9 '06 #10

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

17
2898
by: chicha | last post by:
Hey people, I have to convert MS Access 2000 database into mysql database, the whole thing being part of this project I'm doing for one of my faculty classes. My professor somehow presumed I knew db's and gave me long list of things to do with that particular database, first thing being that particular conversion. Truth is that I don't know a first thing about db's, let alone using mysql... I downloaded mysql form www.mysql.com and...
5
2303
by: Terry Bell | last post by:
I'm upsizing an Access database. Got the data converted, working on the front end, converting queries to views, but having trouble converting queries that use logical expressions like the following: SELECT OrderId, Sum((BackOrderQtyAvailable>0)*-1) AS ReadyBackOrderItems FROM OrderDetails INNER JOIN Items ON (OrderDetails.ClientId = Items.ClientId) AND (OrderDetails.ItemId = Items.ItemId) WHERE (NOT (SitesCustomerTypeId = 2
1
1771
by: gary | last post by:
I am interesting in converting all or at least any portions of a Access 2002 frontend.mdb and backend.mdb into VB.net. Are there any conversion tools for such a monstrous task? I am especially interested in converting the layout of the forms and the queries. Any portion that I can convert will certainly be better than nothing. Thanks, Gary.
2
1670
by: Rohit | last post by:
Hi, My organisation is using Access 97 and going to replace it with access 2000. Users have n number mdb files created in 97. After installation of Access 2000 I need to conver ALL the mdbs to 97. Is there any so that this process will take minimum amount of time? Thanks in Advance
32
12509
by: robert d via AccessMonster.com | last post by:
I'm looking at converting DAO to ADO in my app. All of my DAO connections are of the following structure: Dim wsName As DAO.Workspace Dim dbName As DAO.Database Dim rsName As DAO.Recordset Set wsName = DBEngine.Workspaces(0) Set dbName = wsName.OpenDatabase(CurrentProject.FullName) Set rsName = dbName.OpenRecordset("SQL Statement")
4
3193
by: gg9h0st | last post by:
i'm a newbie studying php. i was into array part on tutorial and it says i'll get an array having keys that from member variable's name by converting an object to array. i guessed "i can get public members but not protected, private, static members"
9
2576
by: Terry | last post by:
I am converting (attempting) some vb6 code that makes vast use of interfaces. One of the major uses is to be able to split out Read-only access to an obect. Let me give you a simple (contrived) example: In Project RoObjDefs: RoPerson.cls file: Public Property Get FirstName() as String Public Property Get LastName() as String <end of file RoPerson.cls> RoPersons.cls file Public Function Count() as Integer
4
3321
by: Bob Alston | last post by:
Anyone have experience with converting an access app from Jet database to Mysql? I am specifically looking for any changes I would have to make to my access forms, queries, modules, vba code, etc. I understand there are some data format differences in text field types and date types that need to be addressed if converting from Jet to Mysql. But other than things that have to be addressed when converting, what other changes must I make?...
1
2463
by: murraystewart | last post by:
I have spent days building a database in access 2003 and the found it needs to run on Access 97, I did the conversion but the form is not opening with an error message "you loaded a form or report that has control or properties that microsoft access does not recognize and will ignore". have tried compacting and repairing and converting to MDE but to no avail. Is there anyone out there who could take a look at it. This is the first database...
28
3592
by: Randy Reimers | last post by:
(Hope I'm posting this correctly, otherwise - sorry!, don't know what else to do) I wrote a set of programs "many" years ago, running in a type of basic, called "Thoroughbred Basic", a type of business basic. I need to re-write it, bring it kicking and screaming to run on Windows XP. This is for a video rental place, tracks movie and game rentals, customers, employee transactions, reservations, does reports,..... and on. I know some of...
0
8872
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, weíll explore What is ONU, What Is Router, ONU & Routerís main usage, and What is the difference between ONU and Router. Letís take a closer look ! Part I. Meaning of...
0
9246
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
9162
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
5997
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4505
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4773
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3211
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2619
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2150
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.