[newb1]

Hi,
I'm using an MS Access database and use vb.net in an asp.net website. It works ok on the localhost. It was deployed to a test hosting site where it worked ok. Now, when it was deployed on the main hosting there is a problem. When entries are being made (only 1-3 users at a time), periodically it stops working. meaning,

1. if one is trying to login, it would not be successful & no errors would be displayed. Only the login page will be displayed again with the userName textbox filled with the entry made by the user & password textbox empty. ( i hv put in code to trap errors like wrong username/pw etc)
2. if one is in the middle of an entry - like say starting a new entry after making a few - the combo boxes will become empty of all data which they should be displaying. Pl. remember that they worked fine of many entries just before this.
3. if one was querying data, like getting logs of no. of entries (& other info) between different date ranges, it will work fine for many attempts and then suddenly stop displaying the data.

If we wait for some time, everything resumes normally.


Is this an MS Access issue. Does it crash if multiple queries are made to it in quick succession. (each entry makes multiple queries to the database during its lifecycle).
or is it an issue with the hosting site. (their help is non-existent)

Am i right in assuming that
1. all connections should be closed using

connection.Close()

is there any reason NOT to do so.
2. the above problem looks suspiciously like connections left open.

any thought would be welcome.

regards,
milind.

[modi123_1]

This is the major issue with ACcess - it is not designed to be more than a personal, local, database. If you want to have something that can support multiple users at once and so forth then use MSSQL! Heck - the MSSQL Expression version would be better than trying to fight resources over an Access DB.

Was there a solid reason why you would pick Access over MSSQL or MYSQL?

[newb1]

modi123_1, on 26 November 2012 - 11:50 AM, said:

This is the major issue with ACcess - it is not designed to be more than a personal, local, database. If you want to have something that can support multiple users at once and so forth then use MSSQL! Heck - the MSSQL Expression version would be better than trying to fight resources over an Access DB.

Was there a solid reason why you would pick Access over MSSQL or MYSQL?

Thanks for the response.
1. In that case, am i right in thinking that Access should NEVER be use for websites (or come to think of it, in any scenario) because what can be less than 1-3 users. A LAN version of the software developed in VFP (with VFP tables) works flawlessly. It has 20-30 users (concurrent) for a period of about 10 days at a time with no problems. And it has more complicated logic.

2. <MSSQL Expression version> - did u mean MS SQL server express

3. No, there wasn't any solid reason, except someone could convert my VFP tables to MS Access easily.

Also, can u please tell me: should connections be 'always' closed or not.

Thanks & regards,
milind.

[modi123_1]

Quote

2. <MSSQL Expression version> - did u mean MS SQL server express

Yes.

Quote

Also, can u please tell me: should connections be 'always' closed or not.

I typically close connections when I am done using them.. which means typically leaving the method.

[newb1]

Thanks a lot. That clear things up. I appreciate it.

One advantage was that the hosting site provides unlimited Access databases

Now i just hv to figure out whether the prob i described is because of Access or something else.

/milind.

[modi123_1]

unlimited access? Mind shooting me their address in a pm or here? I am curious who is offering that as a perk.

[newb1]

sure. how do i send privately.

[modi123_1]

Go to my profile and send me a message.. any post of mine there's a little box that fly's open to show a "send me a message" button.. yeah those two are the typical routes.

[newb1]

done sending. finally. having probs with voltage fluctuations & consequently router reset.