General discussion


Multiuser Access 97 Database problem

By anonymous1510 ·

I have a multiuser access 97 database that is stored on a server and accessed through the network by different users.

I can successfully execute several queries on my machine under both my profile and the administrator profile.

However on the other machines that access the database the exact same queries are giving a run-time error "2427" saying that I have entered an expression that has no value. This happens under the user's profile, my profile and even the administrator profile.

All references are the same and I've even tried redoing one of the machines so that it's the same as mine and I'm still getting the same problem.

The MDACs are the same on the machines as well.

Does anyone have any suggestions? Any help would be greatly appreciated.

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

thats a common problem.

by WilliamSanders In reply to Multiuser Access 97 Datab ...

BANG - you've hit the wall.
A more commonly suggested 'fix' is to use a real database system, such as Visual FoxPro.

ACCESS, according to MS, is an end-user database for casual use. If you want to rely on something that is rock solid , with no client-license access fees [er - you have to pay for one each time, usually coming across for ACCESS in the MS-OFFICE package] then get a vfp developer and change your 'database' ...

enjoy! [Bill]

Collapse -

MSDE is the better choice

by ahar In reply to Multiuser Access 97 Datab ...

MSDE is a small, free MSSQL-Server with some limitations. Give it a try!

Collapse -

Access is too slow

by ma407 In reply to MSDE is the better choice

One Access program is too slow to be used by multi users.

Put a copy of access on each computer and use replication.

If that is not good enough use the client-server model...sql server.

I believe that running MySQL with Apache and PHP is a better solution than ACCESS. PHP can be learned very easily, and you can reuse 99% of the code out there.

go for it.

Back to Software Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums