|
Home > Archive > MS Access Multiuser > August 2005 > access 97 and xp pro
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
access 97 and xp pro
|
|
| drazlou 2005-08-19, 3:26 am |
| Small business with 2 desktops and 2 laptops all running xp pro. Access 97
database runs fine on both desktops, but "add record" feature on forms
unavailable when .mdb file is transferred to either laptop. One laptop used
to run
windows ME and I didn't have this problem then. Does xp pro run access 97
databases differently on desktops and laptops? Would converting the databases
to access 2003 help?
| |
| Scott McDaniel 2005-08-19, 9:29 am |
| You've probably got some reference truobles ... 97 used Jet 3.51, XP Pro
doesn't install that by default (lots of other apps do, so lots of XP
installs have 3.51). Open the db on the laptop, go to the VB Editor (Ctrl +
F11) and click Tools - References ... see if any are marked MISSING ... if
they are, you'll need to rectify them by insuring that the proper
libraries/files are available on the machine.
When you say "unavailable", do you mean the item is greyed out? Or do you
get an error when you try to run it?
--
Scott McDaniel
InfoTrakker Software
"drazlou" <drazlou@discussions.microsoft.com> wrote in message
news:644E8471-8C03-4694-A393- 84EAD463707E@microso
ft.com...
> Small business with 2 desktops and 2 laptops all running xp pro. Access 97
> database runs fine on both desktops, but "add record" feature on forms
> unavailable when .mdb file is transferred to either laptop. One laptop
> used
> to run
> windows ME and I didn't have this problem then. Does xp pro run access 97
> databases differently on desktops and laptops? Would converting the
> databases
> to access 2003 help?
| |
| drazlou 2005-08-19, 1:27 pm |
|
"Scott McDaniel" wrote:
> You've probably got some reference truobles ... 97 used Jet 3.51, XP Pro
> doesn't install that by default (lots of other apps do, so lots of XP
> installs have 3.51). Open the db on the laptop, go to the VB Editor (Ctrl +
> F11) and click Tools - References ... see if any are marked MISSING ... if
> they are, you'll need to rectify them by insuring that the proper
> libraries/files are available on the machine.
>
> When you say "unavailable", do you mean the item is greyed out? Or do you
> get an error when you try to run it?
>
> --
> Scott McDaniel
> InfoTrakker Software
> "drazlou" <drazlou@discussions.microsoft.com> wrote in message
> news:644E8471-8C03-4694-A393- 84EAD463707E@microso
ft.com...
>
>
> thanks for the response. By unavailable I mean that in datasheet view there is no blank next record line waiting to be filled in and the forward arrow has no >* available.
| |
| Scott McDaniel 2005-08-20, 11:24 am |
| Normally this means the underlying recordsource is NOT updateable. Did you
check references on the trouble machine?
Also, I believe I would use at least Access 2000 format, just so that all
dbs use the same engine.
--
Scott McDaniel
InfoTrakker Software
"drazlou" <drazlou@discussions.microsoft.com> wrote in message
news:31D2D6CD-6AE6-4D47-88B2- E685B45DCD3A@microso
ft.com...[color=darkred]
>
>
> "Scott McDaniel" wrote:
>
|
|
|
|
|