Split Database Record Locking

[Bob Fenton]

I am currently using access 2003. The database resides on a server with
access thru a VPN connection on DSL. I split the database using the split
wizard trying to improve performance and ran the front end from my PC. The
performance was much worse then running totally from the server. I aslo had
a 'record set not updateable' problem which would not allow multiple users to
access the data in update mode. This is the 1st time I have tried to use a
split database. Any help or ideas would be appreciated.

Thanks
Bob F

 

[Pat Hartman]

I doubt that performance of a client/server application will ever be really
acceptable over VPN. You just don't have the bandwidth that a LAN has. My
clients with multiple offices and other remote users, use Citrix or terminal
services to run Access and WinForms applications. Since with these two
applications, the client app actually runs on the server, performance can
even be better than being on the LAN itself. All that gets sent to the
remote user is "pictures" of the server session. No data needs to traverse
the internet. With client/server on the LAN, data needs to get from the
server to the client PC but with Citrix and terminal services, the client
and server machines can be the same so performance is more like a split
database with both pieces running on your C: drive.

 

[Bob Fenton]

Pat thanks for the response, I will pass the info on to the server
administrator. Does anyone have any thoughts on the fact that when I split
the database it became a single user database rather then multi user? I
check the database and folder settings and they indicated a shared
environment.

Bob Fenton

 

[Pat Hartman]

Splitting the database doesn't cause it to become single-user. Verify
network permissions and also make sure that no one is opening the database
in exclusive mode.