Question How can I move the new Database to a Shared Folder?

[Sarah]

Hi

I've created a database in my personal drive which is stored in a directory only accessable by my immediate colleagues.

Problem is I am about to roll this out to a sales team that do not have access to my drive (and will not be permitted access) so I need to move the database to a shared folder on the server.

Having tried this about 20 different ways, it doesn't work as it is constantly looking for the original.

I see my only alternative as starting again, and building it in the shared drive, but I am certain this is achievable in a much easier and quicker way.

To complicate matters the DB is now split.

Any ideas?

Thanks

Sarah

 

[gemma-the-husky]

when its on the shared drive, the problem is that the links are still set to the path on your own PC

open the front end, and manually do file/external/link tables and find the new backend on the server - that will sort that

a couple of issues

1. everyonre here will advise about the dangers of multiple users sharing a single database on a server.

2. with respect to the linking of files, there lots of utilities here to automate this procedure, once you understand what you are oding manually

 

[Sarah]

Both the FE & the BE are on my drive at the moment but it seems impossible to move them both without everything ceasing to work.

Fortunately I saved the DB on a memory stick and was able to re import it so everything worked again.

Should I make a copy of the FE & BE save it to the new folder (outside of it's current place) delete the original and then follow your suggestion?

Thanks

 

[Rabbie]

Use the Link Table manager to relink your Fe to the new location of the BE.

To repeat what has already been posted, You really should give each user their own copy of the FE. Otherwise you will get corruptions.

 

[gemma-the-husky]

sarah

to physically do what you are trying to do

1. copy your 2 databases to the server - windows, or via a memory stick

2. open the front end on the server, with access
if you have code that says - "the datatables isnt linked", and quits, then this is an issue - but i doubt if you do this.

so just open the front end, but your tables wont be linked

4. so now just use files/external data/link tables to change the back end.

--------
the issues about several users running a single copy of a database concurrently remain

 

[Sarah]

Thanks - All fixed now, using the Link manager.

Sarah

 

[Rabbie]

Glad to hear you have got it fixed