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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

lion73Commented:
what error appear to you
0
Clive BeatonAccess DeveloperAuthor Commented:
Don't have permission.
0
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
Powerful Yet Easy-to-Use Network Monitoring

Identify excessive bandwidth utilization or unexpected application traffic with SolarWinds Bandwidth Analyzer Pack.

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
Scott McDaniel (Microsoft Access MVP - EE MVE )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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Databases

From novice to tech pro — start learning today.