ms access link to dbase file while dbase is open

MS Access 2k10 would like to link to a dbf/dbt file for input into an access app, while the dbf/dbt is open to another dbase app.
I get an error that someone else has file open. If I copy the dbf/dbt to another folder and import to access all is well
jsgouldAsked:
Who is Participating?
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.

mankowitzCommented:
That is the expected behavior. If multiple people could edit a dbase file simultaneously, the data would get corrupted. If you want shared simultaneous access to the database, you will have to use dbase as the front end or upgrade to a modern rdbms like sql server or mysql which can handle multiple concurrent users.
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
jsgouldAuthor Commented:
Tks:
This is a read-only situation, there is no updating going on. I believe there is a way to do this, just don't know how.
0
Jeffrey CoachmanMIS LiasonCommented:
Read only is irrelevant.
The issue may be that multiple users cannot "access" the file.
Other options:

1. If this is for Read Only, ...then why not do this when no one else is in the DBase file?

2. What version of Access are you using?
Remember that MS has dropped support for dbase files in 2013, ...(Linking directly)
However you may still be able to create a DSN:
External Data-->ODBC-->Link-->New...

3. Do you really still need dbase functionality?
You could convert/save your DBF files to the Excel format, and then Import the Excel sheets to Access, ...and then leave them in Access...

Lets see what other Experts may post...

JeffCoachman
0
jsgouldAuthor Commented:
turns out action queries cause the issue, others are fine.
Thanks for the response
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
Microsoft Access

From novice to tech pro — start learning today.

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.