Linking tables at runtime

Question

Since 2010 workgroup permissions has been removed, I would like to at least password protect the back end data file, so someone with the full version of access can't simply click on the file and open it.

So I thought maybe in my startup module I would create the table links. Would this compromise the startup time of my app? And would there be any other complications?

Answer 1

I've used this:

http://www.fabalou.com/Access/Modules/refreshtables.asp

That code simply relinks any table that is already linked, with the database pathname you supply. It's simple but effective. I'd make some changes - for example, declare your variables fully qualified instead of simply the object name - but by and large it will work.

If you need more control over the situation then the JStreet process would give you that control.

Answer 2

Thank you. That is way over my head...If I don't understand it, I would be afraid to use it. :-(

I found this example that seems pretty straightforward, but where do I insert the pwd of the sourceDB?

DoCmd.TransferDatabase acLink, "Microsoft Access", sourcedb, acTable, strSourceTbl, strDestinationTbl

Also, since all tables in the back end will be linked, is there a way to loop the statement or use a For each kind of thing to link all tables in the back end without writing a docmd.transferdatabase line for each table name?

Answer 3

One of them is here: http://www.jstreettech.com/resources.aspx

Answer 4

(Re)linking tables is quite fast in my experience, so I don't foresee a noticeable impact on startup.