Network Requirements for linking to an MS Access 97 database

[Don]

Hello,

I have a Visual Basic front end for an MS Access 97
Database. I need to know what the minimum requirements
are (speed, etc) for linking to the .mdb file on a server.

Thanks,
Don

 

[Don]

John,

Great answer, this is exactly what I was looking for.

Thank you,
Don

-----Original Message-----

Hi Don,

As a general rule, LAN is OK, WAN is not, though of course speed is only
important if you're impatient!

What's absolutely vital when working with mdbs across a network is
reliability. Even on a LAN, Access/Jet is sensitive to network problems,
which can produce corrupted (though usually repairable) databases.

In practice this rules out - even if speed isn't an issue - anything
involving a telephone line or VPN across the internet. To work safely
and with realistic response times with this sort of connection you need
to move the data processing to the server end (MSDE, SQL Server,
Terminal Services, .NET, whatever).

Hello,

I have a Visual Basic front end for an MS Access 97
Database. I need to know what the minimum requirements
are (speed, etc) for linking to the .mdb file on a server.

Thanks,
Don

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.