Access 97 Run Time Installer?

Aug 28, 2005

Hello,
I have a roof-estimating program that I made in MS access 97. I want to sell it to online. However the buyer will have to have access 97 installed on their computer to be able to use my program. Is there a way to allow users to use my program with out them having access 97 installed on there computer? And if so how involved is it to make this work?

I’ve been reading about the access developer’s extensions for access that makes a run time version of an access program. Will this work in my situation. I’m using access 97. I've seen some web sites with run time installers. Do these programs really work like they say?

Will I need to re-write my program? And if I do need to re-write it, is there a certain way that it needs to be written in order for this to work.

Please Help

Thanks Chuck patentinv@sbcglobal.net

View Replies


ADVERTISEMENT

Make An Installer For DB

Jun 24, 2007

My DB has around 20 users and frontend is on local machines and back-end on server. I always copy front end and many batch files associated with db and paste them onto local machines. Then create a link and paste on desktop. I always make a folder name "DMSS" and pase all copies files in that. But frequently becuase of one or other problem, I need to do this exercise again on many PCs.

Now I want to make an installer CD like we buy for softwares, which on running will do all this work.

Can somebody guide me to the right direction?

View 3 Replies View Related

My System Is Ready Now. What Is The Best Installer I Can Use

Jul 21, 2007

After hard work done, my system become ready. Now I want to deploy it in the clients computers. What is the best installation software my system files from the CD disk into the user computer?


Thanks Very Much

View 1 Replies View Related

Custom Installer Of Database?

Aug 18, 2007

I'm looking at creating an automated system to install the database. I know that with the access developer kit it includes an installer package creator, however it doesn't have some features I'm after.

Basically, I want it to obviously copy the database file into a folder (that the user specifies) and create a shortcut if the user specifies to the desktop and/or start menu. But then there is a back end, so I want the option to specify if the machine it is being installed on will be hosting the backend or not.

Then it needs to install access runtime as well, then copy a DLL file and .bas file into the same directory as the front end, then copy a DLL file into a system folder and then register that DLL file within windows.

Do I need to create a separate program all together, or is there something that'll allow me to do this?

Thanks very much

View 10 Replies View Related

Windows Installer Issue

Aug 28, 2007

Hello there,

I use access 2000 but also have access 2003 installed on my computer. Access 2000 is my default version and is usually what I use 90% of the time (for various reasons).

Anyways, every time I launch 2000 (without going into 20003 at all) it ALWAYS brings up windows installer. Is there a way to fix this or must I live with it since I have 2 versions installed?

Thanks!

View 2 Replies View Related

Huge MDB (Need To Create Installer Or Updater)

Jul 2, 2007

Hi all,I'm in a bit of a dilemma here. We currently have an mdb which includes a form and 4 tables. The entire mdb is around 800 megs. What we used to do is distribute this mdb to users in completely different locations on a CD, but now it has become to large for a cd to hold. Our manager wants us to figure out a way to distribute this mdb using only 1 cd, without zipping it. How would i go about doing that? Is there currently an installer, that can download the database from our ftp site and then insert the tables, or is there any other easier way i can get this done? P.s. The database will likely get larger and larger every yearThanks in advance

View 14 Replies View Related

Windows Installer Issues, When Using Chart

Nov 23, 2004

I am sure this has been asked before but i have searched and found nothing,

I have 2 versions of Access on my PC 97 and 2000, if i use the chart facility i always get a box appear saying windows intaller and then goes on to ask me to insert a certain disk from the office package.

but if i click cancel quick enough it bypasses the enter disk part..

how can i overcome this please.

View 2 Replies View Related

Forms :: Add Time Value To Time Data Type SQL Server Field In Access

May 6, 2015

how to be able to enter time in access form the same way as if would be an access table (1p = 1:00 PM; 1.25 = 1:25 AM etc)

View 1 Replies View Related

Time In Access: Keeping "medium Time" Format

Mar 25, 2008

I've run into a bug, I think. I have a time field with it set to show "Medium Time" which is "hh:mm(AM/PM)", however, when I combine the information with another field in a query (=[OfficeDay]&" - "&[POfficeTime]), the time comes out as "Long Time" or "hh:mm:ss(AM/PM)". End result is Wednesday - 10:30:00AM when it should be Wednesday - 10:30AMDoes anyone know a way around this?

View 1 Replies View Related

Time Format - Short Time Displayed As Medium Time

May 23, 2006

I have an application with a backend db on PC 1, and the same application on PC 2 linked to the backend db on PC 1 via the network.

The link works fine but the time formats are different.

On PC 1 the time format is shortime and displays as it should i.e. in 24 hour clock format

However on PC 2, opening the same database via the network, the time format is still shorttime but when you read the time within the code it comes out in AM/PM format. Also, when the defaul tiem should be #20:00:00# but this changes to #8:00:00 PM#

Weirdly though, when you just open the table, the times are in the correct shorttime format.

Guessing, it must be a setting within the main core of Access 2003 that is different between the 2 instances?

Any ideas?

This screen shot may help:

View 2 Replies View Related

Time Format - Short Time Displayed As Medium Time

May 23, 2006

I have an application with a backend db on PC 1, and the same application on PC 2 linked to the backend db on PC 1 via the network.

The link works fine but the time formats are different.

On PC 1 the time format is shortime and displays as it should i.e. in 24 hour clock format

However on PC 2, opening the same database via the network, the time format is still short time but the format is in AM/PM or medium time.

Guessing, it must be a setting within the main core of Access 2003 that is different between the 2 instances?

Any ideas?

View 1 Replies View Related

MS Access Run Time

Feb 10, 2006

I want to know more about the MS Access Run time edition. If I prepare pakage in MS Access and installed in one server, shall i share the forms in client computer using Run time?

Pls. give more details.

Regards

View 5 Replies View Related

First Time Using Access

Sep 20, 2007

Ok i have a few issues with my database, basically i have a form with a subform running from two tables. These tables are to record faults and the subform holds any updates and progress made.

Basically i am trying to make a facility that only prints out the current job being looked at in form view, but i want it to print in a printable view as apposed all the graphics on the form.

As well as this i have created a form and on this form i have a combo box which contains equipment! how do i create a filter type thing so when i select the appropriate equipment and run a macro it gives me a report only on the forms with said equipment.

I am poo at SQL and scripting so if anyone can help me i will be very happy!

View 6 Replies View Related

Time Clock App In Access

Jun 6, 2005

Has anyone ever made a time clock application in Access? If so, can you post a sample application? I'm really at a loss with this one..

Thanks,
Cran56

View 4 Replies View Related

Access 2000 Run Time

Mar 16, 2006

I have a rather large project that has been developed in Access 2000. Generally all my distributions have been to PC's with Access available. However, I do find that there are a few that don't. Obviously this is where Run time would be useful. Having never used it I have a few questions if someone could possibly help:-

1 If I have a program developed in Access 2k can it be converted to the MOD version to include runtime?
2 If there is a conversion process is it automatic or does it require extensive reworking of the project?
3 Is it still possible to purchase MOD 2000 or do I need to get an updated version and if so will that still work with Office 2k?

Thats about it. Thanks

View 2 Replies View Related

Access Help With Time Intervals

Aug 1, 2006

Hi, I am just learning Access and are having problems dealing with time intervals. My database form is seperated into two tables and in each column of the tables there are different time periods. The time periods are created by having two columns and one column is the start time while the second column is the end time.The problem is that in order to tie the two database together i have to group the database use the time periods as a key. But since the two tables time periods are different, i have to first seperate time intervals to specific months. My plan first is that using queries, i will insert new rows and in those columns i will have both the start month column to end month column both be the same month, but i could never figure out how to duplicate my information and change only the month. Now i am at a loss and i really need help for the project. I am sorry for the poorly worded explanation but i can't think of a easier way to say it. Please advise me on what to do and thank you for reading.

Best Regards,
Kane

View 6 Replies View Related

Run Access In Run-time Environment

Aug 17, 2006

Hi,

I was wondering if anyone would be able to help me here.

I have a database created in Access .MDB. It operates allright on my machine. However, since this database is done for my client, i have a problem i need to ask for help.

My client doesn't have microsoft office software installed on their machine. So when i passed the database onto them, they somehow can only run it in the run-time environment. Don't ask, I'm not sure about this at all. Anyway, They came back to me saying that they have got a run-time error message in the middle of running the database.

On my end, it's hard for me to debug since it works fine here. I was wondering if anyone would be able to tell me how i could have this database run in the run-time environment as my clients do. This way, i could debug the problem.

Is it possible for me to run my access database in run-time environment? how do i do that?

Thank you in advance

View 7 Replies View Related

More Than A User To Access The Db At The Same Time

Mar 14, 2007

Hi all
How are you?
I have a small problem...
I have an access db called MainDB, which has tables, queries, data entry form. This db (MainDB) is located in the network server.
I have another access db called BranchDB. This db (BranchDB) has no tables, it has linked tables to those tables from the MainDB, and it has the forms for view only (No Data Entry).
The problem is that users from there local machines can not access the BranchDB at the same time.
What can I do?
Your help will be highly appreciated.

View 8 Replies View Related

Unix Time In Access

Jan 19, 2007

hi all

I'm using MS Access 03 to run some queries on a SQL database. 2 of the columns i pull from SQL are about time, but are stored in 'unix time'. can this be converted once in Access to a more readable format eg ddmmyyyy?

any help would be much appreciated

View 4 Replies View Related

Access Time Formating

Oct 7, 2004

I am constructing a databse for Time and Attendance and wish to have a cumulative total column for the hours worked in the month, the Time in/out, lunch and TotalHours fields are using the ShortTime format but when the total hours exceed 23:59, obviously the field will not accept this Data, any ideas how i can record the TotalHours worked in a month.
Many thanks in advance for any suggestions.

View 3 Replies View Related

Date And Time (SQL Vs MS ACCESS)

Sep 7, 2007

Hi guys, im really unfamiliar with MS access so could use a bit of guidance.

I have an SQL server back end and MS access front end, im trying to run a simple date query to look at records with todays date only.

In sql it would be something like: -

SELECT Contract, convert(char(10), DispatchDate,103) as [Dispatch Date]
FROM BinLocations
where convert(char(10), DispatchDate,103) = (select convert(char(10), getdate(), 103))

I know i can use date() within MSaccess, but not sure i would convert the datetime field within sql to display this in msaccess.

Anyone have the ms equivilant to my sql query?

Thanks in advance

Note: datatype for this field within sql is date/time

View 1 Replies View Related

Convert UNIX Time To MS Access

Jan 22, 2006

Hello everyone

I’m trying to find a way to convert a UNIX timestamp to the standers universal timestamp. At this point I can’t even make sense of the UNIX time stamping system.

I would like to be able to use Microsoft access to do the conversion.

Does anyone one a why to convert the UNIX timestamp into a MMDDYY formatted time. Any help would be greatly appreciated


Thanks

Corey

View 1 Replies View Related

MS Access Time Delays After Insertion

Nov 6, 2006

Dear All,

I am facing a strange problem off late with the MS Access database. After Insertion of records, I close the recordset and not the connection as I use a global connection, which is set at the time of the app launch. Now, after closing the recordset I move on to the next job in the program flow and return a success to the calling function. Once the value is received by the calling function it opens the same table and finds no records there. I could come around this prob by providing a delay of a few seconds and then returning the value to the calling function. Can someone help me understand this prob and the solution to this?

Thanks in advance.

Chillgeek

View 6 Replies View Related

MS Access Error At The Time Of Opening It

Dec 25, 2006

I have created a database then saved it to my computer.
Now while I am trying to open MS ACCESS in my computer I am getting an error message -

"This file may not be safe if it contains that was intended to harm your computer.
Do you want to open this file or cancel the operation?"
Giving the options - 'CANCEL' 'OPEN' 'MORE INFO'


How can I by pass this dialog box?

View 2 Replies View Related

It's Time!! Access 2007 Runtime Now Available!

Jun 25, 2007

Access 2007 Download: Access Developer Extensions:
http://www.microsoft.com/downloads/details.aspx?FamilyId=D96A8358-ECE4-4BEE-A844-F81856DCEB67&displaylang=en

Access 2007 Download: Access Runtime:
http://www.microsoft.com/downloads/details.aspx?FamilyId=D9AE78D9-9DC6-4B38-9FA6-2C745A175AED&displaylang=en

Enjoy!
:)

--------------------
Jeff Conrad - Access Junkie - MVP Alumni
SDET - XAS Services - Microsoft Corporation

Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com

----------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.mspx
----------

View 11 Replies View Related

First Time Access User Needing Help

Jan 18, 2008

Hi
I am a teacher using Access 2007 for the first time.
I have downloaded and created a Student Info database which contains details of nationality, guardian's contact info, etc.
I also have an Attendance Excel Sheet which calculates daily / monthly attendance in its most basic form.
How do I link the cells that show the current attendance of each student to the Access db? Can I link it so that it appears on the db forms / tables / individual student page?
Please advise.
I'd appreciate the coming to me in painfully simple steps.
I teach English and Humanities and am not well versed in computer language ... although I enjoy its challenges and use a lot of it for teaching and administratie purposes.
Thanking you in advance,
Kscape.

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved