Accessing a database on a network. 1

[daverkennedy]

Hi all,

I still consider myself a newbie and I have quite an ambitious project to undertake.

I wish to create an application that sits locally on a pc and can view and update data in an Access database located on a network drive.

The database must be accessed by multiple users on multiple machines on the network, not necessarily at the same time.

Im not looking for answers as that takes the fun out, but I would appreciate a gentle nudge in the right direction in what I would need to setup and account for.

thanks.

 

[BlackDice]

have a look at a project I did and submitted on codeproject.com - it uses ADO to access a SQL Server database, but you could still do the same thing with Access (just change the syntax of the connection string). Here's the address:

http://www.codeproject.com/tools/bugreporter.asp

BlackDice

http://www.stillwaterexpress.com

 

[daverkennedy]

Thanks so much.

I got a copy of your project last week... it took me a while to get my head round what was happening in the code but now I am well underway in my project.

 

[BlackDice]

glad I could help!

BlackDice

http://www.stillwaterexpress.com