When I distributed my accde file to the people in my office it went straight to the MS Access welcome screen instead of opening the database. Anyone have any ideas?
The accde file is my front end with some VBA to check users permission etc. I can open up the file from my machine in particular but others will open the file click the "Open" button on the window to grant access to the code and it goes to the welcome screen with all the templates. All machines here have Microsoft Access 2007 installed on them.
You did not indicate that you have defined a form to be displayed at startup. Using accde files is a different animal than using the standard accdb file, even when users have the full version of Access.
Is the file being opened located in a Trusted Location for each of the other users?
Are macros enabled in the Trust Center setting for each of the other users?
There is no default form to be displayed like you see in the access settings. What happens is i have the code check who is logged on to the computer and then look up their permissions then based on that it will open up a particular form. As for the other users, the have it in a trusted location and macros are enabled.
Yes, it does use the AutoExec Macro to perform the start VBA and there is no interaction from the user to perform the code. I have also tried distributing the accdb file to a few others to see if that would work but they get the same error. I can get both to work from my machine but the people I am distributing to are the ones having the issues.
Alright, so the user data that the code is supposed to grab from on start up is in the back end. Is this a reason why? and if so is there a workaround?
If you have your front-end linked to the tables in the back-end that should not be the problem.
Did you set any "References" during the development of your database? If so, the other users may not have the same version of the referenced file that you have. Check the "References" list from the VBA code window "Tools" menu option on one of the other users machines to see if there is a reference that has "Missing ...." in it.
We can make our SQL Azure database much more secure by using code to make the needed connections and saving our databases as accde or mde files to protect the code. .... We have a simple demonstration application that uses the techniques mentioned here that you can download from this page. ... The SQL of pass-through queries is normally passed directly to SQL Server without any modification which enables very fast execution of the SQL in SQL Server.
