473,379 Members | 1,379 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,379 software developers and data experts.

linking front end to back end

In the database I have, its split into front end screens and reports and
backend tables for data. Of course, this means the linked tables are
linked using the linked table wizard to the network drive mapping the server
is on.

since this database will be used by multiple people, it then means that each
user must have the same drive mapped to the same drive letter. The linked
table manager doesn't recognize UNC encoding.

The problem we run into is having so many shares available to various users
that we are running out of letters and getting everyone to use one drive is
difficult. To help that problem (and WAN traffic delays) we've opted to
run the database on a citrix server so users in multiple sites can access
the database. Once again, because of the linked tables we cannot publish
the mde file to the users desktop and instead we have to make the users log
into the citrix desktop then run the program.

I'm trying to find a "Better way". Any insight would be appreciated.
Nov 12 '05 #1
2 2693
"jayjay" <jj****@notmail.com> wrote:
In the database I have, its split into front end screens and reports and
backend tables for data. Of course, this means the linked tables are
linked using the linked table wizard to the network drive mapping the server
is on.

since this database will be used by multiple people, it then means that each
user must have the same drive mapped to the same drive letter. The linked
table manager doesn't recognize UNC encoding.
From what I've read you link with UNC names by using the Linked Table Manager by
going to the network neighbourhood and navigating from there.

See Relink Access tables from code http://www.mvps.org/access/tables/tbl0009.htm for
sample code to do it programmatically.

To help that problem (and WAN traffic delays) we've opted to
run the database on a citrix server so users in multiple sites can access
the database. Once again, because of the linked tables we cannot publish
the mde file to the users desktop and instead we have to make the users log
into the citrix desktop then run the program.


I don't quite understand the problem. Or is it that Citrix faithfully remaps all
your local drive letters to the Citrix environment?

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Nov 12 '05 #2
"jayjay" <jj****@notmail.com> wrote in message
news:c1*************@ID-87431.news.uni-berlin.de...
In the database I have, its split into front end screens and reports and
backend tables for data. Of course, this means the linked tables are
linked using the linked table wizard to the network drive mapping the server is on.

since this database will be used by multiple people, it then means that each user must have the same drive mapped to the same drive letter. The linked
table manager doesn't recognize UNC encoding.

The problem we run into is having so many shares available to various users that we are running out of letters and getting everyone to use one drive is difficult. To help that problem (and WAN traffic delays) we've opted to
run the database on a citrix server so users in multiple sites can access
the database. Once again, because of the linked tables we cannot publish
the mde file to the users desktop and instead we have to make the users log into the citrix desktop then run the program.

I'm trying to find a "Better way". Any insight would be appreciated.


Using a common mapped drive is a good idea in my book (perhaps you should be
using more sub-folder under a drive and not creating new drives for
everything??).

You can write some very simple code to allow the user to select the location
of your data file and then refresh the link information for the tables. Some
of our routines even allow the user to select what backend they are linking
to (Access, MSSQL via ODBC, etc) and just builds the linked table's
connection string.
--
Bradley
Software Developer www.hrsystems.com.au
A Christian Response www.pastornet.net.au/response
Nov 12 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Jeff Pritchard | last post by:
Some time ago I am sure I came across something that said this was possible, though it doesn't seem to work. A client wants to replace an Access back-end with SQL Server tables. We have tried...
14
by: diskoduro | last post by:
Hi!! Years ago I built a database to control the production of a little factory. The users wanted to work in a Windows Net workgroup so I created an mdb with all the tables and data an after...
3
by: Tym | last post by:
OK - daft question of the day time... If I have database A which contains all the live data, and Database B which contains linked tables to those is A (i.e. a front end) is there a way of seeing...
6
by: news.dsl.pipex.com | last post by:
Hi I have a front/back end scenario for my access app. I need to allow user to connect the front end to one of two back ends at start time. Presumably this needs linking to the relevant back end...
3
by: patcho | last post by:
Hello, I have a problem that I was hoping to get some assistance with. I have built a split database (back end with all the tables and a password to protect the information & a front end to link...
2
by: Matthew Wells | last post by:
Good morning... I have an Access front end that uses SQL Server linked tables. SQL Server uses Windows authentication. I have one Windows group that all Access users are a member of. I added...
2
by: Mike MacSween | last post by:
My clients are replacing their file server. Their application is the standard FE on each workstation, BE on the server. The transition to the new server may or may not go smoothly. At the moment...
1
by: deiopajw | last post by:
I have a Back end database on a network drive. The copies of the front end are located on individual pc's (in their C drive). The problem arises when a laptop user naturally hooks up to the...
1
by: TMacD | last post by:
This is my first project linking an MS Access (2003) front end to a MySQL back end. I've created and populated several tables in the MySQL database. I can read/write all of them except one from my...
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...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

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.