Geek Answers Handbook

Accdb vs mdb. Which is faster / better?

Does anyone have experience using Access 2007 with previous versions of Access (i.e. mdb files).

We have been updated, but still use the mdb format. Some of our code (notably Docmd.TransferDatabase acImportReport) is now incredibly slow.

I tried the initial test and converted our client mdb to accdb, and the above TransferDatabase seemed to work better.

Now I wonder if we should bite the bullet and convert all the other files that make up the application. There is no need for user level replication or security, which seems to be the only limitations of the new version from the old. We have one client mdb, three databases, and then 3000 mdbs, each of which contains one report (do not ask!).

Is the new version running faster than the old one, especially on an already tangled network)?

+5
source share
3 answers

Do something new in accdb (interface wise); any new databases are created in MS SQL Server.

mdb; , . , .

MS , mdb MS Access; . accdb. MS SQL Server.

, , MS, , , ; , .

+2

, ACCDB MDB , , . , .

. . , MDB A2007. MDB/ACCDB , . , - , .

. Docmd.TransferDatabase acImportReport? 3000 MDB ?

+1

187 1,671,168 1,306,624.

:

: ACCDB MDB

.accdb, :

  • SharePoint Outlook - "[i] mprovements [] "
  • - Windows Cryptographic API

M $, , :

The first article also says: "There are also two limitations to consider when using ACCDB. ACCDB databases do not support user-level security or replication." I made a copy of the database and it opened, no problem - even in a different directory; so I don’t know what you are missing in terms of replication.

Note. I was unable to save how to convert it to a .accdb file, as indicated in the first article. I made File | Save and publish, and it allows me.

0
source

More articles:


All Articles