Split Database Very Slow

[=?iso-8859-1?Q?Vladim=EDr_Cvajniga?=]

I have found this trick somewhere on the Internet. It was talking about a
recordset not just a simple "BE MDB pointer".

As soon as I find original source of the information I'll post it here.

TYVM for your respond.

Vlado

 

[=?iso-8859-1?Q?Vladim=EDr_Cvajniga?=]

Here's the source: http://www.granite.ab.ca/access/performanceldblocking.htm

Vlado

I have found this trick somewhere on the Internet. It was talking about a
recordset not just a simple "BE MDB pointer".

As soon as I find original source of the information I'll post it here.

TYVM for your respond.

Vlado

 

[Tony Toews [MVP]]

in Form_Open:
'Set rsVzdy = CurrentDb.OpenRecordset("VZDY")

VZDY (ALWAYS in English) was a table in a shared BE MDB

How many records in that table?

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[Tony Toews [MVP]]

P.P.S.
We also had performace issues on computers with some earlier versions of AVG
(Grisoft Antivirus System). Grisoft was using "AVGDB.MDB datacenter type"
which was resulting desperatelly slow performance of Access applications. I
think they don't use it anymore.

This has been reported a number of times over the years by various
anti virus vendors when they accidentally add MDB, MDE, MDA or other
such files to their virus scanners. They usually take that out a few
days or a week later after the screams from outraged customers.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[=?iso-8859-1?Q?Vladim=EDr_Cvajniga?=]

No records, empty table.

Vlado

How many records in that table?

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[=?iso-8859-1?Q?Vladim=EDr_Cvajniga?=]

Hmm... so AVG gave us unclear answer to our enquiry?... :-/
V.

AVG talking about remote control of AVG, "datacenter", etc.:
Je nainstalována vzdálená správa AVG? Pokud ano, na jakém protokolu bezí?
Pokud máte datacenter typu AVGDB.MDB, doporucuji prejít na AVGTCPServer.
Tento je soucástí AVGADMIN 7.0.185. Nová instalace AVGADMINu je k dispozici
na adrese http://www.grisoft.cz/cz/cz_dwnl7.php?ver=8. Dokumentace potrebná
k instalaci a pripojení programu AVG na stanicích je soucástí instalace.
...\grisoft\avgadmin7\doc\.

 

[David W. Fenton]

I have found this trick somewhere on the Internet. It was talking
about a recordset not just a simple "BE MDB pointer".

And my point is that you don't *need* to open a recordset if what
you're trying to do is create (and persist) the LDB file -- all you
need is to initialize a db variable pointing to the back end.

 

[=?iso-8859-1?Q?Vladim=EDr_Cvajniga?=]

Now I now. I just tried one of possible solutions, see
http://www.granite.ab.ca/access/performanceldblocking.htm

Vlado