Dibatalkan

Help with access/SQL/ODBC error

First of all, I'm no developer or SQL expert, I just run the network server side and do general IT work.

My Customer (Well he's family so this is a love job!) has a MS Access .mde app that has a SQL back end that requires a SQL ODBC connector on each PC.

The developer is not sure of why this issue appears, as it's only seen when setting up a new computer (my job) and is usually able to be resolved - somehow. The problem is I don't know the exact fix and need some help.

This error has happened previously on XP with Access 2003. I'm now installing a 64bit Windows 7 PC and have tried Access 2007 and have now installed Access 2003 with no difference.

For some reason, and I'm sure its something to do with the ODBC - he gets an error as follows when opening the mde.

Security Warning: Unsafe Expressions are not blocked

Do you want to block unsafe expressions

Yes No Help

(Click No) - Then

Security warning

Opening "S:\xxx\[url removed, login to view]"

This file may not be safe if it contains code that was intended to harm your computer

Do you want to open this file or cancel the operation?

(Click Open)

The Expression On Open you entered as the event property setting produced the following error:

The expression may not result in the name of a macro, the name of a user-defined function, or [Event Procedure].

There may have been an error evaluating the function, event, or macro.

OK

Click OK - you get a blank Screen.

This error is not unique to the new Windows 7 PC and has happened previously on XP on new computers to the network.

I note normally they give no error or prompt at all when clicking the shortcut.

We have a SQL server "System DSN" that tests fine, authenticating as SA. This is the way all the working computers are configured. Once i manage to get it to work, it works fine all the time after that. Trouble is I've never actually figured out what I need to do, or have done previously that makes it work.

What am I missing?

I want someone that knows exactly what I am talking about and knows the fix!

They have to be able to explain it to me so I know what I'm missing and I can then do it myself next time!

Thanks,

Robert

Kemahiran: Microsoft Access, SQL

Lihat lebih lanjut: expression may result name macro, expression open, file may safe contains code intended, file may safe access 2003, access mde odbc, security warning unsafe expressions blocked, access security warning unsafe expressions blocked, access security warning unsafe expression blocked, access 2003 expression open entered event, why do you want this job, why do you want, what makes me unique, want microsoft app developer job, sa my name, need sql help, need sql developer, need of sql developer, my sql developer, microsoft access job, microsoft access expert help, job ms access, i love my job, expert microsoft access, app developer for my pc, odbc mde

Tentang Majikan:
( 7 ulasan ) Brisbane, Australia

ID Projek: #1535449

6 pekerja bebas membida secara purata $81 untuk pekerjaan ini

torajiv

Details in PMB Thnx

$30 AUD dalam sehari
(57 Ulasan)
5.5
manhpham

I am ready to help you...Please contact me asap.

$90 AUD dalam sehari
(10 Ulasan)
4.3
rajofficial2009

READY TO FIX IT RIGHT NOW. PLEASE POST A REPLY TO DISCUSS MORE ABOUT THIS PROJECT.

$100 AUD dalam 0 hari
(2 Ulasan)
3.3
suprja

Hi, Please read PM

$60 AUD dalam 5 hari
(1 Ulasan)
1.4
sbdragoo

With over 20 years experience with SQL Server applications including MS Access front ends to back end SQL databases, i can help you out with this issue.

$150 AUD dalam sehari
(0 Ulasan)
0.0
bipul2012

Hello Sir, Good Day, I have over 8 years experience with SQL Server applications including MS Access front ends to back end SQL databases, i can help you out with this issue. Thank You.

$55 AUD dalam 7 hari
(0 Ulasan)
0.0