Making a switchboard open on startup without without the backend

[YoungWolf]

Hi everybody,
I'm new here and very inexperienced, and i figured this would be the best place to find help! Thanks for taking the time! First off i'm using access 2007 and i made my database the way i want it. I wanted to make it so that an end user can open, edit, delete entries using only the forms i created which are linked by my switchboard, however i dont know how to make the switchboard open on its own wihtout having access running in the background?
Any tips?

 

[hk1]

sounds to me like you want to run access is runtime mode.

You'll have to create a shortcut on the user's desktop that looks something like this:

"C:\Program Files\Microsoft Office\Office12\MSAccess.exe" /Runtime "C:\Database Folder\Access Frontend.mdb"

 

[YoungWolf]

thanks i appreciate the help, thats exactly what i needed!

although it says "a potential security concern as been identified" any advice for getting that to go away?

 

[hk1]

not sure right off. Is the database split? Do you have the backend in a trusted location? You might need to change your trusted settings inside the Access options.

 

[YoungWolf]

its in a trusted location ,
is it supposed to be split?

ill give playing around with the trusted settings

 

[hk1]

It would probably be best to split it, especially if you will have multiple users using the file. However, I don't think that is what's causing your security error.

 

[YoungWolf]

thanks alot for the help! i really appreciate it