Split Your Database in Microsoft Access

Split Your Database
By Richard Rost

2 years ago

Relinking Tables Upload Images Link
Elaine Heltman
2 years ago

Hi Richard. I have the admin copy of the split database on my desktop, with the backend and encrypted frontend on the server. I'll be distributing the encrypted frontend to users. After I make changes to the admin copy, I'm having issues relinking the new encrypted frontend (SavedAs from the admin desktop copy to the server) to the backend on the server folder. I do not receive the right-hand options to relink, etc., only to refresh. What am I missing in this process? Thank you!

Richard Rost
2 years ago

You can't make that kind of a change in the encrypted ACCDE front-end. You need to relink the tables in YOUR ACCDB then make a new ACCDE file.

Elaine Heltman
2 years ago

So, if I understand correctly, I relink the frontend admin desktop version with the Server BE, then make the encrypted ACCDE file savedAs to the server?

Richard Rost
2 years ago

You shouldn't really have to RELINK anything unless you MOVE the backend database. When you split the database, specify your SHARED SERVER FOLDER as the location for the backend tables. Once that's done, you can change your frontend all you want. Make a new ACCDE and the linked table references will stay the same.

Elaine Heltman
2 years ago

I'm having problems again with the double-clk DoCmd.openform code working in ACCDE files. The link address is correct, I double check it, and I've also tried linking using the IP address for the server. The code works flawlessly on the ACCDB file, regardless of its location - server folder or desktop. Thanks again!

Richard Rost
2 years ago

Interesting. What are you trying to open? Does it work on ANY system or is it a machine thing?

Elaine Heltman
2 years ago

From a form, I'm trying to open another form by double-clicking a selection in a combo box. The ACCDE file does not work on any system. I've tested with both the FE and BE on my desktop; linking FE on Desktop to BE on the server (via VPN); and from a Citrix server (not via VPN). Thanks!

Richard Rost
2 years ago

Can you MsgBox something from the same event? Do other events work?

Elaine Heltman
2 years ago

Good call. Looks like it's only VBA code that's not running. Certain forms do not open to a blank record, via DoCmd.GoToRecord , , acNewRec, as well as the many DoCmd.OpenForm codes I have in most forms. But, a MsgBox that runs from a Command button that prints a report of a file, does work.

Richard Rost
2 years ago

Trust issues? Are you running the database from a Trusted Folder?

This thread is now closed. If you wish to comment, start a NEW discussion, below.

Back to Split Your Database Comments