Database Splitting

[Guest]

I have a functional database which allows the user to search, edit and add
records. However when I split the database and link the front-end directly to
the backend which sits on the company server and copy the front-end to each
users machine. The add function does not operate. The add button should open
the add form and create a new record within the table. However I am getting a
blank screen.

However when I link the frontend to the backend, held on a drive mapped to
each users machine, I do not get this problem. Please note that the drive
mapped to the server on each users machine differs therefore I cannot simply
copy the frontend over to others machines.

Can someone please advise.

 

[Guest]

The problem is you are using Drive Letter Mapping rather than UNC mapping.
It is better to use UNC mapping, because it is independant of drive letters
and can be used anywhere on the network by any user with the correct
permissions to the folder where the back end is located.
UNC mapping is using the server name and folder names rather than a drive
letter.
For example, if on your computer M: is mapped to
\\MainServer\FritzFolder\Database
and another user has the same map for R:, then if you use
\\MainServer\FritzFolder\Database instead of M:\ all users will be
correctly linked.

 

[Guest]

Hi Klatuu,

I understand that I should be UNC mapping but when I do this it creates a
problem with the ADD function as described below.

Can you advise why this may be happening.

 

[Guest]

I know of no function named ADD. Can you be more specific?
If you are able to connect to the back end without an error, then the
connection is not the problem. Can you post what code is not working?