Help! Please! Ms access 2007 runtime

[tresky]

Hi, I have been creating database and programming in a couple different languages off and on for last 10 years or so. Never got too involved in it just minor programs, games, but I have made a ton a databases with ms access. I am I guess you could say not too fond of the new access, Im more old school and used to older versions. I have recently created a new database for the electrical contractor I work for that is VERY extensive. Tracking and updated all aspects of the commercial electric field, but specific to the foreman actually working in the field. It logs time, workers, all docs related to, reports, blah blah blah. The program is beautiful and I have been using it myself now for that last month or so just testing it out and tweaking minor things to speed up the proccess in the field. I have it almost ready, completely "stand alone" if you will, no need for ribbons or nav pane, all done is forms (pretty nice ones too I might add). Everything functions exactly as its supposed to, it is very complex though with a lot of update/append/delete queries, macros, code, custom functions...etc. When I package a solution or create an install file through the wizard, it even installs and opens like its supposed to (now in runtime, not access) but doesnt even recognize the basic "Date()" function, or "date()-weekday(date(),2)+7"...???...every button displays an error and crashes runtime, the only things that seem to work are the basic buttons which open a table, or basic form(mean no subforms recognized, no queries...) WHAT AM I NOT INCLUDING IN THE INSTALL PACKAGE??? OR WHAT AM I DOING WRONG. IF MY COMPANY HAD MS ACCESS INSTALLED ON THEIR SYSTEMS I WOULDNT HAVE THIS ISSUE, (I DONT THINK) ITS ONLY IN RUNTIME? PLEASE HELP? IM FRUSTRATED!

THANKS TO ANYONE!

 

[MarkK]

You need to set a couple of things in the registry as outlined here

That post is about how to specify the datatype in the Access Developer Extensions add-in, which you can download here. The ADE is a tool that creates a Setup.exe file and an .msi windows installer package for your runtime database, related files, and lets you set those registry settings automatically at install time, but you can also figure out what the settings need to be and manually set them using regedit, or you can write a .reg files, which updates the registry by double clicking.

 

[tresky]

Thanks a lot for your input, i will look into that this afternoon. Hopefully it works, i would really like to get installed on a co-workers comuter for him to field test it as well.

Thanks again!

 

[teamneon]

Did you get your kinks worked out? Have you tested the database live yet?
Im interested in taking a look at it and possibly testing it out also.
thanks
jimmy