Accessing a database over a LAN

[omarswan]

Hi,
I have a LAN that uses a Windows NT Server. If I'm on a Client machine, how can I get full access to a MS Access Database that is stored on the NT Server so that I can do things such as ADD, Edit and Delete Record? The Clent machines are Windows 9x.

P.S. Using ADO

Could someone guide me steps that I need to do to accomplish this.

[Edited by omarswan on 05-22-2000 at 11:55 PM]

[Toot]

Well it should be easy but 95 -> NTs tends to be quite tricky (to the point of not working????) Basically whoever logs into "Windows Networking" on the 95 machine needs to have *the same* username created on the NT domain and the Workgroup on the 95 machine needs to be the same as the domain name on the NT server.
Then create a share on the NT server with the user/group of the 95 user(s) given full access (no pw).
If you're using ODBC, it usually works best to map a network drive to the database directory and use that when specifying the DSN Target. Also you can better see where any problems lie - if you can create/change/delete files in the network directory you should be able to do all the DB functions.

That's only a start - 95/NT interoperability is a complete minefield!

HTH,
Toot