473,796 Members | 2,425 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Warning when opening and Access 2000 file in Access 2003


Hi All,
We are moving to Access 2003 in a month or so, so i started testing my
data base files in v2003. When The mdb open I get 3 warning messagase
about blocking unsafe expressions.

Security Warning Unsafe excpressions are not blocked. Do you want to?
Yes/No

Security Warning Unsafe expressions are not blocked. You must have MS
jet 4.0 Service pack 8 must be installed to block unsafe expressions. Do
you want to open this file Yes/no

This file may not be safe do you want to open it Yes/No

I installed the Jet service pack and still get the warnings. What must I
do to get rid of them?

Thanks!

Kathy
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 13 '05 #1
5 4749
Set the security level to low or this will plague you forever

dixie

"kathyk" <ka***@meercat. com> wrote in message news:41******** **@127.0.0.1...

Hi All,
We are moving to Access 2003 in a month or so, so i started testing my
data base files in v2003. When The mdb open I get 3 warning messagase
about blocking unsafe expressions.

Security Warning Unsafe excpressions are not blocked. Do you want to?
Yes/No

Security Warning Unsafe expressions are not blocked. You must have MS
jet 4.0 Service pack 8 must be installed to block unsafe expressions. Do
you want to open this file Yes/no

This file may not be safe do you want to open it Yes/No

I installed the Jet service pack and still get the warnings. What must I
do to get rid of them?

Thanks!

Kathy
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Nov 13 '05 #2

Thanks, but where do i do that?
Kathy
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 13 '05 #3
Br
dixie wrote:
Set the security level to low or this will plague you forever

dixie

Unless of course you purchase a certificate to sign all your databases
with... yeah right :)
Bradley
Nov 13 '05 #4
Br
kathyk wrote:
Thanks, but where do i do that?
Kathy


I'm sure there has been posts about this before and also that Microsoft
has information in their help/web site that will tell you. Basically you
have to buy a digital certificate.. (hence my , "yeah right" sarcarsm)
:)

Bradley
Nov 13 '05 #5
Short of having to buy a certificate form a "certificat e authority" you
can also create a certificate for any "personal" projects using
selfcert.exe. It is likely already installed on your drive.

- Run selfcert.exe
- It will ask for your name
- Open the file in question
- From the menu select Tools>Macro>Vis ual Basic Editor
- Choose the current project (usually same name as your dB file)
- From the VB editor choose Tools>Digital Signature
- Select your newly created Digital Signature

You may re-use this certificate on any project on your PC. Next time
you open the file you will be prompted with the opportunity to always
trust things signed by ... yours truly ... you. From then on, all
projects you apply your signature to will be "trusted" and open without
a prompt.

Read more in the MSKB here:
http://support.microsoft.com/default...b;en-us;307731

------------------------------------------------------------
YBOTI - Your Business On The Internet - http://www.yboti.com
------------------------------------------------------------

Br@dley wrote:
kathyk wrote:
Thanks, but where do i do that?
Kathy
I'm sure there has been posts about this before and also that

Microsoft has information in their help/web site that will tell you. Basically you have to buy a digital certificate.. (hence my , "yeah right" sarcarsm) :)

Bradley


Nov 13 '05 #6

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

Similar topics

2
2335
by: Jeff | last post by:
Does anyone know of any potential problems running a 2000 database with 2003? Also, what about installing all other Office products as 2003 versions but leaving Access as 2002 running a 2000 database? Why you ask! A client has a 2000 database. Currently using 2000 runtime for most employees to work with database. A couple use 2003 to use database, no problems. They have a mix of versions of other products such as Word, Excel - 97,...
49
3239
by: Mell via AccessMonster.com | last post by:
I created databases on Access 2003 and I want to deploy them to users. My code was also done using 2003. If they have Ms Access 2000 or higher, will they be able to use these dbs with all code, etc? Please explain -- Message posted via http://www.accessmonster.com
10
6733
by: Robert | last post by:
How do you get an accurate count of the number of records returned from a query when using linked tables. I have an access 2003 database as a front end to another access 2003 database that contains only tables. I have linked the tables for the front end to the back end database. I am trying to set the recordsource of a form to a query established by the user to narrow the scope but I don't want to display the form if there are no...
3
4017
by: dan_roman | last post by:
Hi, I developed a script with a nice interface in Tkinter that allows me to edit some formulas and to generate an Excel worksheet with VBA macros within it. The script runs perfectlly in Office 2000, but in Office 2003 crash at line: "wbc = workbook.VBProject.VBComponents.Add(1)" Please help me :-( the code of the module that crash is (only in Excel 2003, in 2000 not): import os
4
6595
by: Haylee | last post by:
An 'unknown publisher' security warning appears everytime I open an ms access .mdb file, if I just click 'open' I am able to open the file, however the desktop shortcuts to this file simply won't work and I have to open the database by opening ms access first then navigating to the .mdb file. Can anyone help? I run ms access 2003.
37
3751
by: Allen Browne | last post by:
If you develop for others, you probably have multiple versions of Access installed so you can edit and create MDEs for clients in different versions. This works fine under Windows XP, even with Access 2007 installed. It does *not* work under Windows Vista Ultimate. After running Access 2007, when you open an earlier version of Access, no code works, because the references are fouled up. And Access 97 does not work at all. Access should...
0
1720
by: Ian | last post by:
Using Access 2000 I am sharing a DB over a network of 3x PC’s, this is a newly created DB with just one new table and no data. I have had problems with it not opening from several PC’s over the network, sometime with a message saying it cant find the file, other times just not opening, sometimes I get a warning message: “Security Warning, Unknown Publisher, Open Yes No”. If I create the same new DB using a different PC (still Access 2000...
10
12720
by: MLH | last post by:
Suppose, in a multi-user environment, you have append query SQL in a VBA procedure that looks like INSERT INTO MyTable... and the next line reads MyVar=DMax("","MyTable... You can never be certain that MyVar will be set to the key-field value that was created when the Append query ran. Now, there are other ways to do it - I know - that will ensure you 'nab' the correct record. But I was wondering
3
1910
by: oteng | last post by:
Can someone help me access 2000? My problem is with opening a database on other computers on a network. We have been using it for a number of years now and all of a sudden we are unable to open it on 2 computers. It said Security Warning Do you want to open this file , by clicking on open it then said This file is located outside your intranet or on an untrusted site. Cant open due to potential security problems. By coping file to my computer i...
0
10228
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
10173
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
9052
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7547
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6788
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
5441
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
5573
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4116
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
3
2925
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.