VB Front-end vs Access

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rio - 23 Apr 2004 00:20 GMT

I've created several apps with a FE and BE with Access
97. We have had some corruption issues with the FEs from
time to time. So far (knock on wood) we have never had
corruption in the BE. I was thinking about moving the FE
to VB to get a more stable environment. Should this
reduce or eliminate our corruption issues. I have never
had corruption problems with any vb programs. Thanks for
your help.

Reply to this Message

Douglas J. Steele - 23 Apr 2004 11:15 GMT

Does each user have their own copy of the FE (preferably on their hard
drive, as opposed to on a server)?

As well, check what Tony Toews has at
http://www.granite.ab.ca/access/corruptmdbs.htm

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(No private e-mails, please)

> I've created several apps with a FE and BE with Access
> 97. We have had some corruption issues with the FEs from
[quoted text clipped - 4 lines]
> had corruption problems with any vb programs. Thanks for
> your help.

Reply to this Message

Rio - 23 Apr 2004 19:36 GMT

Yes, the users have their own copy of the FE on their
desktops

>-----Original Message-----
>Does each user have their own copy of the FE (preferably on their hard
[quoted text clipped - 13 lines]
>
>.

Reply to this Message

Nikos Yannacopoulos - 23 Apr 2004 11:21 GMT

Rio,

Did you have a separate, local copy of the FE on each user's PC, or were you
using a common copy of it on a server? The latter scheme is known to
eventually lead to corruptions, even though it may appear to be stable for a
while at first. In that case, just moving to a local FE scheme should be all
that's required.
To be honest, I don't know whether the VB FE would be more stable.

HTH,
Nikos

Reply to this Message

Rio - 23 Apr 2004 19:37 GMT

Yes, the users have a local copy of the FE on their
desktops

>-----Original Message-----
>Rio,
[quoted text clipped - 19 lines]
>
>.

Reply to this Message

Ron Hinds - 24 Apr 2004 21:42 GMT

> Yes, the users have a local copy of the FE on their
> desktops

Does the FE contain any TEMP tables? If so, how do you plan to replicate
that functionality in a VB FE? I'm having a hard time envisioning a
forms-and-code-only FE becoming corrupt...

> >-----Original Message-----
> >Rio,
[quoted text clipped - 30 lines]
> >
> >.

Reply to this Message