Copying & connecting Front End MDB

[Guest]

I have a database based on server, I mean my BackEnd Database in on server
and Front End in on Server as well as on all Workstations. It was working
fine.

Due to problem in one of the PC, I had to format the Pc hardDisk. Now I am
little confused for the query below :

1. Can I copy the FrontEnd mdb from any of the workstation to this PC
(formated PC).
But how it will recognize that its BackEnd is connected to the server.

2. Or I should copy the Front End from the Server PC.

3. Or any method to make the mapping again of mdb to get data from Back End.

4. What can be the possible problem and its remedy.

Please advise.

Regards.

Irshad .

 

[Brendan Reynolds]

If you are using UNC paths, e.g. "\\ServerName\ShareName\FileName.mdb",
there should be no problem, just copy the file. The path points to the same
data file, regardless of which client PC on the network the application is
installed on.

If you are using mapped drive letters, e.g. "z:\FileName.mdb", then there
should be no problem if all PCs have the same drive-letter mapped to the
same network share.

If necessary, you can programmatically re-link the tables using the code at
the following URL ...

http://www.mvps.org/access/tables/tbl0009.htm

 

[Albert D.Kallal]

You should be able to copy any front end mdb from any of the pc's.

However, you seem to hint that you have the front end on the serer also, and
this is not correct.
(you can certainly have a copy sitting on the sever, but you don't allow
users to run that copy ON the server. To use, and run ms-access in a
multi-user mode, you need EACH workstation to have that front end).

Since that front end is already linked to the back end, then should not
matter if you copy the front end from any other pc in the office, or the
front end copy sitting on the server. I mean, once the front end is
correctly linked to the back end, then it don't matter where you copy the
front end, or from which pc, as it will still remain linked to the back end.

If you find this concept confusing, I have a article that explains in depth
as to why you split, why you install on each pc, and also how linking works.

you can read it here:

http://www.members.shaw.ca/AlbertKallal/Articles/split/index.htm