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?
 
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
0
 
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.
0
 
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.
0
How do you know if your security is working?

Protecting your business doesn’t have to mean sifting through endless alerts and notifications. With WatchGuard Total Security Suite, you can feel confident that your business is secure, meaning you can get back to the things that have been sitting on your to-do list.

 
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.
0
 
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.
0
 
PatHartmanCommented:
I did mention that when I responded earlier.
0
 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
Guess I should have taken more time to read everything through more carefully.  Sorry.

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