References on a share access database

[Claudia]

Hello everyone,

I have developped an Access 2003 database which is shared on a folder in a windows server 2003.

The database has been previosly set with ULS and splitted.

The problem is that the server doesnt have MS Access installed, which is not a problem, but some users have different access versions, and the references are not working well due to the different paths they required.

Is there any way of copying in the server the shared libraries without installing access on the server.

Thank u all.

[Rabbit]

It doesn't have anything to do with where the database is stored. The users will still be opening the database using their Access that is installed on their computer. You will have to install the required libraries on each of the user's computers.

[Claudia]

Thank u Rabbit.

I think I didnt explain myself very well.

This is what I've done:

1. Set ULS security to the database, which creates the .mdw file and shortcut to the database (all of this from the server). So after this step, I had on my shared folder the database and the security file, and in the client pc the shortcut pointing to the database on the folder, security file and so on.
2. Splitting the database (which i open from the shortcut) storing the back end on the server.
3. I copy this shortcut to every user and I edit the path of the shortcut.

Until here everything works fine. The problem is that im using libraries such as Microsoft Excel 12 object library, which depending on the access version could be located in different folders.

At the end the problem I see its that the front end is also in the server, so all the clients need to have the same paths for the references.

Thank u so much for your help!

[Rabbit]

They are still using their Access applications from their computers. If you want to remap all the references in the front end to a network location, you can certainly try that.

But I doubt every reference will work just by copying the files to a network location and remapping the reference. Some might work, others might not, it depends on the reference. In those cases, you will still need to install the application on each client's computer.

[Claudia]

Thank u very much Rabbit! I got quite confused, but before changing the db to runtime mode, on each client's computer a remapped the references to their own and it is working fine.

Also, yes you are right, copying the references to the server doesnt work at all.

Just one last question. The server (windows 2003) it is shutting down quite often, I dont think is due to the database since at the end it is just a file on a shared folder, but do you think the database could have anything to do with it?

Thank so much again!

[Rabbit]

It's very doubtful it has anything to do with storing the files there.

[NeoPa]

Please don't ask separate questions in an existing thread (IE. Don't!) We don't allow it and it causes problems.

Claudia:
The server (windows 2003) it is shutting down quite often, I dont think is due to the database since at the end it is just a file on a shared folder, but do you think the database could have anything to do with it?

This question, if asked, should be asked in the Windows forum, where someone will probably start by suggesting you look at the server's Event Log for the times involved.