How do I create a stand alone application with Access
It will be used by any number of people so it needs to be able to be open with multi user in mind.
Thank you for taking the time to report an issue.
What's wrong... Please write below.
If yes please tell me tutorial how can I achieve this.
I like my application to have buttons,password fields for entering in the application etc .
If this is not possible creating application using only MS Access please tell me tutorial for achieving this using C++.
Please tutorials to have 20 pages
After you create and test your application, you can use the Package Solution Wizard that is included in the Access 2007 Developer Extensions to create a final version that you can deploy to end users.
Is it possible to create in MS Access or I have to hard-code the necessary queries in my application. If possible please send how to create and maintain it in MS Access.
So what I want to do is relate these many TV TABLEs to the STAND TABLE that they would be using. I have like 10 different tables of TV sizes and 1 stand list. The TV TABLEs are related to the stand list by TV model. Sounds easy enough right?
But my problem is this- how do I make a query where I am able to just put in TV Model and it will search throught the tables and put out the necessary info - lets say I want TV Model, related Stand, and Product Number outputed.
We've tried converting our Access 97 databases (lots of front end forms) into Access 2000 but they fail and we don't want to install two versions of Access due to having our applications delivered via Novell to the user (PC's are locked down).
Do we need to purchase anything to produce stand alone executables which could be used on any pc regardless of which version of Access is installed instead of using mdb/mde files?
Would stand alone executables have all the functionality of mdb/mde files?
Would this overcome the Office XXX version problem?
Will newer versions of Windows become an issue (we're on a mixture of 2000 and XP at the moment)?
Are there any issues with going down this route
I tried a combination of an update query to amend records which have changed and a delete query to delete records for projects which have been marked as cancelled in the source table, but I can't find out how to create an amend query which only adds records that aren't already in the destination table.
The alternative is to use a create table query. but when I run this and it replaces the destination table with a new one, it also breaks the link between the access database at the third-party application, which renders the document in that application corrupt, meaning I have to create it again from scratch