I am trying to access a database and it is a databse that has a front end that is forms only and a backend that saves the data. How do I fix this error. I am an admin for this database.
I am trying to access a database and it is a databse that has a front end that is forms only and a backend that saves the data. How do I fix this error. I am an admin for this database.
That sounds like a generated message rather than an actual error.
I would look for some code that checks a version number in the start-up of the database.
DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
Please use the star below the post to say thanks if we have helped !
↓↓ It's down here ↓↓
How would I do this?
I agree with Minty -sounds like a custom error message.
You are working with accdb in FE and BE?
I'd try this:
Open front end form in design view, open properties and events
try Find "database version" in your project.
If found, that will take you to the area of vba code where error message is generated an from there try to decipher the cause for the error.
Good luck.
The message may be raised during open, in which case there might be no form involved. More importantly, if it's a accde or mde, you will not find the source of the issue. What happens if you just ignore it? Another option - contact the designer, who likely conferred admin responsibility to those who don't design?
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
Status?? Can you update us?
The problem is that this is a accde and the original creator no longer works with us. I have been tasked with running and updating this database and i now am getting this error message. I personally do not know how he made the database the way he did but the froint end is forms only that can not be edited in any way. The back end is tables only.
You need to find the mdb/accdb version of this file. It is what you make the accde from. Without the source file, you virtually have no other options other than to ignore the message (if that's permitted) or start over. You cannot make design changes in accde/mde files.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
I do have access to the accdb version, but I can not figure out where to go to fix this issue.
You will need to find someone to work with the form and any code behind the form to analyze the logic that invokes the error message. The accdb from which the accde was created is critical. You should protect it extremely well.
Since your Access knowledge seems weak, and if this database is key to your business, then hire someone who is experienced in Access.
I suggest the first step is to make a copy of the accdb and store it in a safe place. Without the accdb then is little to nothing you can do. The accde is intended to be a black box/stand alone/unopenable.
If you need a fairly quick solution, you could post a copy of the accdb, but we don't know the privacy/confidentiality involve.
We also do not know your environment.
As an admin of the database, you should google/youtube to become more familiar with Access and database.
With a split database, tables are in the backend while queries, forms, reports are in the front end.
Good luck.
Last edited by orange; 03-16-2021 at 12:52 PM. Reason: speling
As the others said you need to follow the events from the opening of the file. First hold down the Shift key and open the file (hold it down until the file is fully open, you will see the Navigation Pane on the left with all the objects (tables, queries, etc.). Go to File\ Options\Current Database and under Navigation turn on View Hidden objects. While you are there note the name of the Display Form (the first form that opens). Now go to the Navigation pane and open in design the AutoExec macro if it exists. Check if it calls any custom function to check for version. If not open the display form in design view and look in the Open or Load events for any version checks.
If you can't figure it out maybe double-check if there are no local tables in the front-end, run a Compact and Repair then zip it and try to upload it here.
Cheers,
Vlad
I was able to get it to bypass the check and it is now working. Thank you all for your help!
Great job, good luck with your project!
Cheers,
Excellent news. Make sure you keep plenty of backups of the source file.
Good luck!
DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
Please use the star below the post to say thanks if we have helped !
↓↓ It's down here ↓↓