By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,686 Members | 2,708 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,686 IT Pros & Developers. It's quick & easy.

Remote Desktop Connection

P: n/a
Hi guys

I have a Frontend and Backend DB that works well on my LAN. I use a
INI file Path, to access a mapped network connection back to the
Backend Data file.

[DBInfo]
Path=F:\Server\Data.mdb

I have a situation now that requires a Remote Connection with my
Program.

A remote client is using a notebook (XP Pro) with a Wireless
Broadband, with the frontend running on his notebook.

The Server is MS Server 2003 with Terminal Services.

I need help with these issues!

1/ To setup a Remote Mapped Network Connection from the Remote
Notebook (using Remote Desktop Connection) to the Server (using
Terminal Services) Backend Data File.

2/ To Edit the INI File so the Frontend finds the Backend when the
Remote User opens the Frontend.

Any help on these matters will be greatly appreciated!

Thanks for your time and effort!!!!

Chris

Mar 25 '08 #1
Share this Question
Share on Google+
4 Replies


P: n/a
Hi Tom

Thank you for your help!

The Server is just a MS Server 2003, not a SQL Server and the data
file on the Server is just a mdb Data File (Tables Only).

Thanks for the connection site, but that isn't the problem. The issue
I need help with is the (Remote Mapped Network Drive) for the Remote
Notebook Frontend connection string!

Any suggestions with, Terminals Services, VPN, RDC or something else?

Thanks again!!

Chris
Mar 27 '08 #2

P: n/a
On Thu, 27 Mar 2008 16:12:27 -0700 (PDT), ch***@kissolutions.net
wrote:

So I understand that the back-end is an Access MDB sitting somewhere
on a remote server, not on your LAN. You can build a RDC connection to
it, but you need to know how to connect your front-end to that
back-end.

The answer is that you can't in this configuration. Rather you'd want
to put your front-end on that server as well, and then connect to it
via RDC. That's pretty much indistinguishable from Terminal Services.
VPN is not a good solution because connecting to the back-end over a
VPN connection which uses the public Internet will experience
momentary hiccups of service, and a real potential of database
corruption.

-Tom.
>Hi Tom

Thank you for your help!

The Server is just a MS Server 2003, not a SQL Server and the data
file on the Server is just a mdb Data File (Tables Only).

Thanks for the connection site, but that isn't the problem. The issue
I need help with is the (Remote Mapped Network Drive) for the Remote
Notebook Frontend connection string!

Any suggestions with, Terminals Services, VPN, RDC or something else?

Thanks again!!

Chris
Mar 28 '08 #3

P: n/a
While I worked at Boeing Aircraft We were told to use UNC paths not mapped
paths. Also you can have a relink utility that will process when your app
cannot connect to the backend. Let me know if you need one I have one
<ch***@kissolutions.netwrote in message
news:6b**********************************@m34g2000 hsc.googlegroups.com...
Hi guys

I have a Frontend and Backend DB that works well on my LAN. I use a
INI file Path, to access a mapped network connection back to the
Backend Data file.

[DBInfo]
Path=F:\Server\Data.mdb

I have a situation now that requires a Remote Connection with my
Program.

A remote client is using a notebook (XP Pro) with a Wireless
Broadband, with the frontend running on his notebook.

The Server is MS Server 2003 with Terminal Services.

I need help with these issues!

1/ To setup a Remote Mapped Network Connection from the Remote
Notebook (using Remote Desktop Connection) to the Server (using
Terminal Services) Backend Data File.

2/ To Edit the INI File so the Frontend finds the Backend when the
Remote User opens the Frontend.

Any help on these matters will be greatly appreciated!

Thanks for your time and effort!!!!

Chris

Mar 29 '08 #4

P: n/a
On Fri, 28 Mar 2008 20:27:16 -0700, "lawoolybear"
<la*********@wavecable.comwrote:

Any of those databases running inside of an aircraft? I'll row to the
Netherlands next time I visit the family :-)

-Tom.

>While I worked at Boeing Aircraft We were told to use UNC paths not mapped
paths. Also you can have a relink utility that will process when your app
cannot connect to the backend. Let me know if you need one I have one
<clip>
Mar 29 '08 #5

This discussion thread is closed

Replies have been disabled for this discussion.