I´ve copied an Access-database from one computor to another. I get different results when I use a form and search for data. On one computor I get data when I search for that, but not in the other. What can that depend on??
Same database, different results on different computors
- Thread starter Björn
- Start date
missinglinq
AWF VIP
- Local time
- Today, 02:55
- Joined
- Jun 20, 2003
- Messages
- 6,420
The Default is to Import with the data in place, and it' set up so that you have to go to a second screen in order to change the setting, so it's doubtful that it's been changed without the OP knowing it.
More importantly, I think, is what version(s)/service pack(s) are we speaking of, what actual code is being used for this operation, and whether or not error messages are being displayed.
When apps run fine on one machine and not on another or run fine in one version and not when run under a newer version, the first thing you have to think about are missing references.
Here are Doug Steele's detailed instructions on how to troubleshoot the problem:
http://www.accessmvp.com/DJSteele/AccessReferenceErrors.html
If this is code utilizes FindFirst, for record retrieval, as in the Wizard generated code for comboboxes doing this, I believe it requires the Microsoft DAO 3.6 Object Library, which may not be checked.
More importantly, I think, is what version(s)/service pack(s) are we speaking of, what actual code is being used for this operation, and whether or not error messages are being displayed.
When apps run fine on one machine and not on another or run fine in one version and not when run under a newer version, the first thing you have to think about are missing references.
Here are Doug Steele's detailed instructions on how to troubleshoot the problem:
http://www.accessmvp.com/DJSteele/AccessReferenceErrors.html
If this is code utilizes FindFirst, for record retrieval, as in the Wizard generated code for comboboxes doing this, I believe it requires the Microsoft DAO 3.6 Object Library, which may not be checked.
Thanks CEH and Missingling for your advices!
I´ve tested a lot of adjustments to make it function, but the most important things to do was some basic adjustments of the database which I will show here:
When you create and move a database or parts of it:
Adjustment of Default folder
Press the Microsoft-button
- Choose Access-buttons (Down to the right)
- -Choose Popular
- --Choose Creating Databases
- ---Choose Default database folder
- ----Browse to find folder where you have the Formpart of the database (if it is split into two parts)
Adjustment of connection between tablepart and formpart of the split database
- Open the database
- -Choose Database Tools
- --Choose Linked Table Manager
- ---Choose Always Prompt for New Location
- ----Choose Select All and OK
- Choose Folder with the Tablepart of the split database
Adjustments of ”Trusted Locations”
- Press the Microsoft-button
- --Choose Access-options (Down to the right)
- ---Choose Trust Center
- ----Choose Trust Center Settings
- -----Press Add New Location
- ------Choose the folder with the databaseparts. Press OK.
If you get a Security-Warning in the mainpage of the database, it can be a sign of not functioning database
Sometimes youcan loose important functions because of security reasons.
It could help you to press “Options” and choose “Enable this content”. But first you have to consider the security risk of “Enable this content”!
I´ve tested a lot of adjustments to make it function, but the most important things to do was some basic adjustments of the database which I will show here:
When you create and move a database or parts of it:
Adjustment of Default folder
Press the Microsoft-button
- Choose Access-buttons (Down to the right)
- -Choose Popular
- --Choose Creating Databases
- ---Choose Default database folder
- ----Browse to find folder where you have the Formpart of the database (if it is split into two parts)
Adjustment of connection between tablepart and formpart of the split database
- Open the database
- -Choose Database Tools
- --Choose Linked Table Manager
- ---Choose Always Prompt for New Location
- ----Choose Select All and OK
- Choose Folder with the Tablepart of the split database
Adjustments of ”Trusted Locations”
- Press the Microsoft-button
- --Choose Access-options (Down to the right)
- ---Choose Trust Center
- ----Choose Trust Center Settings
- -----Press Add New Location
- ------Choose the folder with the databaseparts. Press OK.
If you get a Security-Warning in the mainpage of the database, it can be a sign of not functioning database
Sometimes youcan loose important functions because of security reasons.
It could help you to press “Options” and choose “Enable this content”. But first you have to consider the security risk of “Enable this content”!
