Hello I am having a slight problem. Everything works just fine right up to the point I save the file as an accde file. Once created, if I try to open the accde file nothing works. It does not connect to the server or even ask for the server password. The Admin button and Re-Link Tables button do not function. Seems like all the code is disabled. Any idea what i am doing wrong?
Adam Schwanz
@Reply 5 years ago
Sounds like it's running from a non trusted location. Is the folder trusted that the ACCDE is in?
Joe HoodOP
@Reply 5 years ago
Hello Adam,
It originally was not in a trusted location and I thought that was the problem. However it is now in a trusted location and the problem persists.
Thanks Joe
Scott Axton
@Reply 5 years ago
To the bast of my knowledge the file links have to be correct when you make the ACCDE.
You can't re-link after making the ACCDE file.
Adam Schwanz
@Reply 5 years ago
I'll throw this in here Troubleshooter see if it has anything that helps.
I think he's referring to the VBA button on the form that's made that links to the SQL tables here, which should still work as long as it works in the ACCDB.
If you run down the troubleshooter and still have problems, maybe try to re-make the ACCDE in the trusted folder and try it. Or make a blank ACCDE with just a messagebox button in it, see if it can run in that folder. I'm almost certain that's your issue if all of your front end VBA is broken.
Yeah, my relink tables button should work even in the ACCDE. Obviously your code compiles or else it wouldn't create the ACCDE. I'm stumped. Can't think of any reason why it would work fine as an ACCDB but not a DE.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access SQL Server Lessons.
