split database problems with Access Runtime

[maud138]

I use a split database on a server with Microsoft Access Runtime 2010.
The database works perfect on my laptop with Microsoft Access 2010 fullversion, but on the server it gives some problems.
The database is suddenly very slow and keeps "calculating" (that's what it says in the left lower corner).

I've copied the front end and back end from the server to my laptop and it works fine.
Is there a problem with Access Runtime and split databases?

It does save the data. So I can still use it, but it's annoyingly slow.

Any ideas?

 

[Mr. B]

If I understand you correctly, you have the front-end file on the server and are attempting to run your application from the server and the back-end file is also on the server.

The whole concept with splitting the database is to have the back-end on a shared drive or location like a server, but to have the front-end located on your computer, not on the server.

You should have the front-end on your computer with it linked to the back-end database on the server.

Hope this helps.

 

[maud138]

Hi Mr. B

It's a server with a part for all users and seperate parts for each user individual. The back-end is on the part for all users and the front-ends on the different parts for each user.
But I don't think that's the problem. The problem is that it keeps "calculating" when I use the database on the server, but it works fine on my development-computer.

 

[maud138]

Re-installing Access Runtime did the trick. Everything works again.