Network Requirements for linking to an MS Access 97 database

  • Thread starter Thread starter Don
  • Start date Start date
D

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
 
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
Click to expand...

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.
Click to expand...
Click to expand...
 
Back
Top