Database is behaving strange!

[alex243]

I just finished programming a database (written in the version of MS Access in Windows XP Professional) and installed it on another PC with the version of Windows XP Home. I thought, it will be the same, but now the database starts behaving really odd.
1. It asks whether I really want to open the object (database) because it might contain unsafe expressions?
2. The database has 4 main forms. 3 of them function ok, but the fourth is malfunctioning. There are 3 command buttons that are the same for each form: Cancel, Find and Add New Record. And while in the first 3 forms these functions are ok, in the fourth I cannot execute the functions Cancel and Add New Record. I also cannot change anything there. But the form isn't read-only!
3. I have a report that displays sums for each revenue or expense category. At my laptop at home it functions well, but here it displays only "error" in the Print Preview. Also the Date() function is not ok. It displays "Name?" instead.
4. A main form has a combobox, whose datasource is a look-up column in the underlying query. In the query the customer name appears in this column. But in form view the customer ID appears instead.

I hope someone has a good advice how I can fix these things. It's my first database...

Thanks in advance!

 

[JACKSON]

I would check:

- Windows Home can be used with Win XP Pro, just make sure the Backend file is on the windows XP Pro PC. This allows you to set explicit user permissions on both the folder and backend database. You can set these permission for the user "Everyone" to save time. Windows XP home uses simple file sharing, which is very limited. Also, check on the form properties,
on the data tab, make sure allow edits, allow deletions, and allow additions are set to yes. I am assuming you have split the database, If you have not, you really should look at doing that on a multi-workstation network. Check the Database splitter wizard.
- I have had the same issue with the "unsafe expressions", but only with Access 2003. I think it's some new protection thrown in Access 2003, because we have gotten that message when opening a database on Access 2003 that opens fine with access 2000.
- I would download the latest Windows service pack on the workstation where the date function is not displaying right. Also, if you used an active x control to display the date, make sure it's registered on that PC.

 

[Pat Hartman]

A2003 is installed on your XP home machine. You can turn the warnings off by doing 2 things.
1. install the latest version of jet which I think is ver 8
2. Go to Tools/Macros/Security and change the setting to low.

The other problem where the app is not recognizing functions is caused because Access can't resolve a reference to some library. Open any code module to get to the VBA editor window. Then choose Tools/References. Check and uncheck any library. This will force Access to refresh its references collection.