Access DB Applications

[tigger36]

I need to know if it is possible for someone that does not have access loaded on their computer to use an application written in access. If not, is it possible to write an interface that will call it from a different computer, like you would SQLserver.

 

[RiverGuy]

You can connect to it from a local or remote machine if the user does not have Access. The only problem is that you need to write an application in a programming language to connect to and manipulate the data.

 

[tigger36]

ok so if i created a vb or c++ interface with access I should be able to install that on the user system and they will be able to access the data?

 

[alvechurchdata]

ok so if i created a vb or c++ interface with access I should be able to install that on the user system and they will be able to access the data?

Thye'll be able to read and write the data but your original question wanted to "use an application written in access". The user would need Access (either the full or the runtime version) in order to use things like forms and reports.

Geoff Franklin

http://www.alvechurchdata.co.uk

 

[tigger36]

If they can read and write to the database that is really all i need I can create the forms and reports in VB can't I. I am not really sure the extent of VB capabilities. I know enough of the language to be dangerous. Guess I will be better at it by the end of this. Geez we are working with 38 spread sheets, entering the same info into three or more of them for each transaction. Not everyone has access in the office but a db application sure would bennifit here because it is hard to keep track of which info goes into which ss. Will I be able to create the reports i need in VB if I use something like .net Studio? Have the 05 beta verson.

 

[RiverGuy]

I don't know about 05 beta. Its not a good idea to use it in a production system anyways. VS.Net 2003 comes with Crystal Report integrated. There are probably some free reporting tools out there as well.

 

[pbrodsky]

Another possible approach is to use VBA in Excel, store the data in Access tables, and use Excel for display and analysis of data.

 

[zemp]

If you do it all in Access you can split the database (basically split the UI from the tables) a place the tables on a server and the UI on each machine linked to the tables on the server.

zemp

 

[tigger36]

Very good. Thanks for all your help guys. I think I will just end up using access as a back end and writing a GUI to interface with it. I have experience with crystal reports and VS.net 03 loaded on my system at home so I will probably use that for the reporting. Again thanks for all your advice.

 

[ceh4702]

Instead of accessing a table just access a querry.

If you do not like my post feel free to point out your opinion or my errors.

 

[ArkM]

As far as I know you must have Office Developer Edition to (have rights) distribute Access run-time with your Access application. In other cases (listed above) you don't have Access application as is at all...

 

[ChrisHunt]

As ArkM alludes to, if you get the Developer's Edition you can freely distribute a run-time version of Access to your users that will allow them to run Access forms & reports without having the full-blown product on their PC. This might save you from re-inventing the wheel in VB. It's very quick & easy to develop entry forms in Access, somewhat less so in VB.

Look to one of the MS Access forums on TT for further advice.

-- Chris Hunt
Webmaster & Tragedian
Extra Connections Ltd