MDB made on one pc to be used on another.

N

Noel S Pamfree

I have this real problem!

A friend needs a database with a lot of addresses etc in and gave me their
information in an Excel worksheet.

I imported the data and made an Access database here at home, editing it as
I went along. It works fine here (Access 2003 and set to default to make a
database in 2002-3).

I emailed it to them and they saved the attachment in their own database
directory, but when they try to open it they get the message:

'This file is located outside your intranet or on an untrusted site.
Microsoft Access will not open the file due to potential security problems.'

I tried a work around by uploading the file to my website and getting them
to download it from there after telling them to:

1.In Internet Explorer, click Tools, and then click Internet Options.
2.On the Security tab, click Local intranet, and then click Sites.
3.Click Advanced, and then type: (my IP address was here) in the Add this
Web site to
the zone box.
4.Click Add, click OK, click OK, and then click OK again to close the
Internet Options dialog box.
5.Restart the computer.

Needless to say it still doesn't work.

How can I make a database made on my pc open on another person's pc?

Thanks in advance for any help?

Noel
 
J

Jeff Boyce

Noel

The part of the message about "file... located ..." suggests that when they
try to use what you sent, it tries to find a file that is NOT what you sent.

Is there a chance you sent a shortcut that points to the file on YOUR
computer?

Is there a chance you sent a front-end, which links to back-end tables
located on YOUR computer?

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/
 
L

Lystig

Hi,

I've had the same experience. Mailed an .adp-file to a customer. He got the
described errormessage. Then I zipped the file and sent it to him. He
unpacked and got the same errormessage.
Then I burned it on a CD and mailed it. He copied it onto his PC. It worked
fine. All three files are from the same .adp-file which had not been opened
between the various 'shipments'

I think it is some misunderstood safety precaution - but I cannot gather if
it is the mailsystem, Windows or Access.

/Stig
 
N

Noel S Pamfree

Thanks for the reply.

I did actually send a mdb file made on my desktop. I checked by sending it
to myself and downloading it onto my laptop and it worked fine.

Noel
 
N

Noel S Pamfree

Hi,

I have copied it onto a memory stick and I will call over there and see if
that works.

I also uploaded the file to my website and got them to download it from
there but with the same result and error message.

Pity -I hoped being able to email files as attachments would save a 30 mile
round journey!

Noel
 
J

Jeff Boyce

Noel

I regularly exchange zipped .mdb files with a customer 3,000 miles away.
Before you get on the road, see if there's something else this newsgroup can
offer...

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
N

Noel S Pamfree

Hi,

I tried sending a zipped up mdb file but when we tried opening it on the
distant machine Windows XP wouldn't allow the unzipped file to be opened as
it thought it might contain a virus. I set the security to the Lowest level
but it still wouldn't open it.

I took a copy on my memory stick and copied it on to the machine and it
opened in Access immediately - no problem.

It really is a mystery why it will accept it from my machine on a memory
stick but not via the Internet!

Noel
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top