Help! Can't Install Access On Multiple PCs
Aug 2, 2007
I'm setting up a DB for my wife's machine shop. She has Windows 2000 (for accounting purposes) and her assistant has XP. I have 2000 at home so I installed Access 2003 on my computer, created the database, table, query, macro, and switchboard, and it works great.
Problem? Apparently, I cannot use the same product key more than twice.
I installed it on my wife's machine, but couldn't activate it on her assistant's machine.Microsoft says this is in the end user license agreement, and I'll have to take their word for it cuz I didn't read it.
My question: Is there some sort of workaround for this? If I deactivate it/uninstall it on my machine will that help? I don't need it now that the db is set up anyway.
I just need to get it activated on the 3rd (assistant's) machine ASAP.
View Replies
ADVERTISEMENT
Sep 27, 2005
I know its possible to have 2 different versions of Access installed, and that you have to uninstall then start in with the earliest version. BUT can I have 3 different versions? I think it should be no problem but thought I would ask first.
I am looking at 97, 2000, and 2003. Plan is to do just Access 97, 2000, and then the full office install of 2003.
View 7 Replies
View Related
May 18, 2007
I have a genuine Microsoft CDs and keys, one with Office 97 Small Business Edition, and the other with Access 97 (these are both the full version, NOT upgrades). As I got new machines over the years (both Windows 98 and Windows XP SP 2), I installed the software from both CDs without incident a number of times on on each of those machines. I now have a new Lenovo T60 laptop (again with Win XP SP 2, 1 GB of RAM, and over 100 GB of free disk space).
Word, Excel and Outlook from the Office 97 SBE CD installed normally and run normally, except that I had to rename two Registry keys to get past an error message during installation saying that htmlmarq.ocx could not register itself (see http://forum.theispguide.com/isp-ftopic2753.html). When I went to install Access on the new machine, it kept prompting me to either point it to the folder where the "qualifiying product" was installed, or to insert that product's CD, before it would let me proceed with the "upgrade" - all this despite the fact that this is definitely a full product CD, and NOT an upgrade version. I went round and round with this a number of times, and eventually got past this series of screens (I don't remember how I did it, I was just so relieved to have circumvented the problem).
The balance of the installation appeared to complete normally. However, when I try to launch Access, I get an out of memory error, even immediately after a re-boot and with no other applications running. Does anyone have any ideas about how to resolve this?
View 2 Replies
View Related
Oct 23, 2006
Recently I copied a database to another machine at a client. First problem, the open report command canceled, then thining I had a code problem I tried to open the report from the menu. It will not open or allow me to go into design mode, althouh forms and queries will NO reports will allow this. The when I try to open the forms in design mode they crap out with a msacces.exe aborted mesage.
This database works on 53 other macines so it has to be something paculiar to this particular machine. I have tried a complete unisnstall and install twice to no avail.
Version: Access 2003 sp1
View 2 Replies
View Related
Sep 11, 2005
Hello to everyone.
I am reading this forum for a while now and I learned here almost everything I know. But, now i am having problem and I really don't know how to solve it. I am trying to test some little program which I made fo my company. It is Access 2000 database and I made it with Access 2003. Everything is working 100% in Access 2003. BUT, problem is that this database will be run on several mashines in two of our companies and in that other company they have a lot of computers with Win98 installed. I have Access 2003 Developer and I managed to make deployment for computers in my resident company, but, as you probably know, Access 2003 is not working on Win98 computers.
So, I tried to install Access 2000 Runtime on those computers and I am still trying because stupid installation won't finish! It just stops when it comes almost to the end of instalation and nothing happens. I tried to wait for some time but instalation is dead. I also tried to make clean instalation of Win98, but nothing changed. There is no Access on those computers of any kind.
I tried to search forum for solution, but I didn't find it.
Please, help me!
Gile2004
Access 2003
View 2 Replies
View Related
Sep 18, 2005
Hello,
Is it possible to install two versions of MS Access on the same O.S. I already have Access97 installed. Now I want to install access 2003 without it up removing my previous access 97. If it removes/upgardes access 97 to access 2003 I will not be able to open my access 97 database.
Is this possible? and if so how?
Thanks--any help will be much appreciated.
View 6 Replies
View Related
Mar 31, 2006
Hi all..
I am not even sure if it will be possible.
I use Access 2003 and Access developer extensions for packaging the software(operating system is Windows 2000)..everytime I upgrade my software, the users need to uninstall it from their computer and then install my new version..
Is it possible to automate this process so that users click a button on the application and uninstall and install is taken care?
I know I can run a batch file using shell command...but can I create a bat file to uninstall and install? Now, users goto add/remove programs and remove their current version before they install new version.
Thanks
View 6 Replies
View Related
Sep 18, 2005
Hello,
Is it possible to install two versions of MS Access on the same O.S. I already have Access97 installed. Now I want to install access 2003 without it up removing my previous access 97. If it removes/upgardes access 97 to access 2003 I will not be able to open my access 97 database.
Is this possible? and if so how?
Thanks--any help will be much appreciated.
View 1 Replies
View Related
Sep 21, 2007
In have a db that was created with Access 2003. I recently installed Access 2007 and kept the old version as well. However, when I try to work with the db in Access 2003, I am getting all kinds of errors. When I run the same db in a machine installed only with Access 2003, it runs fine. I am thinking that it might be the reference library. Can anyone help. If it is the reference library, how can I revert back to the old reference library.
View 2 Replies
View Related
Aug 14, 2007
Environment WInXP Pro SP1, MS Access 2003, existing access project that fires on another PC with similar setup.
Just installed MS Access 2003 to my own PC. When I try and open an existing project am being informed I need to upgrade jet 4.0 to service pack 8. When I try and install jet SP8 windows is telling me I already have a later version :confused:
And howdy everyone.
View 2 Replies
View Related
Aug 28, 2005
WindowsNT 4.0 Service Pack 6 error in access runtime install
I have an access runtime install package that has worked numerous times
installing on XP Home. It was built using Office XP developer's packaging
wizard.
I tried installing it on a brand new PC running XP Home but it generates the
error:
Visual Basic 6.0 Setup Toolkit
The office system pack cannot be installed on this system because it
requires Windows NT 4.0 Service Pack 6 or later.
I cannot find any info on this - any ideas?
View 2 Replies
View Related
Dec 28, 2006
Hi everyone.
Have been testing installation of Office XP Developer Access 2002 runtime package created using the package wizard on a WinXP Pro SP2 machine, for installation on a Vista RC2 5840 machine.
After installing the latest necessary updates such as Office XP Developer SP1 among others which were essential to remove the Path/File error I had, A new error displayed itself as soon as the runtime install package launched.
-------------------------------------------------------------------
Visual Basic 6.0 Setup Toolkit (Error Window Title Bar)
The Office System Pack cannot be installed on this system because it requires Windows NT Service Pack 6 or later.
-------------------------------------------------------------------
I assume Windows NT SP6 has no relevance to Vista ???
Maybe some other update will help here. I have googled for hours to no avail.
Any help greatly appreciated.
Thank you and best wishes for 2007.
Joe.
View 14 Replies
View Related
Dec 14, 2013
I create a project in access. and i want that everybody can use in my project.
how i can do that?
View 4 Replies
View Related
Feb 21, 2006
I have a text box on a form with the Control Source set to: =Pi() It's giving me a #Name? error, as is Control Source: =Radians(34) Seeing this note in the help file related to Pi() ...
Some functions display the error #NAME? instead of a value.
Some of the spreadsheet functions are provided through a separate dynamic link library file, Msowcf.dll. If this file is missing, the functions display the #NAME? error value when you open the spreadsheet in your browser. Search for Msowcf.dll on your computer, and if it's missing, either reinstall Microsoft Office 2000 or contact your system administrator.I searched my computer for Msowcf.dll and found it installed in:
C:Program FilesMicrosoft Access RuntimOffice10
C:Program FilesMicrosoft OfficeOffice
C:Program FilesMicrosoft OfficeOffice10
I'm using Office 2000 on this computer (Front Page 2002).
View 3 Replies
View Related
Mar 28, 2007
Hi
I have created a split db for my father and his little business. Sometimes he asks me to make changes. I want to be able to email him the new front end, and when clicked, the file will install the new front end to the correct location along with any folders containing updated informatio (Images, Tables, etc)
how can i do this ?
regards
Mclaren
View 4 Replies
View Related
Nov 27, 2006
I had some work done on my Database a few weeks ago and it works great.
I just got an email from the guy who did the work and he wants me to pay him more money....he said he forgot to bill me for 6 hours.
I told him I didn't think that was fair and wasn't really willing to pay for more hours....he then said he never sent the "non-expiry" versions of the databases.....he also said I have 15 days left until they expire.
Considering I done additional work on them I was wondering if this is possible?
Bruce
P.S. I hate being taken advantage of.....he was really good to work with but now he's trying to rob me.
View 8 Replies
View Related
Mar 4, 2005
Hello,
I recently started using the Chart feature in access. Everytime the form with the graph loads up windows installer pops up and asks me to install. Since i let it install like 3 times, i click cancel and it still works fine. Anyone else have a problem like this? How can i prevent it from installing everything, since its already installed?
Matt
View 1 Replies
View Related
Dec 13, 2012
I am using Access 2010 and Excel 2010. I need to have VB script to export the access table 502 records by 38 fields into Multiple Excel workbooks each having multiple tabs. In the Access table each record has two fields: Div and Tab that will be used to name each workbook and each tab (sheet). There are 6 unique "Div"'s to name the 6 workbooks and there are several "Tab" names for each Div (workbook).
Note: These 6 workbooks with multiple tabs were originally imported into Access from one common folder on my desktop by this routine:
Option Compare Database
Option Explicit
Private Sub Command1_Click()
Dim blnHasFieldNames As Boolean, blnEXCEL As Boolean, blnReadOnly As Boolean
Dim lngCount As Long
[Code] .....
View 7 Replies
View Related
Dec 13, 2012
I am using Access 2010 and Excel 2010. I need to have VB script to export the access table 502 records by 38 fields into Multiple Excel workbooks each having multiple tabs. In the Access table each record has two fields: Div and Tab that will be used to name each workbook and each tab (sheet). There are 6 unique "Div"'s to name the 6 workbooks and there are several "Tab" names for each Div (workbook).
Excel workbooks would take names from the "Div" field and the tab names would come from the "Tab" field in the Access table. First need to find workbook name (Div - Field) then the look for each sheet name (Tab - Field) to create 1st Excel workbook with all the sheets (Tab) and repeat the process. I think you need to approach of read the Access table one record at a time keying on the "Div" and "Tab" fields in creating each Excel workbook with the associated multiple tabs (sheets) that are written to a common folder.
Note: These 6 workbooks with multiple tabs were originally imported into Access from one common folder on my desktop by this routine.
Option Compare Database
Option Explicit
Private Sub Command1_Click()
Dim blnHasFieldNames As Boolean, blnEXCEL As Boolean, blnReadOnly As Boolean
Dim lngCount As Long
Dim objExcel As Object, objWorkbook As Object
Dim colWorksheets As Collection
[code]....
View 12 Replies
View Related
Aug 25, 2012
I would like to know which way is the best way to import excel data from multiple sheets in to multiple tables in access.
For example data from Sheet1 -> Table1, Sheet2->Table2, Sheet3->Table3 etc...
I have tried using this:
Cmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel5, "Table1", "C:Importedfile.xlsx", True, "Sheet1!"
Ironically, data from Sheet2 and Sheet3 seem to be properly imported in to table2 and table3, but some of the data from Sheet1 seems to be missing in Table1 after import.
Any other ways to import the data?
View 1 Replies
View Related
Mar 5, 2008
A few months ago I installed Office 2007 on my home PC and uninstalled Office 2003.
I am contemplating the re-installation of ACCESS 2003 on my home PC, but don't want to disturb my Office 2007 install.
QUESTION: Is it possible to have both versions of ACCESS (2003 & 2007) on my PC without creating problems for myself?
NOTE: I have two hard drives on my PC (C drive, the newer one; and E drive from my last PC). Perhaps I should install ACCESS 2003 on the E drive?
View 6 Replies
View Related
Mar 7, 2006
How can I get around not being able to create multiple statements in a single query? For example, I tried to do this:
DELETE * FROM UniqueDates;
INSERT INTO uniqueDates ( Entry_Date )
SELECT entry_date
FROM [SELECT Entry_Date FROM BarcelonaInternalActions
UNION SELECT Entry_Date FROM QPTActions
UNION SELECT Entry_Date FROM TokyoInternalActions
UNION SELECT FORMAT(Entry_Date , "Short Date")
FROM RDActions
]. AS U;
but I received an error. I am trying to clear out a database and insert new records every time I run this query. I think maybe a better option would be to append any new records into the database rather than deleted and inserting a fresh batch of records. What do you think?
View 1 Replies
View Related
Nov 29, 2004
Hello, We are writing an application in access which accepts an order number.
We use the order number to read a non-access db file to retrieve the customer
number - this works fine. We would like to use the customer number to read an
additional file to retrieve the customer name but are unable to make this work.
Can anyone help please?
Additional info: In the access program we are using dlookup to retrieve the customer number from
the non access data base. This is working and the accss field is being populated correctly. We
would like to use this field to read an additional file to retrieve additional data. We seem unable to
string two dlookups together. Is this possible? regards
Private sub order_afterupdate()
accno = dlookup("customer_code", "dbo_firstfile", "order_number= forms! [rsd]![order]")
End sub
This works well, but when we include an additional statement;
name = dlookup ("customer_name", "arrcustomers", "customer_code = forms! [rsd] ! [accno]")
end sub
no data is returned.
View 11 Replies
View Related
Apr 3, 2013
I am trying to calculate [current status] based on multiple conditions. for example
Current status = A , if (w>0 and x=0 and y=0 and z=0)
Current Status =B , if(w>0 and x>0 , y=0 and z=0)
Current Status =C , if(w>0 and x>0 and y>0 , z=0)
Current status =D , if(w>0 and x>0 and y>0 and z>0)
Where A,B,C,D are text values and w,x,y,z are dates
View 1 Replies
View Related
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
Aug 22, 2005
Good Afternoon,
I have been given an access database system which runs using about 7 access databases, linked tables etc, quite complex. When a new user installs the system from a DVD the user needs to provide a password. This password is filtered to all 7 access databases so they all use the same username and password.
The problem I am having is when the user runs this application again they are prompted for their password. Everytime they click on an option which is another access database they are again asked for their password. I am trying to figure out a way once the user has logged in once on start up no matter which option they select and no matter how many time they select it while the main appliction is running they are not asked for their password. Is this possible or totally outside the scope of Access databases.
View 2 Replies
View Related
