Hi,
I´ve installed office97 professional on a computer with office 2003 standard on it.
When I try to start access it tells me there is no license for it on the machine.
Has anyone else had this problem? Of course I have a license, and there has never been any problems with it in the past.
The 2003 version has not yet been registered, if that might have something to do with it.
Fuga.
I recently bought a new computer and it was kinda cheap, so no office products were installed on the computer. A friend loaned me her copy of Office 2003 which didn't have Access on it. So, after installing Office 2003 I picked my old Office 97 CD and installed just Access 97. Then I go to open the database and get this annoying message.
Microsoft Access can't start because there is no license for it on this machine.
Can anyone help? Thanks for your time.
Hello
At our firm we have a mix of Microsoft Office (2000) Standard licenses and Microsoft Office(2000) Professional liceneses.
After reading through a lot of literature from Microsofts own site it is possible to create Data access pages to enable users to view and have basic inputting into an access back end database.It also states that you need a qualifying License to use microsofts 'web components' to be able to do this.
Now another of our offices has decided to 'check' with microsofts helpdesk about wether or not you need a seperate access license for each user and suprise suprise Microsoft state you do.
Their own site states that Office standard IS a qualifying license see here
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k2/html/deploydap.asp
but microsoft are saying otherwise....
Anyone know if i am commitiing an offense or am i just being bullied by microsoft.I have asked them to produce the legislation that states i am doing wrong but they have not yet responded
cheers
Trying to use Access97 on Windows XP and I get an error message.
"Microsoft Access can't start because there is no license for it on this machine"
I've tried everything and it still doesn't want to work.
I've uninstalled and reinstalled
I've tried to find the font, hatten, and it's not there
I've downloaded MDAC 2.8
I've check the permissions in HKEY CLASSES ROOT
I've tried c:setup/y
I've downloaded AcLicn97.exe and it tells me that it can't find Access
If anyone can help, please let me know
My office is upgrading from office 2000 to 2003 this weekend. Should I run the
"Tools - Database Utilities - Convert Database - To Access 2002 2003 Format"
I have about 10 small databases various users access. Is it good practice to run this or just keep it in an office 200 format? Thanks.
Hello
I am in the process of creating my first commercial databse and i was wondering if anyone new where i can get a template of a generic user licence text?
Any assistance would be appreciated.
Hi. I have a table that contains licence details.
LicenceAgreementID / LicenceKey / NumOfLicencePurchased
Each licence agreement can have one or many licence keys, each licence key can have one or many licences
I would like a query that groups by LicenceAgreementID then sums the NumOfLicences for the the LicenceAgreementId.
Query so far:
SELECT tblLicenseDetails.LicenseAgreementID, tblLicenseDetails.LicenseKey, tblLicenseDetails.NumOfLicensePurch
FROM tblLicenseDetails
GROUP BY tblLicenseDetails.LicenseAgreementID, tblLicenseDetails.LicenseKey, tblLicenseDetails.NumOfLicensePurch
HAVING (((tblLicenseDetails.LicenseAgreementID) Is Not Null));
It may be that I have to redesign my tables, if so I will will.
Current Output:
LicenceAgreementID...........LicenceKey.........Nu mOfLicencePurchased
12345..............................AAA-BBB-CCC.....10
12345..............................ZZZ-BBB-CCC.....10
12345..............................XXX-BBB-CCC.....10
The output I would would be:
LicenceAgreementID...........LicenceKey.........Nu mOfLicencePurchased
12345..............................AAA-BBB-CCC.....30
......................................ZZZ-BBB-CCC.....
......................................XXX-BBB-CCC.....
or something along those lines!
Can anyone share my vision?
Thanks,
Phil.
Hi,
I have an Access database built by someone else and I need to make a change.
The database works fine on the client machines but does not work on my Development PC.
What happens is when it starts up I get the initial program screen but when I try to launch any data form I get the title error messge.
However, It does however work on an older PC I have here (which has the same configuration).
I am running Windows XP with Office 2003 - this is the same thing that both the client and other PC have.
In general Access works fine on the new PC and there are no specific
Any thoughts on whats going on? I want to use the Development PC as the old one is very slow and has basically been retired.
Thanks
I want to display the license agreement, which is a one page Word or PDF document, in form or report or whatever.
View 3 Replies View RelatedI am developing an Access database, and using the Access 2007 Developer Extensions to "compile" it into an installable program which includes the freely distributable Access 2007 RunTime, for users who don't have it already installed.
I am planning on charging a subscription fee to use my Access database. Are there any existing method for handling making sure the user's subscription is still active, and if not, either locking them our or preferably making everything read-only? If there aren't any existing methods anyone can point me to, does anyone have any ideas?
I plan on being the person who installs the application the first time, however I'm sure instances will come up where I instead mail the user a CD for them to install.
Regardless of whether I complete the first install, I'm not interested in going to each users' location periodically regarding the subscription.
I'm more interested in going the route of the user typing in some type of registration code, which is validated for read/write access for a period of time.
I don't want to rely on the user having an internet connection, but if they had one, I could certainly go the Microsoft model (try internet verification, if it goes wrong or there isn't a connection, have user call in.)
I have a text field in a table .. I would like the default value for that field to be the machine name. How do I do this? I know how to set a default value for a date or piece of text. I imagine it would be something like: machinename(), that's about as far as I get.
View 2 Replies View Relatedok im making a database for a tumble prosses at work
first problem:
i have a yes/no field in a table "pull ontime"
witch i want to be controled by "pull actual" witch it a time filled in with the now() comand trigered by a button in a form i want to make the "pull ontime" field read no if the time is over 1hr over a value "pull" and read yes if under this 1hr
second problem:
there are machines that are loaded with parts i want to make it so when they enter the part # and the s/o # and stuff they will hit a loaded buton witch i want to make it put the Now() time in the "Loaded" them based on the operation witch has 2 cycles witch depending on the operation the first cycle could be 2 hrs and the 2nd could be 1.5 hrs i want it to based on the operation selected set the time that the oporator has to change the cycle "rinse" and "pull"
Basically, I have a database table that is maintained every week. It is about e-mail account licenses for Office 365.
Each column represents a week of license data for every mailbox account which is about 10 000 plus users with the date as the field headers( something like "License information as of 06122013").
Basically, I have created 52 queries based on the license type I require to be calculated & I have a form created to control it. However, right now it is all output only as I have yet to create any user parameter to specify on any of the queries about the date I want
As I am currently unsure how to specify all the queries to use one field date header which I want the user to specify via drop down list in order to calculate all the licenses on this specific date.
For example, if I want to see the license information for 06/11/2013, I would choose "License as of 06112013" & it would then run all the queries based on the header specified earlier & output that information on the form.
Right now the queries are all configured as the "Select" type.
Hi, I would like to recreate a record locking problem (error # 3218) our users are experiencing on an application we have developed. I currently do not have access to a network, so I would like to run multiple instances of Access on one machine. How do I do that?
Thanks,
Bill
I'm needing a pop up adding machine that will copy and paste a calculated value into a text box on a form when the calculator is exited....much like banking teller's have on their transaction pages.
View 1 Replies View RelatedHi all
This is an ongoing problem I have had for 4 weeks now.
I have made a a system thats acts like a clock In/clock out Out system.
the structure is somthing like this
ID
Username
tblDailyLog
TimeIn
MorningBreakOut
MorningBreakOut
LunchOut
LunchIn
AfternoonOut
AfternoonIn
TimeOut
All fields apart from ID (autonumber) and username (String*255) are Date field (there are a few others like DateOfTimesheet etc but they arnt important here)
When a user arrives in the morning they make a record which they use for the day
They then have a form with a whole bunch of buttons which simply updates the correct field. For example they click the "Sign in for the Day" button and it updates the correct field with the current time.
Everything was going fine until people noticed that every now and again a sign in time dissapeared.
I have hacked myself to death trying to solve this problem but still the updates go Astray.
Now each time a time is updated the process goes somthing like this
1. the user opens their timesheet for the day (the RS is SNAPSHOT and no locks)
2. User Hits a sign in/out button
3. The record source is changed to "" and all buttons hidden (to ensure the record isnt locked and to make sure you dont do two things at once)
3. The table is updated with the new time (using some dynamic SQL)
4. The table is repeatadly checked using a DO loop to make sure the the correct time went in.
5. when the returned time value of the field matches the varaible used to update it, the form is returned to normal and the user carries on his/her merry way (if it never matches the screen should crash but this never happens).
6. A New record is added to another table called "tblbugfixinglog" which records which field was updated and when. This is so that I have two records in two different ways (figured if one went astray I could pull it back off the other)
7. Another new record is added to yet another table called tblSQLRecord, which simply logs all .RUNSQL statements that are executed.
I thought that the two extra tables (and the check that the record had been updated) would help me track down where the records are going missing, but this isnt the case.
Now it appears that some records arnt being added to tblBugFixingLog and to tblSQLRecord either and some of these tables are getting quite a few #ERROR's in them..
None of the tables are related to any other and i've no idea how #ERROR lines are appearing in a table that has 1 function... to recieve new records ... no editing, no viewing, no deleting.
Does anyone have any idea how these updates/inserts can go missing or create #ERRORs.
I've built plenty of Databases in my time and have never come across this.
__________________________________________________ ______________
This is the function I use to add a record to tblBugfixingLog and tblSQLRecord
Private Sub AddBugLog(ByVal TimesheetNumber As Long, ByVal FieldUpdating As String, ByVal NewFieldValue)
Dim TempSQL As String
TempSQL = "INSERT INTO tblBugFixingLog (TimeAndDateOfEntrySERVER,TimeAndDateOfEntryPC,Fie ldUpdated,NewEntry,UserID,TimesheetNumber,Computer AssetNo) VALUES (" & _
"#" & Format(ServerGetTime(Environ$("LOGONSERVER"))) & "#," & _
"#" & Now & "#," & _
"'" & FieldUpdating & "'," & _
"'" & NewFieldValue & "'," & _
"'" & GetNTUser & "'," & _
"'" & TimesheetNumber & "'," & _
"'" & fOSMachineName & "')"
' MsgBox TempSQL
DoCmd.RunSQL "INSERT INTO tblSQLRecord (Username,DateAndTime,Screen,TheSQL) VALUES('" & LoginInfo.sUsername & "','" & CStr(Now) & "','Add Bug Log function','" & CleanData(TempSQL) & "')", False
'CleanData is a function that removes ' and " from the SQL string so i can easily add the SQL string into the table
DoCmd.RunSQL TempSQL, False
End Sub
Public Function CleanData(ByVal DataToClean As String)
Dim TempData As String
Dim i As Integer
TempData = ""
For i = 1 To Len(DataToClean)
Select Case Mid(DataToClean, i, 1)
Case "'"
TempData = TempData & "`"
Case """"
TempData = TempData & "`"
Case Else
TempData = TempData & Mid(DataToClean, i, 1)
End Select
Next i
CleanData = TempData
End Function
__________________________________________________ ____
I have no idea how this can create #ERROR lines in the table when it is just added to and nothing else.
Does anyone have any clue to what may be happening here.
(Oh yeah and no matter how hard I try, I can't replicate the problem.... works for me every time no matter how harse I am to it!)
Please save what little hair I have left and give me some hope
Cheers
Homer
Am fairly certain that I will be asked to design and implement a Machine Status Application.
Description below is very simplistic but believe you will get the idea
Basically simple stuff at Machine Operator. He clicks a command button on a display that signifies machine is okay or not. This updates machine status. Image it just toggles between Running and Stopped.
Each minute little process runs to at 1 to Run value or to Stop value. Okay so this will get a little more complex for sure.
Now I could end up collecting data on say 100 machines. Okay so I would not expect the status change to occur any more than once per hour on average so it would be a bit like having 100 very very slow users on the system.
Now the crunch. What effect (if any) would these 100 very very slow users have on performance and particularly the One much quicker user who is executing preset queries one after another for say 20 seconds every minute.
Thoughts and opinions welcome
Len
I have a number of checklists for my machinery
i have attached a couple of check sheets I have attached my table structure and an example of my check list in XLS format
i need to track which of these checks are being carried out each week..
I have created 3 tables so far, 1 called tLine and 1 called tMachine and 1 called tActivity
tLine
LineID (PK) - Autonumber
LineDescription - Text
Not sure if my use of PK is right, should it be the MachineDescription that i make the Key?
tMachine
MachineID (PK) - Autonumber
MachineDescription - Text
Not sure if my use of PK is right, should it be the MachineDescription that i make the Key?
tActivity
ActivityID - (PK) - Autonumber
Activity - Text
StdTime - Number
Not sure if my use of PK is right, should it be the MachineDescription that i make the Key?
-----
I am having a few issues i could really do with some help with please
Line 1 has a Filler and Capper
Line 2 has a Filler
Line 3 Has a Filler and a Capper
if i focus on the filler:
I have 5 checks to do on this however the Stdtime on activity 5 is different on Line 1 and Line 3 but the activity is the same.
if i focus on the capper:
this has 2 differnet activities and 1 activity which has the same description as the filler activity.
Problem 1:
Table Setup - not sure i am using the PK correctly etc, have read a few reference guides etc, but am struggling with this..
Problem 2:
how do i link the activitys to the machines and the machines to the Lines
Problem3:
how do i account for the same activity but different std times.
Problem 4:
I need to track these checks but i will try to get the table structure right first
I really would appreciate your help here please
Hi,
I'm trying to establish the link from my local mdb to an mdb on a commercial server I'm using.
The problem is there's no way to locate the remote access database when using the Link Table wizard.
Anyone knows how to establish that connection??
Thanks in advance!
Hello, I'm a newbie at using access database on local machine.
I have worked with it before on a hosted site ,but need to know how to go about using it to host my database driven site on my local pc.I'm using maxwebportal ,which I have been using for a few years, After I install iis on my winXP Pro pc ,what do I have to do for my database to work,? is there something that I need to enable? thanks for any help Aussie )
I have a number of checklists for my machinery
i have attached a couple of check sheets I have attached my table structure and an example of my check list in XLS format
i need to track which of these checks are being carried out each week..
I have created 3 tables so far, 1 called tLine and 1 called tMachine and 1 called tActivity
tLine
LineID (PK) - Autonumber
LineDescription - Text
Not sure if my use of PK is right, should it be the MachineDescription that i make the Key?
tMachine
MachineID (PK) - Autonumber
MachineDescription - Text
Not sure if my use of PK is right, should it be the MachineDescription that i make the Key?
tActivity
ActivityID - (PK) - Autonumber
Activity - Text
StdTime - Number
Not sure if my use of PK is right, should it be the MachineDescription that i make the Key?
-----
I am having a few issues i could really do with some help with please
Line 1 has a Filler and Capper
Line 2 has a Filler
Line 3 Has a Filler and a Capper
if i focus on the filler:
I have 5 checks to do on this however the Stdtime on activity 5 is different on Line 1 and Line 3 but the activity is the same.
if i focus on the capper:
this has 2 differnet activities and 1 activity which has the same description as the filler activity.
Problem 1:
Table Setup - not sure i am using the PK correctly etc, have read a few reference guides etc, but am struggling with this..
Problem 2:
how do i link the activitys to the machines and the machines to the Lines
Problem3:
how do i account for the same activity but different std times.
Problem 4:
I need to track these checks but i will try to get the table structure right first
I really would appreciate your help here please
I am facing a issue in accessing my db file in server. I just splitted my database into front end and back end , placed in a local folder which is shared in network . I opened the files in network from my colleague machine and everything was working fine yesterday .. but right now i am getting error like "the network path is not found " 0X80070035 which tells that check whether the source machines is able to accept file sharing ..I googled and tried 2 solutions Like turning off windows firewall and enabling NetBIOS Over TCP/IP..
View 10 Replies View RelatedI have a query which is currently using a prompt box to ask the user to input a machine number. This is run from a button on a form. Press the button and the prompt appears .I would like to now do one of two things either make a form with every machine number on it or use a combo box to select the machine number. My problem is that I don't know how to get the combo box or the control button to link to the individual machine number.
View 2 Replies View RelatedI have developed .net application ....at back end I am using ms access database. When I deploy my application at client end , I want only my ms access database should accessible to application only. Client should not be even to see which type of database i am using or its business logic .
View 7 Replies View RelatedI've been told numerous times that a shared database should have each user with their own FE. I've also seen in a number of places that the FE should be on the user's local machine. Is the FE on the local machine to limit network traffic only, or is there a greater reason for it?
I was under the assumption that the seperate FE's were to lower the probability of corruptions and sharing of local temp files... If this is the case, is it reasonable enough to have each user have their own FE in their own user folder on the network?
Hi,
I have this project where I need to scan the MRP zone on the passport to my form. Let me first explain what is MRP zone. MRP is know as Machine Readable Passport Zone which you usally find on the first page of US Passport right under the Photographs and it looks like this
P<USAERIKSSON<<ANNA<MARIA<<<<<<<<<<<<<<<<<<<
0550667081USA6908061F9406236ZE184226B<<<<<14
1st Line
So P stands for Passport and Contry code is USA and then last name Eriksson and first name Anna and middle name Maria.
2nd line
Passport number and Date of birth and sex and so on.
Now I am in process of ordering a keybord that has a MRP reader on the top( http://www.accesskeyboards.co.uk/ATB420%20Reader.htm ) from this company in UK. You can find the specification on the keyboard from the above link.
So as soon as I scan/swipe it, it will give me information in the following format.
FIRST NAME, LAST NAME, DOB, SEX, PASSPORT NUMBER.
SO ONCE I HAVE THE INFORMATION IN COMMA FORMAT, HOW DO I GET THIS DATA INTO MY RESPECTIVE FIELDS INSTANTLY, AS SOON AS I SWIPE THE PASSPORT.
My field name in the table are
LastName
FirstName
BirthDate
PassportNo
MaleFemale
Thanks.
Rajput