473,322 Members | 1,911 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Remote Desktop Connection

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
4 5284
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
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
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Elp | last post by:
Hi, I have developped a Windows applcation (in C#) that allows, among other things, users to view and control the desktop of a remote Windows XP Pro machine. I have actually simply embedded the...
1
by: vighnesh | last post by:
Hi All I am dealing a project in ASP.NET in which I have to establish a connection to SQL Server 2000 database,where the database was located on a remote system. For this I have used...
1
by: anonieko | last post by:
Problem When Remote Desktop to my main office machine, and when trying to connect to SQL Express, I was becoming increasingly frustrated with the following error: Error: 'Failed to generate a...
8
by: trullock | last post by:
Hi, Is there a way to launch an remote desktop connection to a specified server/username from c#? If there's a way to send the password too that would be useful, but i'm not so interested in...
15
by: =?Utf-8?B?TVNU?= | last post by:
To demonstrate my problem, I have a very simple VB Windows application. It has a text box that is used to display a counter, a button to reset the counter, and a timer that increments the counter...
3
by: mac420 | last post by:
I want to implement remote desktop connection in C#.net same as Program->Accessories->Communications->Remote Desktop Connection can anybody plz help me Thanx in advance
2
by: CLM | last post by:
When I test the remote access at work (lapttop computer to desk top computer) the connection works fine. When I bring the laptop home and try to connect to my desktop I get the error msg: The...
12
by: sakthikumarb | last post by:
Hi , I need to monitor for Remote desktop connection is made for a particular host. There is any WMI event ?.if not how can monitor for remote desktop connection.. (Basically i need to generate...
0
by: Andy | last post by:
Hello all, I have a user using Remote Desktop connection, who is getting an error when trying to print. When my program starts, he get's an error 2205, the default printer isn't set up...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.