Problems creating 'front-end' portion of split database (ie. no 'Save As' dialogue after clicking 'Make ACCDE' and 'Save As' button)

[alan2013]

I have recently created an Access database for an acquaintance, sending him the 'working-copy' (.accdb format) file, and instructing him on splitting the database into 'back-end' and 'front-end'.

It seems he's been able to create the back-end (‘Database Tools’ --> ‘Move Data’ section --> ‘Access Database’ --> ‘Split database’).

But he insists he's then encountering problems creating the 'front-end', specifically : in the 'working-copy' database, he clicks on ‘File’, then ‘Save As’, then ‘Make ACCDE’. But when he then clicks the ‘Save As’ button, apparently noting happens, Access becomes unresponsive, and he has to close Access using Task Manager. As I understand it, a 'Save As' dialogue should open up, and he should have the opportunity to save the accde file.

I'm not all that familiar with splitting of databases. Can anyone provide some guidance on what the problems might be here, and how to work round it. Thanks in advance.

 

[Gasman]

Why don't you try splitting it and send him both DBs
To make an ACCDE the DB needs to be able to compile? Does it?

 

[theDBguy]

When you use the wizard to split the database, it automatically creates two files: the BE and the FE. So, it sounds like your friend didn't have any problems creating an FE. Rather, it sounds like the problem is with creating an ACCDE. Why are they trying to do that? If that is the problem, then you'll have to check your VBA code to make sure it can compile before giving it to them.

 

[CJ_London]

I'm not all that familiar with splitting of databases.

There is no need to create a .accde for a front end. All it does is provide a compiled code version so forms/reports/modules cannot be modified. User will still be able to see and modify tables and queries.

Splitting a db is normal and recommended practice. Definitely in a multi user environment, not so necessary for a single user but runs the risk of losing everything is something goes wrong. At least if the db is split, the BE data should not be affected and you would have a spare copy of the FE to simply replace the corrupted FE.

. But when he then clicks the ‘Save As’ button, apparently noting happens, Access becomes unresponsive, and he has to close Access using Task Manager.

It is possible the app is waiting for a prompt - and that prompt may be hidden by the existing access. Shouldn't happen but it does on occasion. The prompt will typically be located in the middle of the screen, so ensure access is not covering that - resize it as required.

 

[Silversee]

FWIW, I have encountered failures making .ACCDE files on my Arm-based Surface Laptop 7 with Access running under emulation, while there are no issues with the same file on an X86 device. (Everything else is fine; I use Access on this device daily.)

I mention it just in case he might be running Windows on Arm.

 

[gemma-the-husky]

I don't agree that there is no need to create an accde of the front end.

If you want to protect your design elements, it's well worth doing. It also prevents users modifying the front end.

 

[Cotswold]

Over all the years of using Access, I have never used the so called Wizard to split my databases. I have never seen the point in it.
On a new application I'll keep everything in one .accde as I find it can be easier in the early days. Then I'll create a new BE database and import just the tables that are required in the BE. Then delete them from the FE. Compact both and invoke my re-linking function in the FE. Job done.

 

[Gasman]

Ah, but you have your own relinking function. Most people do not, including me, so a quick few clicks gets me a BE and FE from a single DB.

 

[Silversee]

Over all the years of using Access, I have never used the so called Wizard to split my databases. I have never seen the point in it..

Splitting a database is mostly for multi-user deployments. Having a shared back-end database with front-end logic deployed to workstations improves performance and scalability.

 

[Gasman]

Splitting a database is mostly for multi-user deployments. Having a shared back-end database with front-end logic deployed to workstations improves performance and scalability.

I think @Cotswold meant the actual use of the Split wizard.?

 

[Isaac]

Yeah, if the problem was only with splitting it, then just don't use the wizard at all. Create a BE manually and put the tables in it. Link from FE to BE, delete tables from FE. Problem must be with making accde, which as some have said isn't necessary unless you find it so.

 

[Isaac]

Over all the years of using Access, I have never used the so called Wizard to split my databases. I have never seen the point in it.
On a new application I'll keep everything in one .accde as I find it can be easier in the early days. Then I'll create a new BE database and import just the tables that are required in the BE. Then delete them from the FE. Compact both and invoke my re-linking function in the FE. Job done.

It truly is making a big deal out of a fairly small thing. Relinking code can be written in 5 min and reused many times.
Tables can also be pasted as links if I recall correctly....

 

[alan2013]

After a delay of a few days, I've received an update on this :

He's still encountering this same problem (ie as per original post).

The database did Compile. I made sure of that before I forwarded it on to him.

Prompted by me (at your suggestion, CJ_London), he checked for the existence of the 'Save As' dialogue behind existing windows, but didn't see it.

I'm not quite sure how to proceed with this.. I feel that I've lost sight of what it is I need to do - or he needs to do - to allow him and his colleagues to start using the database.

 

[Gasman]

After a delay of a few days, I've received an update on this :

He's still encountering this same problem (ie as per original post).

The database did Compile. I made sure of that before I forwarded it on to him.

Prompted by me (at your suggestion, CJ_London), he checked for the existence of the 'Save As' dialogue behind existing windows, but didn't see it.

I'm not quite sure how to proceed with this.. I feel that I've lost sight of what it is I need to do - or he needs to do - to allow him and his colleagues to start using the database.

Well if he can trust his colleagues, they could just use the accdb?
You could make the accde and send that to him?

Does the FE compile for him?

If any bugs are discovered or new features required, who is going to work on those?

 

[Isaac]

I think Pat brings up a very relevant and good point. Finding a way to remotely collaborate and potentially remote control and all that kind of stuff is going to be a big deal for you now and in the future and it will only get more that way so start experimenting now and find the tools that best serve your needs.

 

[Silversee]

I think @Cotswold meant the actual use of the Split wizard.?

Yes, this makes more sense.

 

[gemma-the-husky]

Over all the years of using Access, I have never used the so called Wizard to split my databases. I have never seen the point in it.
On a new application I'll keep everything in one .accde as I find it can be easier in the early days. Then I'll create a new BE database and import just the tables that are required in the BE. Then delete them from the FE. Compact both and invoke my re-linking function in the FE. Job done.

Me too, I don't need the wizard.