Problem linking an access database to tables on another PC in my network.

I'm trying to link an access database to tables on another PC in my network.

The network is all Homegroup.  I am an administrator, there is no password on either machine, and the folder on the target machine is shared.

Any advice?

Thanks in advance
Clive BeatonAccess DeveloperAsked:
Who is Participating?
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Connect With a Mentor Infotrakker SoftwareCommented:
Then something's wrong with the Share. Try unsharing it, reboot the machine, and share it again.

Are you an Administrator on your machine, or on the network. If you're a Local Admin (i.e. the admin of your machine), then your permissions wouldn't really have an impact on resources not on your machine. Once you get "off" your machine, you have the permissions as assigned by the various resources.
0
 
lion73Commented:
what error appear to you
0
 
Clive BeatonAccess DeveloperAuthor Commented:
Don't have permission.
0
Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Try to run the Access as Administrator (right-click on the .mdb file and choose the option "run as administrator").
0
 
Clive BeatonAccess DeveloperAuthor Commented:
Right-click on the accdb file didn't give me the option to run as administrator.  I ran Access as administrator and opened the app but that had no effect either.
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
If you don't have permission on that folder, then you don't have permission. Either grant permissions to your specific user (if you're the only one who needs it), or grant permission to a Group of which you're a part.

That said - can you show us the actual error message you get when you try to connect?
0
 
Clive BeatonAccess DeveloperAuthor Commented:
Error message attached.
Cannot-access-crb-pc.JPG
0
 
Clive BeatonAccess DeveloperAuthor Commented:
That worked.  Thank you very much.
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Yeah, it looks like the user it's only local administrator so needs to have permissions set for his user in the network share.
0
 
lion73Commented:
change shared folder permission with read and write for everyone
0
 
Clive BeatonAccess DeveloperAuthor Commented:
Lion73: Did that.  Good suggestion.
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Actually, in order to work with an Access database, you'd need Read/Write/Create/Destroy permissions on the folder. The simplest way to determine if you have those permissions is to try and create a Text file in the folder, edit it, and then delete it. If you can do all those things, you have the necessary permissions.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.