how is it possible to do access system connect with remotely access database by creating DNS

I have access desktop system application and running on my local machine   .where the access front (Desktop screens) and backed (Access Database ) is in same directory.
 Now I want to place the access database on the remotely server and desktop connect with this remotely access database .
 Is it possible to connect access Desktop system with access remotely database by create DNS same as we Normally do with web applications . I have no idea about this .Please share with your opinions and guide me if is it possible and how it will work or done ?.

actually my main object of doing this is that i want to sync data from web application to access Desktop system.

Thanks in Advance!
kausar aliweb 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.

Martin MillerCTOCommented:
Your short list of TO-DO...

  • Remote install of DB, and gather machine info: Ip address, domain/DNS name, DB access credentials
  • On Web/User facing machine, you will need to configure for this new machine and DB
  • Confirm you have open network path, same subnet or clear routing path
  • Test your connection, and start debugging

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
PatHartmanCommented:
If the BE is ACE or Jet, you do not use a DSN to connect to it.  Use the linked tables manager to change the links to the server database.

If you think you can access a BE that is not on your LAN, you can but don't expect the app to be functional.  It will be so slow you can watch the screen paint.  An Azure BE would be better but probably still too slow to be usable.  Access works fine on a LAN but the internet is simply too slow.  Even the fastest internet connection is probably less than 10% of the speed of an average LAN.
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
Is it possible to connect access Desktop system with access remotely database by create DNS same as we Normally do with web applications .

  Yes.    You can create a DSN, and then reference that in Access as an ODBC data source, or you can write a connection string directly in Access.

 Since you seem to be new to the Access side, I would setup a DSN, test that it's working, then link to the database in Access using that DSN.

  Make sure it's a system DSN, and that you use the correct ODBC admin applet.   If your using 32 bit Access, then you need to use the one in the C:\Windows\SysWOW64 folder.   If 64 bit Access, then you can use the one in the control panel (which points to the version in C:\Windows\System32).

  After that, you could convert to a "DSN-less" connection if you want to.

Jim.
10 Tips to Protect Your Business from Ransomware

Did you know that ransomware is the most widespread, destructive malware in the world today? It accounts for 39% of all security breaches, with ransomware gangsters projected to make $11.5B in profits from online extortion by 2019.

PatHartmanCommented:
and backed (Access Database ) is in same directory.
Jim, have you tried that?  This is the error.
ODBCError.JPG
Jet/ACE are native to Access so Access does not use ODBC to connect to them.  OTHER applications such as VB.net use ODBC to connect to Jet/ACE.
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
I took it to mean something other than JET because of "remotely" and the reference to web apps.     Obviously If it's JET/ACE, then as you said, you'd simply link to it.

 Re-reading, I see now:

Now I want to place the access database on the remotely server and desktop connect with this remotely access database

 But that raises the other issue; if this over a WAN, that is not going to work, as JET/ACE DB's can only work on a local LAN (or a very high end WAN).

Jim.
PatHartmanCommented:
I did mention that when I responded earlier.
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
Guess I should have taken more time to read everything through more carefully.  Sorry.

Jim.
Martin MillerCTOCommented:
Can we close this question?
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
Remote Access

From novice to tech pro — start learning today.