Question Split Access database

[itnchans]

Hi,

So far with access database, i'm able to split them into frontend and backend.

What I would like to know, is it possible to spit frontend down even further and maybe have all modules in a separate mdb file. If it is possible how would you access or call these function from the main frontend mdb file.

Does anyone have any examples of this.

Regards

 

[vbaInet]

So you will normally be thinking of DLLs for this. Yes you can call the functions from another db but in my opinion we're looking at slow responses. You're better off duplicating the functions across the dbs.

 

[itnchans]

would duplicating the function blot the mdb file.

Also would he idea of DLL spead it up, if so would be interested to learning this and if anyone has any helpful links or demos on how to create DLL.

 

[vbaInet]

A module is simply plain text. A module containing about 1000 lines of text would be ~50 KB which is rather small. Bloating has no connection with the Modules collection.

It's been a while I did one of those in this environment but there should be some information on the net about creating DLLs.

 

[gemma-the-husky]

I tried to use mdb's as libraries, but it was more trouble thanm its worth. I just copy all my standard code into each new dbs.

I have massive dbs, hundreds of objects, and lots of code - still coming in under 20Mb.