VB or VBA

[Lyn]

I have an Access database that needs to run on a PC that
has Office 2000 but not Access. Would I have to use VB to
do this? Or can I make an MDE file from Access that will
run on it. Do I use VBA in this case rather than VB?
Please help as I cannot seem to find this information.

 

[Van T. Dinh]

If the PC has only Office2K Standard (hence only A2K run-time), it can only
run MDE file in A2K file format, NOT MDE file in A97 file format. IIRC, it
may be able to run MDB file in A97 or A2K file format.

To create a MDE in A2K file format, you need to use full-version A2K
software to convert the MDB from A97 file format to A2K file format and then
convert the MDB in A2K file format to MDE in A2K file format.

If you want to use (stand-alone) VB, you are talking about virtually
re-writing the application in VB using a JET mdb to store the data. VB
Forms/Controls and Access Forms/Controls are *different* so it is not that
simple. Are you sure you want to go down this path?

HTH
Van T. Dinh
MVP (Access)

 

[Goran Vitanov]

-----Original Message-----
I have an Access database that needs to run on a PC that
has Office 2000 but not Access. Would I have to use VB to
do this? Or can I make an MDE file from Access that will
run on it. Do I use VBA in this case rather than VB?
Please help as I cannot seem to find this information.
.

Hi,

If you want to create standalone Access aplication you
need Microsoft Developer Edition. From there you can
create setup.


Goran

 

[lyn]

Thankyou both for your help.