MS Access data conversion - Re: Migrating Access database from NT to Windows 2000? Is there an

Author

Re: Migrating Access database from NT to Windows 2000? Is there an

Matrix

2005-04-20, 8:25 pm

First of all Thanks Immanuel.

Yes, Windows 2000 has sp4 installed.
Yes, Jet 4.0 and all the service packs installed on the client machine. We
don't install Access (never before migration).
Yes, It is same hardware (I mean same laptop that we are reimaging).

I am not sure what do you mean by FE and BE. If you meant to be Front End
and Back end than yes we do installed the application and resotre the
database which was backed up on NT. I hope this help.

"Immanuel Sibero" wrote:

> Hi Matrix
>
> Windows 2000 - All service packs installed?
> Access 2000 and Jet 4.0 - All service packs installed?
> Are you using the FE/BE setup?
>
> Additional information:
>
> http://www.granite.ab.ca/access/corruption/causes.htm
>
> Immanuel Sibero
>
>
>
>
> "Matrix" <Matrix@discussions.microsoft.com> wrote in message
> news:EA65EB49-65A0-4E7E-8008- BC33F682240F@microso
ft.com...
> I
> NT
> during
> build
> jet
>
>
>

Immanuel Sibero

2005-04-21, 11:24 am

Matrix,

> I am not sure what do you mean by FE and BE. If you meant to be Front End
> and Back end than yes we do installed the application and resotre the
> database which was backed up on NT. I hope this help.

I did mean Front End / Back End within the context of MS Access. An MDB or
MDE that contains forms, queries, reports, etc (Front End) located on each
user's workstation and an MDB containing tables only located on a *share*
folder on the server. All users should have full access to the share folder.

From your post, I'm not sure if you're using Access as the Front End. Are
you using Access as your Front End? Any specific error messages?

You might also run through the website link I gave you earlier re:
corruptions. As you can see corruptions can be caused by anything from
hardware to software.

Immanuel Sibero

"Matrix" <Matrix@discussions.microsoft.com> wrote in message
news:8620FD63-D292-4A9B-AC4E- 083CC6EB9656@microso
ft.com...[color=darkred]
> First of all Thanks Immanuel.
>
> Yes, Windows 2000 has sp4 installed.
> Yes, Jet 4.0 and all the service packs installed on the client machine. We
> don't install Access (never before migration).
> Yes, It is same hardware (I mean same laptop that we are reimaging).
>
> I am not sure what do you mean by FE and BE. If you meant to be Front End
> and Back end than yes we do installed the application and resotre the
> database which was backed up on NT. I hope this help.
>
> "Immanuel Sibero" wrote:
>
2000?[color=darkred]
on[color=darkred]
The[color=darkred]

Matrix

2005-04-25, 7:26 am

Thanks for your reply. I am using visual basic 6.0 application as front end
using dao and jet driver 4.0 to connect to MDB. This application is installed
on all client machine and have their individual databases. Once they do their
work offline they can connect to network send the request to the server and
get their response back to the local database. I hope this will help. I will
go over the link that you provided.

"Immanuel Sibero" wrote:

>
> Matrix,
>
>
> I did mean Front End / Back End within the context of MS Access. An MDB or
> MDE that contains forms, queries, reports, etc (Front End) located on each
> user's workstation and an MDB containing tables only located on a *share*
> folder on the server. All users should have full access to the share folder.
>
> From your post, I'm not sure if you're using Access as the Front End. Are
> you using Access as your Front End? Any specific error messages?
>
> You might also run through the website link I gave you earlier re:
> corruptions. As you can see corruptions can be caused by anything from
> hardware to software.
>
>
> Immanuel Sibero
>
>
>
>
> "Matrix" <Matrix@discussions.microsoft.com> wrote in message
> news:8620FD63-D292-4A9B-AC4E- 083CC6EB9656@microso
ft.com...
> 2000?
> on
> The
>
>
>

Immanuel Sibero

2005-04-25, 11:24 am

Hi Matrix,

I have to say that the fact that you're using VB6.0 as a front-end probably
introduces other possibilities. I was under the assumption that you were
using Access MDB/MDE as a front end. I have limited experience with VB6.0 as
a front-end to an MDB. You might want to start a fresh thread so that you
will get more exposure to the experts.

Should you decide to start a new thread, additional detail would be helpful:
- VB6.0 as the front end.
- Any error message?
- You're stating that users work offline and then connect to the network,
I'm assuming the mdb that's corrupting is the one on the network?
- Is it possible to run everyting locally? i.e. move the mdb on the network
to a local drive and try to reproduce the corruption?

HTH,
Immanuel Sibero

"Matrix" <Matrix@discussions.microsoft.com> wrote in message
news:3670E8F4-2B49-4AEE-97DF- 7F2C53DE7F96@microso
ft.com...
> Thanks for your reply. I am using visual basic 6.0 application as front
end
> using dao and jet driver 4.0 to connect to MDB. This application is
installed
> on all client machine and have their individual databases. Once they do
their

> work offline they can connect to network send the request to the server
and
> get their response back to the local database. I hope this will help. I
will[color=darkred]
> go over the link that you provided.
>
> "Immanuel Sibero" wrote:
>
End[color=darkred]
or[color=darkred]
each[color=darkred]
*share*[color=darkre
d]
folder.[color=darkred]
Are[color=darkred]
machine. We[color=darkred]
End[color=darkred]
Windows[color=darkre
d]
were[color=darkred]
that[color=darkred]
2000[color=darkred]
started[color=darkre
d]
application[color=da
rkred]
corrupted.[color=darkred]

Sponsored Links