Access 2000 question here

[mitzman]

So I'm running access 2000, but the question is, without the developer's edition, is there any way to distribute my database i wrote to people without any version of access on their computers? I've been thinking about purchasing the developer's edition so I can have the runtimes and everything, but I'd still like to know if there's a solution before I do that. Any ideas people?
Thanks!

-dave

[DrewDog_21]

Do you have a VB program written that accesses the data in the database, or is your program written strictly in Access with formulas, reports, etc.? If the user never needs to open the database itself, then they do not have to have any version of Access on their computer. If they do need to open the database, then they need Access installed.

[mitzman]

nope
it's straight up access 2k (but i use a lot of vba and vb code underneath it). So the only solution aside from writing an app in vb to handle the data is to get the developers edition of access, right?

-d

[DrewDog_21]

I have not used the developer's edition, so I don't know the beast. But if it will let you distribute the DB without the end user having Access installed, then I would assume that either that or writing a small VB program is the only way to do it. Anyone knows differently, please feel free to correct me.

[JasonGS]

It would probably be more feasible to develop a VB solution, the closest thing to distrubtable Access is an MDE file which does require Access to be installed; it just protects your code. If you develop a VB program, you can access the database file with ADO (already installed in most computers), therefore eliminating the need for Access.