Yet Another Untrusted Intranet Problem

Feb 22, 2008

Hi All

I've Googled my problem and read a dozen of posts on this site but I still have not resolved my problem. Since there appear to be lots of people with the same issue maybe one of you kind people can help me go through this task by task.

I have split my Access Db into a Front End (FE) and Back End (BE), thanks to Rural Guy for helping out with that some months ago. The FE resides on my Desktop PC and the BE on my laptop. They are connected via cable through a router on my local network.


FE PC
-----
Access 2002 SP3
Windows XPPro SP2
IE7.0.5730.11

BE Laptop
---------
Access 2007
Windows XPPro
IE7.0.5730.11


When I try to link my FE to the tables on the BE, I get the all too familar:-

"The file is located outside your intranet or on an untrusted site" etc etc


Here's what I've checked so far.

1. Done A TRACERT to my make sure my Laptop (BE) is on my local network. It only took 1 hop so nothing's routed outside

2. Checked the IE Options (security) on my Desktop (FE) PC to verify that the IP address of my Laptop is in the Local Intranet zones.

3. Checked the IE Options (security) on my Desktop (FE) PC to verify that the IP address of my Laptop is in the Trusted Sites (both http and https)

4. Set the IE Options (security) on my Desktop (FE) PC for both Local Intranet and Trusted Sites to LOW.

5. Checked that from my FE Desktop I can read, write and modify (documents) on the Laptop share in which the BE resides.

6. Checked the Properties box for my BE .mdb to see if there is a UNBLOCK tick box. It does not have one.

7. Checked that EVERYONE has Full Control, Change and Read permissions on the BE folder and it's parent folder.

This error also happened when my Laptop only had Access 2002 too so I don;t think it's a mis-match of the Access versions.


Hmmm... I've run out of ideas now.

As always, any help gratefully accepted....

Thanks

View Replies


ADVERTISEMENT

Untrusted Site

Nov 25, 2007

I am working on a laptop computer running MS Access version 2002. I'm trying to access a data file located on my desktop computer via my wireless network. (Same version of Access).

I can see the file without any problems, but when I try to open it I just get the following error message:

this file is located outside your Intranet or on an untrusted site. Microsoft Access cannot open this file.

Both computers are running under Windows XP. O/S: MS Windows 5.1 service pack 2

How do I resolve this?

View 3 Replies View Related

Forms And The Intranet

Jul 18, 2007

My database uses forms to specify various criteria for queries and then to run reports based on these queries. It has been suggested that other areas of my company might like to share my reports etc.
So I have been given a brief of finding the most cost effective way of sharing my DB.
Seperate access full installs with rights to my DB and access run time are being considered bu I have thought about our intranet.

This leaves ASP conversion or data access pages. Can either of these be used for forms of this type ?

Thanks

View 3 Replies View Related

Access And Intranet

Oct 11, 2005

I am thinking of putting my access database on a server and work with html files. I have heard about .asp.

Do I need programming knowledge and is there some good web site where I can learn how to convert my database and create html pages that can access my database?

View 3 Replies View Related

Data Connection On Intranet ....Serious Issue..... Please Help

Apr 9, 2008

I have access database created in my desktop, which has tables, queries and DAP's....... everthing works fine on my desktop.

But when i take whole project to my intranet shared folder, it doesnot get connected to database (even though i change the connection).

I get the fallowing errors.

Error1
Microsoft Office Access is unable to connect to the data source specified in the connection string of this page.
The server may not exist on the network, or there may be an error in the connection string information for this page.

Error2
Cannot find the database or some database objects that this page refers to. Update the connection information of the page, or fix the references to the missing database objects.

Please...... help...... it's urgent..... any help would be appreciated.

View 2 Replies View Related

Limitations Of Using Access With Multiple Users On Intranet

Mar 24, 2006

Hi,

I would like to use an Access database over an Intranet. What are the limitations of doing this? I want multiple individuals to be able to open forms and enter data. I would also want others to be able to run queries and reports on the database. Would I need to upsize to an Oracle database to run with multiple users? Any words of wisdom would be appreciated.

View 4 Replies View Related

General :: Backend Path Syntax In Intranet

Aug 20, 2013

I have splited the system into foreend (FE) and backend (BE). FE and BE are located in different PC lying in company internat! However, I found there always give an error message 3219. And, nseems it is caused by not pointing correcly to the BE when I open tables, the syntax are as follows

Dim db As Database
Dim rs As Recordset
Set db = CurrentDb()
Set rs = db.OpenRecordset("Invoiceyr", dbOpenTable)
rs.MoveFirst
rs.Edit
Me.THISYR = rs!Invoiceyr

The 3219 error appeared at statement "Set rs = "what's the syntax of the path that I should include in the statement in order to point correctly the BE.

View 9 Replies View Related

General :: How To Share Access Database On Company Intranet

Jan 14, 2015

I want to consider ways of sharing an Access database within our company. This could be web-based via our intranet or done some other way.

I understand that Microsoft's preferred way of sharing via an Intranet is to use SharePoint. However, as we don't use SharePoint (we use Atlassian Confluence) the cost of that route would be prohibitive.

Any methods of sharing an Access database across, say, 20 people? Simultaneous read/write access would be required but in reality the usage will be low, so performance is not really an issue. I would like to consider web-based or other methods.

I have chosen Access 2013 simply because we use Office Professional 2013 and Access will be familiar to some developers. We could use a different product. But I would certainly prefer a tool that supports RAD design of forms.

View 1 Replies View Related

Link Access Form To A Table Stoed On An Intranet Site

May 24, 2006

Dear all,

Does anyone know if ti is possible to link an access table to one stored on an intranet site? This is used for logging help desk calls and various locations need to look at it at the same time.

I have tried it and seems to work but I get a "Not a valid file name" message

thanks for looking

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved