Access Runtime

[SFC]

Access 2007 & 2010 runtime. Has anyone used the runtime versions? I have an access report that uses a csv file for data. It works fine under the full version but the runtime does not open it. Any suggestions are greatly appreciated.

thanks,
Steve

[HiTechCoach]

Yes, I have been using the Access runtime since Access 97 through 2010. I run all my front ends in runtime mode.

We really need a lot more detail about the database setup.

Like:

1) what version of Access are you using to create the database?

2) Is your application split?

3) Are you using a .mde or .accde with the runtome versions?

4) Are you creating a trusted location for the database for the 2007/2010 runtimes?

5) Have you tried changing the extension to .accdr with the full version for testing?


Now about the report:

1) How are you using the csv file with your report?

2) Is there any VBA code behind the report?


Answering all these question will really help.

[SFC]

Thank you for your reply HighTechCoach,
I did get it to work last night, I changed the extension to from. accdb to .accdr
In the options on access 2007 & 2010, you can assign a form to run when access is launched, I created a simple form with a buttom that prints my report and it works fine. May not be the best way but it works, I'm not sure about you other questions, i'm kind new at this.

[HiTechCoach]

The way you handled it by creating a form that loads at start up is a very common practice.

When using the Access runtime you must provide the user with a way to navigate the database. You need to create a main menu form or a menu bar/Ribbon.

Recommended reading:
Splitting your Access database into application and data
Access FAQs
** These links will help you understand some of the other questions I had.

[SFC]

HiTechCoach,
thanks for your help! I'mstill learning the basics andI'm sure I will have more questions, look foward to your replies.

[HiTechCoach]

You're welcome. Glad we could assist.

Also, welcome to your new journey on the path of Access Database Development. We will be here when you have more questions.