Access - Visual Basic question

[Yves via AccessMonster.com]

I,

I have an application that I designed with VB. My application uses the Set
DB command to connect to an MS Access database.

Is there a problem of having more than one person using my VB application?
(this mean more than one person connected on the same DB)

I tried it and it work but I am wondering about data corruption.

Thanks,
Yves

 

[Albert D. Kallal]

I,

I have an application that I designed with VB. My application uses the
Set
DB command to connect to an MS Access database.

Is there a problem of having more than one person using my VB application?
(this mean more than one person connected on the same DB)

I tried it and it work but I am wondering about data corruption.

No, there should not be a problem. Ms-access is multi-user. It not clear
when
you said VB, if you mean the VB in ms-access, or an actual VB program
that uses the mdb format. In fact, since windows XP ships with JET, then
you don't need to install ms-access to read and use mdb files on a windows
box.

If you taking about actual ms-access code, then for multi-user operation, it
will work also, but you should split the database. I explain this concept
here:

http://www.members.shaw.ca/AlbertKallal/Articles/split/index.htm

 

[Yves via AccessMonster.com]

Thanks Albert!

My application is a written in Microsoft Visaul Basic 6.0. So it should be
OK!

Thanks for the answer!

I,

[quoted text clipped - 6 lines]

I tried it and it work but I am wondering about data corruption.

No, there should not be a problem. Ms-access is multi-user. It not clear
when
you said VB, if you mean the VB in ms-access, or an actual VB program
that uses the mdb format. In fact, since windows XP ships with JET, then
you don't need to install ms-access to read and use mdb files on a windows
box.

If you taking about actual ms-access code, then for multi-user operation, it
will work also, but you should split the database. I explain this concept
here:

http://www.members.shaw.ca/AlbertKallal/Articles/split/index.htm