Access 2002 front end works fine in full version - fails in runtime

S

Steve

Folks,

I work for a government department with strict controls on the
computer and network. I have built an Access 2003 (2000 file format)
DB that has a front and back end.

The front end has a switch and user toolbar, and the majority of the
app works fine. The front end performs flawlessly on my machine with a
full version.

The major data entry screen has a series of fields and a subform with
a couple of tabs for additional data. Beside two of the data fields
(comboboxes) I have a button to pop up a modal form to enter new data
for the list in the combo box.

When new data is entered into the modal form, the data is accepted
until the user hits the save button, at which time the runtime version
pops up an error message stating that it can't save the data as it
will create a duplicte key.

I also have a form/subform that populates data from a table, with the
form header containing some selection features to simulate query by
form.i.e. in a vehicle rego number box type in "a" and it repaints the
subform by changing the datasource and requerying, press "b" and the
box reads "ab" and requeries etc.

This form loads, but the data in the subform does not display. When
you press "a", a fatal error occurs and access shuts down.

I used the runtime version, loaded by IT, as it is "not economical" to
buy full versions for the ten or so machines that will be using the
db. To make matters worse, I now have requests for the DB to be
installed elsewhere, increasing the potential investment.

In house IT assure me that they have installed on every PC all the
necessary files, and I have a couple of other smaller DBs running OK,
its just this one......

I've only got three references in the project Access, DAO 3.6 and VBA.

Any clues???
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top