MDE and Multiple users

[romio]

I want to create and mde file in order for the users not to change any thing on my design, I will be uploading the file into my server and give them the path to access:

1. 3 people (max) will be accessing the database, is that a problem or not?
2. I cant create an mde file I have to convert my db but I have read as well if I covert it to 2000 people who have lower or higher version wont be able to access it, how can I fix that?

Thanks.

 

[Mile-O]

Have you split the database into a frontend and backend yet?

 

[romio]

Have you split the database into a frontend and backend yet?

no I havent done that, do I have to do it?

 

[romio]

I have read the pros and cons of splitting the database, after splitting the database, what happens If I have to move the folder that both files are located in, I have tried moving both files and I get and error saying that ....file cannot be found, what If we decide to move the folder location or even format the server and assuming I wont remember the old path, will I lose everything?

 

[Uncle Gizmo]

>>> will I lose everything? <<<

Well I don't know who maintains your server, but it is common practice to do backups regularly. So it is unlikely that you will lose everything. As to losing the path, well you can lose the Path to anything can't you. You can lose your car keys if you forget where you put them! It's up to you to decide on the name for a folder, if you have permission to create a folder on the server and give it a name something like "companydatabase" it is unlikely that anyone else will delete such a folder, however if you are worried about this, consult your IT department.

 

[romio]

Thanks Uncle Gizmo but what I meant by the path is that lets say the file (split) is located in folder1 then after the splitting both files (split and split_be) will be in folder1, if I move both files into a subfolder folder2 and if I open the file (split) it wont work it will still remember old bath(C: /....folder1) what am saying is if this happens could I change path manually so it would find the files at the new locations.

Thanks.

 

[ScottGem]

Thanks Uncle Gizmo but what I meant by the path is that lets say the file (split) is located in folder1 then after the splitting both files (split and split_be) will be in folder1, if I move both files into a subfolder folder2 and if I open the file (split) it wont work it will still remember old bath(C: /....folder1) what am saying is if this happens could I change path manually so it would find the files at the new locations.

Thanks.

You can mainually relink the files using the Linked Table Manager. This has to be done in your MDB then recreate an MDE from it. But it would be better to use code that automatically relinks tables. You can find an example of such at www.mvps.org/access.

As to your question whether they need to be split... IMHO if an app is multi user or an app is being used by one person and developed by another, then it MUST be split. otherwise you WILL have problems with conflicts when using or maintaining.