kidrobot: Yes, E: is on the network

hello,
I have an external hard drive "E:" on computer A. I split the database in this hard drive. I installed the front end on the Desktop of all the rest of the computers. How do I link the front end to the back end because it's giving me an error saying that the path to the be file is incorrect in each one of them. I am using the ACCESS 2007 runtime version on each computer except computer A where "E:" is.

thank you

Well is the E drive on the network? They need visibility on the BE.

I recommend you reply instead of editing the original post. This helps other if they have the same problem.

Your tables are linked to the FE right?

The only thing I did is to split the database and 2 files appeared:
"database" and "database_be". I took "database" (which I am assuming is the fe) and installed it into the other computers and it gives me that error. Sorry, I have never done this before so I'm very lost, I don't really know if the tables are linked to fe. How do I find this out, and if they are not, how do I link them.

thank you

What is the exact error?

The message is:

'E:\database_be.accdb' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server to which the file resides.

what is .accdb? shouldn't it be .mdb?

The FE has no visiblity on the BE so check the file path

it should be the ".mde" of ACCESS 2007 which is what I'm using. The tables are linked to the fe.

no clue, maybe someone else can help. It should work, maybe try split up the db again or manually link the tables yourself and export all of the objects.

Actually, it's probably because your other users don't have "E:" mapped the same. To avoid that issue, you can put the UNC path in the Linked Table Manager to select the UNC. You can either navigate by getting to the server via Network and following that path in windows explorer. Or you can use this method:

http://downloads.btlarson.com/AWF/screenshots/UNC/01UNC.png

http://downloads.btlarson.com/AWF/screenshots/UNC/02UNC.png

hello,

Now the path is recognized, so that part is working. Now when the file is open from another computer X and I click on a button on the startup form, it says that there's a run time error. When clicking on this button the program is supposed to update some tables on the back end (remember that the be file is on my external disk E on the main computer). The error tells me that it could be that the database is "read-only". How can I configure the database so that it is NOT "read-only", it can be shared

This is the possible cause of the problem:

The database is read-only for one of the following reasons:

The database file has been defined as read-only in your network operating system.
In a network environment, you do not have write privileges for the database file.


Thank you very much