Custom frontend from locked backend

[RickyBobby]

Is there any way to create my own front end from a locked backend? I am using a frontend at work to access a database. I would like to have the same front end, but add a few custom forms. Can I create a copy of the current front end, and add my own form using field from the current backend? The database requires a login at the beginning of using the database.

[Welshgasman]

Who controls the supply of a new FE?
A new one would overwrite your changes.
Should be using an accde anyway?

[Micron]

Can I create a copy of the current front end, and add my own form using field from the current backend?

This depends entirely on the file extension of the front end. We need to know what that is.

[NoellaG]

Aside of the front-end, what is the backend? If it is a SQL server, it might be possible you don't have enough rights on all fields.

[RickyBobby]

The shortcut is an extention to a .mdw file.

This depends entirely on the file extension of the front end. We need to know what that is.

[Micron]

IIRC, that is what's known as a workgroup file and no current version of Access uses that any more. It was designed to implement security and controls what people could do once they opened the db. I cannot recall for sure, but I believe it opened the mdb or mde file and wasn't the actual db itself. Check the full path of the shortcut and the actual mdb or mde file path should be in there. If you can't spot it, perhaps post the full path of the shortcut.

[Welshgasman]

Sounds like you are trying to circumvent the security in place?

[RickyBobby]

No, I would like to just create my own frontend, with my own forms, that point to sources in the backend file. I don't like the way the front end is set up. I don't want to circumvent any of the security measures.

Sounds like you are trying to circumvent the security in place?

[RickyBobby]

"C:\NOP\NOP 2016 2003.mde" /wrkgrp "G:\Database\NOP\Security\NOPSecurity.mdw"

[Welshgasman]

It is a mde file. You would need the mdb version.

[Welshgasman]

If you create your own front end, then you can circumvent all the checks in place in the current FE.
Plus if you do not know what you are doing, you can make a hell of a mess of the data.?
I have had to use less than optimum systems in the past, but never thought of creating my own, even if for some very strange reason I was even allowed to.