Internet replication - Hosting - Access 2000

[Brian]

I realise the database would normally need to be closed to do this but I
wondered how folk were dealing with this. My client wishes this to be as
easy as possible e.g. not having to go to a seperate FTP program. At the
moment the database would merely replace the previous version each time.

Any ideas or I suppose particularly the code to do it?

Brian

[Brad Kingsley]

Database replication is best dealt with by an enterprise database like SQL
Server. Access replication over the web is unreliable at best.

--
-Brad Kingsley

ORCS Web, Inc.
Reliable NT4 & Windows 2000 web application hosting
http://www.orcsweb.com/

"Brian" <br...@hyam.demon.co.uk> wrote in message
news:965797859.19486.0...@news.demon.co.uk...

[Michael (michka) Kaplan]

This is a really not a fair statement. It is very possible to use reliably,
and it is very dismissive of a valid technology to make such statements.

--
MichKa

random junk of dubious value at the multilingual
http://www.trigeminal.com/ and a new book on
i18N in VB at http://www.trigeminal.com/michka.asp

"Brad Kingsley" <sbr...@orcsweb.net> wrote in message
news:Oa0In9fAAHA.296@cppssbbsa04...

[Brad Kingsley]

Perhaps you should tell Microsoft - and those of us who support these apps -
that Access is reliable on the web.

That wasn't just a random statement pulled out of the air. You might want to
check out the Microsoft Knowledgebase article below:

http://support.microsoft.com/support/kb/articles/Q222/1/35.ASP?LN=EN-US&SD=g
n&FR=0

-Brad Kingsley

ORCS Web, Inc.
Reliable NT4 & Windows 2000 web application hosting
http://www.orcsweb.com/

"Michael (michka) Kaplan" <forme...@spamfree.trigeminal.nospam.com> wrote
in message news:uN5YlKhAAHA.134@cppssbbsa04...

[Michael (michka) Kaplan]

I never said ACCESS is reliable there.... I am referring to Jet.

--
MichKa

random junk of dubious value at the multilingual
http://www.trigeminal.com/ and a new book on
i18N in VB at http://www.trigeminal.com/michka.asp

"Brad Kingsley" <sbr...@orcsweb.net> wrote in message

news:uirvi$5AAHA.252@cppssbbsa05...

[Brad Kingsley]

"I never said ACCESS is reliable there.... I am referring to Jet."

...And Jet drives Access. Access was designed with the assumption that every
user would have an installed copy of Access and therefore their own copy of
the Jet engine. Placing Access on the web forces all users to use the single
Jet engine for interaction with the database and that causes performance and
stability issues.

I'm not sure how you can agree that Access is unreliable yet say that Jet
*is* reliable in the same context. I suppose it is quite possible that I am
misinterpreting your statements.

Regardless, the original question was about Access replication over the
Internet to which I answered. Not sure how we got on this tangent.

-Brad Kingsley

ORCS Web, Inc.
Reliable NT4 & Windows 2000 web application hosting
http://www.orcsweb.com/

"Michael (michka) Kaplan" <forme...@spamfree.trigeminal.nospam.com> wrote

in message news:uUEdjh6AAHA.247@cppssbbsa04...

[Michael (michka) Kaplan]

Brad,

My site is entirely database driven, gets up to a half million hits a month,
and it runs off a couple of Jet 4.0 databases. I have written ARTICLES on
stability and scalability problems in Access, but it is clear from the above
that I do not see such problems in Jet.

Does that help you understand the position better?

Access is not Jet.... and Jet is a better engine for it.

--
MichKa

random junk of dubious value at the multilingual
http://www.trigeminal.com/ and a new book on
i18N in VB at http://www.trigeminal.com/michka.asp

"Brad Kingsley" <sbr...@orcsweb.net> wrote in message

news:OSpAjE$AAH...@cppssbbsa02.microsoft.com...

[Anil Batra]

I am just curious to know how many concurrent users Access can support and
if there is a limit on how big a database can grow?
Also an autonumber field in database skips the number once in a while, would
you know hwy?

Thanks
Anil

Michael (michka) Kaplan <forme...@spamfree.trigeminal.nospam.com> wrote in

message news:#hretyFB...@cppssbbsa02.microsoft.com...

[Michael Kucan]

Max users (effective) will vary with network type/competency of application
design/ etc., but I think it specs out at 255...I may be wrong on this
point.

Max file size is 1Gig (MSA97), 2Gigs (MSA2K). That can be overcome by
separating tables out into separate files.

If you start to edit a record that has an autonumber, and then cancel the
edit, the autonumber will skip. The AutoNumber was not designed to give you
a count of records. It was designed to give you a guaranteed unique number.

Hope that answered your questions.
--
Michael Kucan
--
Anil Batra wrote in message ...

[Brad Kingsley]

Access will support 255 or so users in a file-shared environment but not in
a web environment. It's easy to test for yourself - check out the sample at
the URL below:

http://www.learnasp.com/learn/speedtablesaccess.asp

-Brad Kingsley

Host your ASP+ application with us today!
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Reliable Windows NT & Win2k Hosting
ORCS Web, Inc - http://www.orcsweb.com/
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

"Michael Kucan" <mulc...@wizard.com> wrote in message
news:xqDp5.2115$48.6...@news-west.usenetserver.com...

[Brad Kingsley]

Absolutely Michael. We've got clients who get 50k+ hits a day using Access
databases. I think it really all depends on traffic patterns. If you've got
a couple of hours or peak traffic and a lot of people are trying to query
the Access database at the same time, it is very likely that trouble will
arise.

I'll be the last to say that Access "can't" be used on the web - I see it
daily and have done it myself. But it should be reserved for low traffic
sites because I've seen a lot of sites grow and start having problems --
upgrading to SQL Server remedies the problems about 95% of the time (until
they grow more and move to COM, etc...)

-Brad Kingsley

Host your ASP+ application with us today!
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Reliable Windows NT & Win2k Hosting
ORCS Web, Inc - http://www.orcsweb.com/
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

"Michael (michka) Kaplan" <forme...@spamfree.trigeminal.nospam.com> wrote

[Michael (michka) Kaplan]

(Sigh, here we go again).

You just are not going to let it go, are you, Brad? I could write stupid,
non-scalable code using any database engine you can name, and if it does
bad, it proves the problem is with ME not with the database engine.

--
MichKa

random junk of dubious value at the
multilingual http://www.trigeminal.com/ and

a new book on internationalization in VB at
http://www.i18nWithVB.com/

"Brad Kingsley" <sbr...@orcsweb.net> wrote in message

news:uyiyquwDAHA.195@cppssbbsa05...

[Brad Kingsley]

Michael,

You are taking this personally, please don't.

So, state clearly for me and I will not respond whether I think it true or
not -- you can have the last word. A number of people went through this same
debate last year and finally someone posted some text from the Access help
files stating what I mentioned below about the 255 limit.

Are you saying that multiple queries will run against an Access database at
the same time under IIS(?) If so, how many?

I am curious of your response, but I will now leave this thread. I post to
try to help people here -- not to argue with fellow developers.

--
-Brad Kingsley

Host your ASP+ application with us today!
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Reliable Windows NT & Win2k Hosting
ORCS Web, Inc - http://www.orcsweb.com/
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

"Michael (michka) Kaplan" <forme...@spamfree.trigeminal.nospam.com> wrote
in message news:uLv5w0wDAHA.255@cppssbbsa05...

[Michael (michka) Kaplan]

I'm done, too. I had hope after our last "skirmish" that you understood
where I was coming from. I guess I was hoping for too much. :-(

--
MichKa

random junk of dubious value at the
multilingual http://www.trigeminal.com/ and
a new book on internationalization in VB at
http://www.i18nWithVB.com/

"Brad Kingsley" <sbr...@orcsweb.net> wrote in message

news:#OCfEDxDAHA.250@cppssbbsa05...