Converting To Standalone
Jun 17, 2007
Hi All
I am currently compiling an Access DB to manage my work in progress, Payments due etc.
The DB is starting to work well and have requests from fellow contractors to purchase a copy (there are over 400 subcontractors in the group), with this in mind I have decided that when I complete the DB I will take it to a proffessional programmer and have it converted to a fully standalone programm.
My question: Is there a programm format that is preferable or would C# be the best option or is there a product out there that I could purchase and use.
Thanks in Advance
GeoffK
View Replies
ADVERTISEMENT
Oct 24, 2005
Can Access be used as a stand alone database? In other words, can I build a complete application and have it installed on another computer wheather that person has access installed or not?
I have seen some database programs that sure look like Access but they install and run as a program in itself. Hopefully I am making sense.
I want to develop a program for the school system but want to be able to do it as a complete application in itself, not dependent on if the user has Access or not. Thank you.
View 1 Replies
View Related
Oct 16, 2007
Hello
Forgive me english plz.
Cn I make standalone Access dtatbase, or do I hav to use it throug the main package all time?
Hope I sense make.
Thanku
Jackski
PS. By using Access only - no other software.
View 7 Replies
View Related
Sep 27, 2006
I currently use the Lotus package for word processing, spreadsheets etc so I do not have any of the microsoft office programs installed on my computer. Can I load just Microsoft Access as a standalone program or do i need to load the full office suite?
View 1 Replies
View Related
Feb 6, 2006
Hi,
Is there anyway to make the front end of my database standalone? For example, I would like to people to run it who don't have Access installed, what ways are there around this?
View 1 Replies
View Related
Oct 18, 2007
I just have a question, is there anyway to create a standalone ms access 2003 file. I want to be able to create a ms access db that has forms and certain reports.
I have a client who needs this ms access file to distributable to his clients (who can use it without having ms access file). Also he him self can make changes, to the forms, etc. Without any programming knowledge, change the look of the forms, add queries, etc. And be able to send the updated version of the ms access file to his cleint.
Can this be done? I have suggested using a vb frontend & and ms access as a backend, but he would have to pay someone to make changes, add reports, etc. And he wouldn't be able to do it him self becuase of lack of programming knowledge, he only has medium knowledgable of Ms Access.
So can this be done, is there a sdk i can use?
Thanks,
will
View 3 Replies
View Related
Feb 20, 2008
Attempting to change a queries calculated field properties I got the message
The Microsoft Jet Database engine stopped the process because you and another user are attempting to change the same data at the same time
Clever since I'm the only user on a stand alone PC.:confused:
I closed the database and tried again but with no joy.
Anybody know what the cause/solution is.
Brian
View 4 Replies
View Related
Dec 18, 2013
So I have finished a database and split it which is great. Only issue now is how do I turn the front end into an executable so no access to any parts of the access program or system can happen? I have done this before in a very old version of access but how to do it in Access 2013.
View 2 Replies
View Related
Feb 11, 2015
I have a sharepoint database accdw which works well as I can update something and sync it to the server, and another user with the same database can receive the changes just by syncing.
However, I want to share a version of this database with a different start up form, some restricted forms etc. If I make a copy of the accdb it creates and make changes to that, it still synchronises those changes and they affect my own version.
What is the correct way to create a different database version from my accdw?
All I want to do is take the accdb it creates, change the startup form and give it to somebody to use.
View 1 Replies
View Related
May 23, 2014
I have an Access 2007 database which has a form on which is a button to dial the currently selected phone number. All works fine. My intention is to send out partial databases to people not having access installed and they will use the access runtime module.
When the same database is run using the runtime it does not dial and does not give an error message. It just stays the same as though I didn't press the dial button.
View 10 Replies
View Related
Dec 22, 2014
i have a form with two cascading combo's that work when the form is opened as a single form however when i place the form on Page 3 of a TabCtl it fails to cascade the correct values.
frmSiteDetails > TabCtl33 > Page3 > frm ConditionDetails subform with Combo's 1 & 2
Combo 1 = [ElementGroupName]
SELECT ElementGroupID, ElementGroupName FROM tblElementGroup; has Column Count of 2 and Bound Column 2
Combo 2 = [Element]
qrySubElements has SQL:
[code]....
View 14 Replies
View Related
Jun 29, 2005
I have created a database but I would like it to be an exe. is this possible? if so, how???
I would like to lock the design and the code for the database. I will be holding about 2000 entries, will this be a problem?
thanks
View 4 Replies
View Related
Jul 11, 2005
Hello Everyone,
First of all thanks alot for investing your valuable time in reading my query, I wonder if someone can kindly educate me on how to convert an access database.mdb file to an executable .exe file. Also is there a way to create an installation package to install the database to many Computers.
Thanks Again
Warm Regards,
Darno
View 3 Replies
View Related
Dec 2, 2004
hi guys!
i just wanted to find out how do i convert an mdf to access,
please help!
Kind Regards
phindile
View 2 Replies
View Related
Dec 3, 2005
I have a dbase that was created in access XP. We are in the process of upgrading to office 2003. For the most part the database works fine. However, I have 1 form that has a few fields that have conditional formatting
on them and when the form opens those fields flash very fast continuously all most like the tab key is being held down. No matter what I do I can't get it to stop. Has anyone seen anything like this and how do I make it stop?
jon
View 5 Replies
View Related
Jun 1, 2006
This is the error i get...
This error is usually associated with compiling a large database into an MDE file.* Due to the method used to compile the database, a considerable number of TableID references are created for each table.* The Microsoft Jet database engine version 4.0 can only create a maximum of 2048 open TableIDs at one time.* Exporting a database as an MDE potentially can exceed this limit if the database has a large number of objects (table, macro, form, report, etc).
There is no accurate method to estimate the number of TableIDs the Jet database engine uses during the process of compiling a database as an MDE.* However, each VBA module and each form uses one TableID, as a result, if the database has 500 forms, and each form's HasModule property is set to Yes, as many as 1,000 TableIDs are used.
More information about this error message online.
My database is by no means big, is there any other way i can convert from mdb to mde?
Thanks
Den
View 6 Replies
View Related
Sep 1, 2006
Hi All
A simple problem no doubt!
I am trying to convert my Works database into an Access dB (which I have just bought). I cannot find any help on this anywhere?
Any help will be much appreciated
Thanks
Paul
View 3 Replies
View Related
Jan 2, 2007
Hi.
For years several agencies have used a database written and maintained in Access 97.
One adminstartor has both 97 and 200 on his computer and no problem. Until now, that is.
When I try copying a revised front end, and opening it, I get 'unrecogized database format' message.
My hunch i sthat said administartor accidentally opned the basck end with 2000 and converted it.
So, can the back end be unconveted/reverted back to 97?
Any other suggestions?
Russ
View 8 Replies
View Related
May 30, 2007
I have a problem converting access 97 mdb files into access 2000. There are multiple access databases that use a mdw workgroup on a network drive. I do have the ability to log on as an admin. Access 2000 is not letting me convert the files to the new format (telling me I don't have permission). The databases do have lots of forms, queries, macros and such.
Would the easiest method be to remove the userlevel security or is it possible to get around that? If I were to remove the user level security is it as simple as loggin in as admin, deleting all user account, granting all permissions to users and admin and removing the password?
Any help is much appreciated.
View 1 Replies
View Related
Aug 29, 2007
I've read alot on this, Tony Toews, Allen Browne and our own experts have put out lots of info.
I've started converting my dog straying database and have a weird result. This is split into front and back ends.
Result:
My PC Win XP Access 97 and 2003 works perfectly
PC 2 Win 2K Aceess 2003 ditto
PC 3 Win XP Access 97 and 2003
setup looks identical to mine no missing refeneces etc - No images will display in the image frame on the main form.
I have no hair left. Any ideas??
View 3 Replies
View Related
Sep 7, 2007
Hello,
I'm trying to get a way to creat a database of my phone messages (SMS).
I have them on a .txt file and I would like to create on ACCESS (or other program) the fields "Date:" "From:" "Message:", etc.
So, everytime I introduce a day, all sms sended on that day appears, or, when I introduce a Name, every message from that person, appear.
Is that possible? Of course that I want to convert it, not introduce one bye one because I have around 2000 messages...
Thank you very much
This is a example of the .txt file I have:
================================================== =========
Message type: SMS
From: 0: Maria
Date: quinta-feira 03 Maio 2007 15:33
-----------------------------------------------------------
Hum que bom então. Tou com a minha amiga na praça da república. Vais ficar aí?
================================================== =========
================================================== =========
Message type: SMS
From: Figueiredo 0: Maria
Date: quinta-feira 03 Maio 2007 14:59
-----------------------------------------------------------
Tas em casa?a mariana foi aí?
================================================== =========
================================================== =========
Message type: SMS
From: Figueiredo 0: Maria
Date: quinta-feira 03 Maio 2007 14:52
-----------------------------------------------------------
Já tá?
================================================== =========
================================================== =========
Message type: SMS
From: 0: Maria
Date: quinta-feira 03 Maio 2007 12:47
-----------------------------------------------------------
Desce tou no carro em frente ao mc donalds..
================================================== =========
View 1 Replies
View Related
Oct 12, 2004
I have time sheets from the past I need to enter but have found that some years the time punch minutes are given as if an hour equals 100 minutes not 60. Other years the minutes are given correctly. How do I format this field so that if I type 3.75 it will convert to 3.45 hours? Will I have to add another field to enter this and then convert to my field where hours and minutes are correctly entered? :confused:
View 2 Replies
View Related
Jul 13, 2006
Hello,
Could someone tell me is it possible to convert a particular column from 0/-1 to show y/n instead? Its just a simple select statement I'm doing and I need a Y or N instead or numeric!
Thanks,
R:)
View 2 Replies
View Related
Oct 10, 2006
Hi here is the original code
MAX(IIf([Book]='C',[Score]," ")) AS CScore,
Max(IIf([Book]='C',[PercentileScore]," ")) AS CPercent,
Max(IIf([Book]='C',[PassFail]," ")) AS C,
Max(IIf([Book]='D',[Score]," ")) AS DScore,
Max(IIf([Book]='D',[PercentileScore]," ")) AS DPercent,
Here is what I thought may work, but it seems like there should be an easier way
Case when Max ([Book]) = 'C' then [Score] else null as CScore,
Case when Max([Book]) = 'C' then [PercentileScore] else Null as CPercent,
Case when Max ([Book]) = 'C' then [Passfail] else Null as C,
Case when Max([Book]) = 'D' then [Score] else Null as Dscore,
Case when Max ([book]) = 'D' then [PercentileScore] eslse Null as DPercent,
Thanks
K
View 3 Replies
View Related
Dec 4, 2006
I am trying to convert a whole number to a start time w/ no luck. Assuming "0" is 12:00 AM, I have a start minute of "480" which would in essence be 8:00 AM. Can anyone tell me if I can somehow convert this to time in my query? Thanks.
View 3 Replies
View Related
Mar 3, 2008
Hi All,
I have a table that has fields that captures dollar amounts. I have these fields set to a default value of "0".
The tables are updated via a query that imports a csv file. Once the import process has finished, my table has blank values in some of the fields that capture dollar amounts.
If a field populated by the csv file is left blank, I would like for the field to show $0.00.
How would you recommend handling this?
View 5 Replies
View Related
