Split it up, now its not working?

[BT24]

Hello

Please can someone help me...I have a database and i never thought that it would be growing so fast, and i recently tried to split it and now no one but myself can get onto it. The backend is on the network and the frontend is also on the network but each computer has a short-cut to the frontend. I am getting to types of errors one is network error and the other is that it cannot find the backend. I have no idea what i should do. Thanks for whatever help you can give me

BT24

 

[hjgoldstein]

I would say that the first thing to do is to get the users back using the db. Do this by copying all of the front-end objects (forms, queries, modules, reports etc.) to the back-end so they will have a working version.

Next, try splitting a copy of the database but leave the front-end in the same location as the back end.

If this works, great. It can cut down on network traffic for a start.

If you like, try it with distributed copies of the front-end, on each user's PC or home folder.

The network path for the linked tables in the back-end should be \\server\path\database_be.mdb - NOT f:\path\database_be.mdb as this may be the cause of your original problem.

This can be checked by using the linked table manager in the master copy of the front-end after you have done the split.

Good luck.

 

[BT24]

Thanks for the responce....I had to go back and bring all data back in. I wonder if it could be that the backend is in \\Ykr-fs1\Trans_Works\TW_Water_Wastewater\Works\W00 - Works General\TruckDB\OICDatabase.mdb" and so far back. would this have any baring on it. Also should i split the original and not from a shortcut? i really appriciate the help. thanks again.

BT24

 

[GDGarth]

If the users have their drives mapped to different letters, they won't be able to find the back end.

Make sure all your users have the back end drive mapped to the same letter.

 

[hjgoldstein]

I don't think that the path you are using is a problem. Try leaving the front-end in the same folder as the back-end and create a desktop shortcut for users to that. It should be OK. When you split the database using the database splitter (Tools > Database Utilities > Database Splitter) the front-end will automatically be created in the same folder as the back-end so you should have no problem.

As GDGarth says, the use of drive specifications (F: etc) can cause a problem so if you use the UNC path (\\server\path\filename) you will avoid this possible pitfall.

Hope this helps.

 

[BT24]

Thanks alot for the responce's....I will try out your suggestions. have a nice day!

BT24