"Microsoft Access Can't Start Because There Is No License For It On This Machine"

Mar 10, 2005

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

View Replies


ADVERTISEMENT

Microsoft Access Can't Start Because There Is No License For It On This Machine

Feb 1, 2005

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.

View 1 Replies View Related

Office 97 License Missing On XP Machine?

Jul 16, 2005

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.

View 1 Replies View Related

HELP!!! Error: [Microsoft][ODBC Microsoft Access Driver] Invalid SQL Statement Expect

Mar 27, 2007

My main experience is with MySQL and PHP so I'm kindof stumbling around in the dark here. Heres my story:

We recieved a new server and migrating from (Windows Server 2000, IIS 5.0, Access 2000) to (Windows Server 2003, IIS 6.0, Access 2003) has been nothing but problems.

I have setup IIS to work with ASP, I've also setup a system DSN. The access file was copied over from the previous server. We're running Access 2003 and now I can't seem to get this ASP script to work.

When I try to upload a file to the script I get this error:

Line: 42
Char: 7
Error: HELP!!! Error: [Microsoft][ODBC Microsoft Access Driver] Invalid SQL statement expected 'DELETE','INSERT','PROCEDURE','SELECT', OR 'UPDATE'.
Code: 0
Url: (URL address blocked: See forum rules)

Here is the part of Connect.asp that errors:

Code:<script LANGUAGE="javascript"><!--var DSNString, TheDF, TheRS;//DSNString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C: hedata estdisbo.mdb;User Id=admin;Password=;";//DSNString = "Driver={Microsoft Access Driver (*.mdb)};Dbq=C: hedata estdisbo.mdb;Uid=Admin;Pw d=;"DSNString = "DSN=testweb; UID=; PWD=";function public_ConToDB(){ TheDF = DP.CreateObject("RDSServer.DataFactory",this.text1.value);DC.DataSpace=DP;DC.Server = this.text1.value;DC.Connect = DSNString;//DC.Connect="d: hedatadisboweb.udl";}function public_GetRS(SQLCommand){ TheRS = TheDF.Query(DSNString,SQLCommand);DC.SourceRecordset=TheRS;return (TheRS);}function public_GetDC(){ return (DC);}//--></script>

Its included in a file called FileRead.htm here is the part that refers to the error lines:
Code: var TheFile, FileStrm;// Retrieved field namesvar M_ssn, M_inits, M_Lname, M_Fname, M_DSSN, M_ruc, M_paycode;var M_normamt, M_payamt, M_pgrp, M_poe, M_pltcd, Payrollnum, Payrolldate;// var Trash, FieldData, FieldNames;var TrashLineNum = 1;// Create the file Stream Object (ReadOnly)TheFile = new ActiveXObject("Scripting.FileSystemObject");FileStrm = TheFile.OpenTextFile(FName,1,false);// Setup the Database Connectionvar SQLCommand, TheRS, TheConnection, DSNString, Commands, MyDC;FieldNames = new Array("ssn","inits","lname","fname","dssn","ruc","cco", "payamt","normamt","notsureone","pgrp","poe", "pltcode","recstatus","paychgflg","paystatuscode", "payrollnum","payrolldate");// Connect the the DatabaseDataLib.ConToDB();MyDC = DataLib.GetDC();// Get Payroll NumberPString = prompt("Enter Payroll Number","025");Payrollnum = parseInt(PString,10);// Get Payroll DateDString = prompt("Enter Payroll Date","20000101");Payrolldate = DateLib.FromMil(DString);// Setup the Database Connectionvar NumRecs = 0;//MyTest = DataLib.GetRS("PaydayUpdate1");alert("About to cross into the CurExtract!!!");MyRS = DataLib.GetRS("SELECT * FROM CurExtract");

I set an alert after this line but it doesn't pop up.

ANY HELP WOULD BE VERY GREATLY APPRECIATED. I'll be checking this very frequently.

Sincerly,
Joseph Russell

View 14 Replies View Related

Data Access Pages -Office License

Mar 20, 2006

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

View 1 Replies View Related

Converting From Microsoft Access 2.0 To Microsoft Access 2003

Jul 10, 2006

Hello everyone,

I would like to convert a database, which was made for me, in order to enable it to be used on my current system.

I get the error message below when trying to open the database in Microsoft Access 2003.

The database was made using Microsoft Access 2.0.

Will I need Microsoft Access 2.0 to update/delete the database all the time?

Or can I convert this to be used with Microsoft Access 2003?

I have tried opening the file exclusively and I get the same error.

I have selected Show Help and it advises me to import all the objects from the database into a new database. This can`t be achieved as I can`t open the file to retrieve the contents.

http://images6.theimagehosting.com/error.6de.PNG

Thank you very much for your help and all responses are appreciated,
Sam

View 1 Replies View Related

Converting From Microsoft Access 2.0 To Microsoft Access 2003

Jul 10, 2006

Hello everyone,

I would like to convert a database, which was made for me, in order to enable it to be used on my current system.

I get the error message below when trying to open the database in Microsoft Access 2003.

The database was made using Microsoft Access 2.0.

Will I need Microsoft Access 2.0 to update/delete the database all the time?

Or can I convert this to be used with Microsoft Access 2003?

I have tried opening the file exclusively and I get the same error.

I have selected Show Help and it advises me to import all the objects from the database into a new database. This can`t be achieved as I can`t open the file to retrieve the contents.

http://images6.theimagehosting.com/error.6de.PNG

Thank you very much for your help and all responses are appreciated,
Sam

View 13 Replies View Related

Selling Access Database - How Do I Ensure User Has Valid License?

Feb 24, 2008

I 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.)

View 2 Replies View Related

Multiple Instances Of Access On One Machine

May 12, 2005

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

View 1 Replies View Related

Access Data Base On Local Machine

Mar 12, 2005

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 )

View 2 Replies View Related

General :: How To Hide MS Access Database On Client Machine

Feb 28, 2013

I 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 Related

Microsoft Access & Microsoft SQL.

Aug 7, 2006

Questions / Help :

What I would like to know about Microsoft SQL Server & Access 2003 :
I am a novice at creating my own database.
I would like to use Microsoft SQL Server & Access 2003 .
I have in the last 3 months read all I can about creating a database in Microsoft Access 2003 .
Now I need to learn about Microsoft SQL Server, and it is very different from Access 2003.
I have purchase many bussiness applications over the last 5 years, and fount that over software are to rigid, as I need something very specifil to my bussness.
If you intend to reply, please be very specific & in plain English.

Can someone help me ?


1Can Microsoft SQL Server 2000 work with Microsoft access 2003.
a.Is this do-able .

2Can Mysql also work with Microsoft access 2003

3What is the difference between Microsoft SQL Server & Mysql.

4And any other information that may help me.


Thank You For Your Time.
John Calcitrai.

View 9 Replies View Related

Microsoft Access HELP!

Apr 25, 2006

Ok so I have a new project. I have run all queries and appended them to my tab inventory. My mission is to take all of the query's and create a table that combines all missing parts info (I.E.> date, part#, plant, location, inventory, reorder pt.) How do i do this and if you need more information please message me back. I would greatly appreciate any help.

View 2 Replies View Related

S.O.S!! Microsoft Access !!!

Jul 4, 2007

Hi guys,

I need help with microsoft access!

I have a report writer in access which i use to generate reports from act! (a CRM software by sage).

Recently, there has been some changes and development in act! software (we added new fields into it). I am trying to update the tables in access with the new fileds, but am not able to do so.

Kindly request for some assistance.

View 9 Replies View Related

I Can't Start Access. Please Help.

Jun 11, 2007

This may sound a bit silly, but my Access 2003 refuses to start.

I recently re-installed Office 2003 after a fresh installation of WinXP. Word, Excel etc work as normal. This is the message that comes up when I attempt to start Access:

"Please wait while Office 2003 Prof. Ed. configures. Required data is being determined"

after that nothing happens.
Any ideas?

Please note that I'm using the German versions of OS and Office. My translation probably doesn't match the original message.

Thanks in advance.

View 2 Replies View Related

License Agreements

Jan 13, 2007

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.

View 3 Replies View Related

Help On License Count Sum

Apr 22, 2008

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.

View 1 Replies View Related

Microsoft Access Authentication

Oct 4, 2005

For a databse which I am going to create, I would like to have an authentication system which utilises the database users which I specify, however instaed of using a password the idea would be to use a fingerprint scanner to logon. T^his would be for an A - Level IT project and I would seriously like to know how to integrate biometric security into a database. If anyone knows how to do this please post CLEAR instruction possibly with some SCREENSHOTS if possible.

Thanks

View 1 Replies View Related

Microsoft Access Security

Jul 26, 2006

This query is in relation to an Access 97 database.

A problem that we are consistently having is that whenever people are using the database under different user names, it only allows one user at a time to use it. So basically if three of us are on it updating files or enquiring on client details, two of us are locked out leaving only one in. Any help in this matter is greatly appreciated.

View 1 Replies View Related

Doing Exam On Microsoft Access...

Feb 8, 2007

I'm not doing one this minuet but I would still appreciate help.

the exam is in the UK and with AQA.

does anyone know of any sites which will give me tasks to do to test myself.


Thanks in advance:D

View 8 Replies View Related

Synchronisation In Microsoft Access

Jun 2, 2007

Please consider the situation below:
There is a central server and there are many client PCs connected to the server. On each client PC, there is an access database file that will be frequently updated by the user of the PC.

What I want to do is to allow the user on each of the client PC to backup their database file to the central server;

At the server side, it is free to use any architecture(eg using file system or another database to store the file) to facilitate the backup purposes. One of simplest solution is to upload the entire database file to the central server everytime. However, the problem is the access database file on each client PC is quite big, hence it is better not to upload the entire file but only to upload the updated data to the central server.

Is there a way to synchronise the data with central server without upload the entire database file? What kind of architecture should built up in the central server if there is a way?

Any input is welcome:)

View 5 Replies View Related

Microsoft Access And The SCCI

Aug 3, 2007

Hi there Access forum,

First up, a pre-emptive request to excuse me if I show my ignorance - I'm not really an Access user/developer, I'm a SCM person.

We have a team that develops Access dbs and they are looking to integrate better with ClearCase. At present, they use the UNIX client and transfer whole, binary Access dbs, then source-control the binary file. They would like to be able to integrate better - my understanding, from them, is that VSS will control individual tables/forms, etc. I assume this is because it integrates via the SCC interface.

I cannot find anything about the SCC interface in my Access tool (just part of the Office distribution handed out to all desktops here) apart from a reference to Office XP Developer.

Can anyone provide me with any more information (even if that is just to point me elsewhere)?

Using VSS is not an option, by the way - the SCM standards specify ClearCase or Subversion (which would access the SCC interface via the PushOK proxy).

Thanks in advance - Adam Cheney

View 2 Replies View Related

Microsoft Access To Word, Please Help

Nov 9, 2007

Hi there, I am doing a project for my A level computing, and for my mum's financial advising.

I am to assume no knowledge of computing on her part, and so i cannot make it up to the end user to know how to mailmerge.
I was wondering if you could help.
I can have it in a query, form or table form, whichever is best for this, but i need to be able to make a button which exports a record into a MS word mailmerge. This is just to make a simple letterhead. I need a button that says " Write to client ", and once it is clicked it needs to open a letter addressed to them. This is my problem. I have noticed when the data is in a report, there is an export to MS Word button, which is very close to what i want as i could use that and get a good enough mailmerge, but is there a way to run this from a macro or using VB? I did VB last year for my computing project and so i understand a fair amount of it. I want to just make one word document, which will open as mailmerged with the clients data.
Please help if you can, I am sure it is possible as i can see you can mailmerge from access, and there is even a button to do it.... kind of, i just need to be able to make my own.
Thankyou so much for your help.
Steve
( Microsoft Access 2003 )

View 1 Replies View Related

Microsoft Access HotKeys

Jan 23, 2008

Greetings All,

I work for a College within my area and have recently been asked to create a database for storing and testing data. With mild experience, I believe I have done well so far but a co-worker asked me the other day if there was a way to create or modify the hotkeys in Access. I've tried researching this on the Net and only found lists of which hotkeys do what. If anyone knows whether or not adjusting hotkeys is doable, please let me know.

Thanks for your time and have a great day...

Kyle

View 4 Replies View Related

Microsoft Access Help Needed

Jan 11, 2005

Hello there

I am trying to sort out some data. Because it is too huge for microsoft excel, I have to use Access to open it. But when I managed to open the data and wish to edit the data, it keep popping out this message "Updating data in a linked table is not supported by this ISAM"

Can anyone help me to sort this out?


Thank you very much

View 2 Replies View Related

Microsoft Access Combo Box

Apr 28, 2005

I have 2 combo boxes. When the form loads
the user selects a value from the combo box if the value is
not 10 or 99 i want the user to be able to select a value from
the list in the combo box else i want it to put in 0, 173 respectively
when i put the formula in the control source i can get the values
0 and 173 to work but if the user selects a different value then
i am unable to select any thing from the list?? can someone please
help me
thanks

View 1 Replies View Related







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