how to make my new vb6 project run in network

[sekhargo]

Hi everyone at codeguru

I am verymuch new to programming and could do my first project in vb6 with access db. How can I make this run in network? can somebody help me.

Thanks in advance

SEKHAR

[DataMiser]

You'll have to be more specific. What do you mean by run in network? What problem are you having?

[sekhargo]

Thanks for responding. As I said I am very new to programming. I had developed a vb6 form based application with access db. this application runs well on a stand alone machine. If I have to make it run on lan where multiple users can use the application how would I make it? This is precisely the issue on which I need your help please.

Thanks in advance

SEKHAR

[GremlinSA]

a few issues here:

#1) Access does not like multiple connections to a single database.. Multiple write's WILL corrupt the DB...

#2) Most applications will run from a networked drive as long as the runtime files are on the PC.

Have you tried to run it from the networked drive yet? Has it given you any specific problems??

[TechGnome]

the short answer is that all you need to do is simply put the Access database on a shared folder on the network that everyone has read/write access to... then change the connection string to point to the new location.

That's the short answer. The longer one echoes the warning by Gremlin regarding corrupt data... Despite what people say, when you have multiple users in an Access database at the same time, it's not a matter of IF the database will become corrupt, it's a matter of WHEN. The more users you have, the faster it will happen.

-tg

[sekhargo]

Thanks TechGnome and Gremlin. I will now place the database on a different pc and try. What is a better alternative to access for a beginner like me please.

[GremlinSA]

MS SQL Express is ideal for your situation, AND it's free... also it does not need office or MDAC loaded on target machine.. Its the Multi user Server database app version of Access..

SQL Express 2008 Download - then you'll need the SQL Management studio to physically work with a Database, You app will not need this to connect..

You can also import the Access DB direct into SQL..

Another issue here is that SQL is not limited to the 2G file size that Access has...

[sekhargo]

MS SQL Express is ideal for your situation, AND it's free... also it does not need office or MDAC loaded on target machine.. Its the Multi user Server database app version of Access..

SQL Express 2008 Download - then you'll need the SQL Management studio to physically work with a Database, You app will not need this to connect..

You can also import the Access DB direct into SQL..

Another issue here is that SQL is not limited to the 2G file size that Access has...

" Thanks GremlinSA. I shall follow your suggestions."

[dglienna]

The old versions of Access would corrupt data with more than 3-5 users at once. The new version just refuses to allow more than the limit, due to throttling. SQL Express does the same thing, except with their minimum, around 50, I think. Over that needs SQL SERVER paid version.