Access2K and Windows XP

[Michel Lauzon]

Bonjour,

Hi, I will try in english, so be consilliant...

I had an application that run very well with Access 2K under Win98.
So we decide to change the machines (small network 3 computers).
For sure we get new machines with Windows XP Family Edition.
We decide to install our Access 2K on them to continue working in the same
way.

First, I get a problem with a calandar that was coming from an other OCX
that wasn't on the XP's machine. I replace the calandar by the original one
integrated to Access 2K. After that the data base open very well.

Secondly, I observed that the filter apply by VB code was not working
properly. As I can describe it: The form open and there two modifying list
that allow me to create a filter on the form.

That was working perfectly on the old machines (win98).

I had already verifying the reference and recompile the code without any
error.

One thing interested, the data base work perfectly on other machine with
Access XP under WinXP...

Thirdly, if I try to run the bata base from an other machine I get a message
that the file doesn't exist!!!!

Finaly, when I do the backup from an other machine of the network, all files
are copied without problem except this file (the mdb one)!!!! And made the
backup crash or stop. In the same way when I surf on an other machine by
mapping the drive to see the folder where is the file, there is no problem.
But if I try to manipulate it I get the message that the my access to this
files is denied...!!!

I understand that seems a big problem but I think that they are all related
to the same problem

Merci, Thank you to anyone

Michel Lauzon

 

[GVaught]

See suggestions within your paragraphs.

Bonjour,

Hi, I will try in english, so be consilliant...

I had an application that run very well with Access 2K under Win98.
So we decide to change the machines (small network 3 computers).
For sure we get new machines with Windows XP Family Edition.
We decide to install our Access 2K on them to continue working in the same
way.

First, I get a problem with a calandar that was coming from an other OCX
that wasn't on the XP's machine. I replace the calandar by the original one
integrated to Access 2K. After that the data base open very well.

Secondly, I observed that the filter apply by VB code was not working
properly. As I can describe it: The form open and there two modifying list
that allow me to create a filter on the form.

That was working perfectly on the old machines (win98).

I had already verifying the reference and recompile the code without any
error.

One thing interested, the data base work perfectly on other machine with
Access XP under WinXP...

Thirdly, if I try to run the bata base from an other machine I get a message
that the file doesn't exist!!!!

Answer: Was your previous database split, where the backend database resides
on a network server and your frontend on a user's machine? If so, then you
need to link the files again using the Link Table Manager. Should be under
Tools | Database Utilities. Guessing, I don't have 2003. If the database is
not split, it should be. When sharing a database with multiple users, the
backend (tables only) should reside on a non-workstation machine or a true
server, such as Win 2K Server or Win 2003 Server.

Finaly, when I do the backup from an other machine of the network, all files
are copied without problem except this file (the mdb one)!!!! And made the
backup crash or stop. In the same way when I surf on an other machine by
mapping the drive to see the folder where is the file, there is no problem.
But if I try to manipulate it I get the message that the my access to this
files is denied...!!!

Answer: This is probably due to incorrect sharing/security placed against
the database and the folder where it resides. You must have
Read/Write/Execute/Modify. This is needed so users can open the database.