Problem With The Package Wizard
Aug 2, 2006
I have Access 2003 and the Developer Extensions which allow me to package solutions and distribute them with the toll-free run-time set.
When I run my applications on the development PC with the "/runtime" switch the applications work fine but when they are installed on a PC without Access 2003 they install but refuse to default values into forms when new records are created. Since any "child" records need to contain the key of the relevant "parent" record for the database to have any relational structure at all this makes the applications useless. I've searched Microsoft sites until I'm blue in the face and I've asked my support company but I'm not getting any answers. Anybody got any ideas?
View Replies
ADVERTISEMENT
Jun 9, 2005
Ok, I have Acc2k3 professional with Visual Studio Tools for the Microsoft Office System which according to MS includes the Microsoft Office Access 2003 Developer Extensions (http://msdn.microsoft.com/vstudio/office/officetools.aspx) that are required to package an MDE/ADE file using Acc2k3.
The question is how do I run it? I cannot find anything to do with packaging or deploying an Access file anywhere, not only in Access but ot the system and on the Visual Studio Tools for the Microsoft Office System cd.
I should point out that my PC has VB.NET 2003, Office 2003 (prof) and Office 2000 (prof - Access only) installed on XP SP2 (I believe that all relevant SPs and critical updates have been applied). I have tried upgrading my project from Acc2k to Acc2k3 and all to no avail.
TIA
Marcus.
View 3 Replies
View Related
Dec 15, 2005
Hi
I hope someone can help on here with this.
I am having problems using the package wizard. I can run through the first couple of steps on the package wizard, but when it asks for a language to cache, it fails to install the necessary files.
I have found the resolution on the MS KB site about copying the files to the HDD, and the renaming the exe file to SETUP.EXE, but whenever I select this file to cache, I get the following message:-
'C:SourceSETUP.EXE' could not be copied to 'C:Documents and SettingsusernameApplication DataMicrosoftAccessADE11Cache1033SETUP.EXE'.
Verify that the source file exists, that you have write permissions on the destination folder. etc
I don't think it is permissions, as it does copy the msi and cab file to that particular folder, it's just the SETUP.EXE file that it doesn't copy over.
Has anyone ever experienced this before when using the Package Wizard?
Thanks
View 1 Replies
View Related
Jul 18, 2007
Hi,
I have just started to use the Access 2003 Package Wizard and I am having big problems, my problem is that any Access App deployed at work is installed under C:MIS, but in there wizdom!!! MS have decided not to allow you to have anything but what they think you should have as the default install location.
I have even gone into the source code and found where the default locations are, but the problem is that you have to add the entry to both a table and an XML file, the table is easy, but trying to find where and what I need to add to the xml, so far has turned out to be impossible.
Can anyone help, or is the best solution going to be to use a third party installer.
Thanks,
Gavin,
View 2 Replies
View Related
Jan 10, 2007
the language cache for the package wizard is currently stored at "C:Documents and Settings<user>Application DataMicrosoftAccessADE11Cache1033".
this is, therefore, in my roaming profile, which is a very bad thing since it's 35MB.
is there any way to put it somewhere else?
many thanks,
e.
View 1 Replies
View Related
Feb 4, 2007
I have MS Access 2002 version, I create one mdb file and then put it on the sharing drive, I install Access RunTime on my client machines, they can run the mdb file on the sharing drive.
Another way,
I used Office XP Developer Edtion to create package and then install the package on my client machines, they can run the mdb file.
Here is a question,
Why do we need Office XP Developer Edition to create the package? Because we just install Access Runtime on the client machines, then they can run the mdb files.
What is advantage of creating the package?
View 3 Replies
View Related
Feb 4, 2007
I have MS Access 2002 version, I create one mdb file and then put it on the sharing drive, I install Access RunTime on my client machines, they can run the mdb file on the sharing drive.
Another way,
I used Office XP Developer Edtion to create package and then install the package on my client machines, they can run the mdb file.
Here is a question,
Why do we need Office XP Developer Edition to create the package? Because we just install Access Runtime on the client machines, then they can run the mdb files.
What is advantage of creating the package?
View 1 Replies
View Related
Mar 22, 2007
Hi, can someone please tell me how would it be possible to package my database!!!? I need to do it for my coursework. I thought may be the package and deployment wizard would be a good idea, but it isnt listed in my add-ins manager. Btw I am using VBA (Access and VB together).
Thanx in advance
View 3 Replies
View Related
Mar 25, 2006
I have developed access application (front/backend) for my client. As client wanted they would be running on 3 comps on LAN. 1 comp would have the DB and the other 2 the frontends. How will I create installation (CD/package) so that it can be distributed in the clients site. Any suggestion would be appreciated.
Thanks in advance.
View 1 Replies
View Related
Aug 13, 2007
Hi All,
I would like to make a setup package, which is setup.exe to install my MS Access and help file. However, I don't know how to create the setup.exe.
Anyone can kindly suggest or guide me?!!
Thanks a lots!!!
Victor
View 8 Replies
View Related
Jan 14, 2008
I have hyperlinks from within Access forms that link to Adobe PDF documents; these are the new PDF Package documents created with Acrobat 8 - and give the message "Multiple files are bound together in this PDF Package."
The problem I am having is that when ever I click on the hyperlink the computer hangs (from the task manager, I believe that it is Acrobat Reader that is hanging). This problem only occurs with multi-file PDF packages and does not occur with regular PDF's. It also only occur with MS Access, as linking to theses files from MS Word encounters no problems.
Is anyone aware of a fix for this?
View 6 Replies
View Related
Dec 28, 2007
All -
I have just about finished up a Split DB that I plan on deploying in a LAN environment. The goal of course is to turn what looks like an Access Application now into a non-access looking application where the Front End can be distributed and run on any computer within the LAN.
I have several questions that I may need some help on.
How does one go about hiding the Access Shell and/or Ribbon/Nav in 2007?
How would I add a form that allows for a user to navigate to and connect to the back-end without having them check all of the appropiate tables and then browse to the back-end file if they have a different drive letter mapped to the location of the back-end files for example?
Any tips on how to sign the DB so the pesky Trust Center question can be bypassed?
Any other tips on how to simply distribute this for a LAN environment and/or make it look NOT like an Access DB with access to view the Forms, Tables, Queries, etc. This is my first Access DB project, let alone a LAN distributable one.
Thanks!
View 7 Replies
View Related
Sep 6, 2013
I'm making an accounts package.
I've got a query that shows all individual invoices with their total amounts. This works.
But now I'm trying to make graphs so I want show just total amounts combined by customer, for each customer.
So for example if I had 8 customers and they each had 10 invoices each my current query would be returning 80 records.
What I want is 8 records, once for each customer with the summed total for each customer so that I can then graph this.
View 3 Replies
View Related
Jan 29, 2014
I have an accdb built using Access 2013 that will run with in 2010 Runtime. I am about ready to distribute the application, and am starting to do some research.
When I attempt to package and sign the db using the feature in Access 2013 it asks for me to "Confirm Certificate".
Before I go buy one I want to 1) try to create on myself and 2) learn about some good places to buy them.
1) I created a "Self-Signed" certificate using IIS, but the certificate doesn't show up on the list of certs when I attempt to package and sign the accdb. Is there a way to use a "Self-Signed" certificate to package my accdb?
2) If purchasing a SSL is the only option. Where is the best place to buy a SSL that I can use to package and sign accdbs from Access 2013?
View 3 Replies
View Related
Jul 19, 2013
I've created an accounts package for my business using access 2003 and I'm just thinking of some time saving features.
We need to email our invoices to our clients.
Normally we print out an invoice, scan it back into the computer, save as a PDF and attach to an email manually one by one.
My package can now print to PDF (saving one step), but what I would like is to be able to print to PDF and attach to a new email (with the email address coming from the customer table) and possibly attach more than one PDF to a single email.
I know you can use
Code:
DoCmd.SendObject acReport, stDocName
to send a report but I would like it as a PDF as my formatiing is lost using that code and we normally send PDFs to our clients.
View 14 Replies
View Related
Jun 21, 2013
I have a form for inserting invoices, and on the subform records I have a command button to print the labels, the label would contain the quantity of the product, so, if the quantity is ex. 11000 and package contains 2000 only.
so I have to print 5 labels with quantity 2000 and one label with 1000 qty
what I need to do, is when I click the label cmd button to insert the 6 records required to print the labels to temp table
View 8 Replies
View Related
Apr 25, 2005
I have one Project in Ms access 2000.
If I create Setup(Package) it's working fine in Access2000 but for Access 2003 I need to install Ms Access 2000 Runtime.
Kindly tell me how to install Access 2000 Package in Access 2003 without installing Access 2000 Runtime.
Can it support backword compatibility ?
Thanks
John
View 1 Replies
View Related
Dec 13, 2007
guys, can someone help, i copied this sql from the wizard window, i'm trying to put the sql in a vba code here is what i did, the select is not working it has syntax, can someone help?
Dim mySQL As String
Dim db As Database
Dim rs As Recordset
Dim x As Long
Set db = CurrentDb
mySQL = "SELECT change_order_tbl.serial_num, Max(change_order_requestor_tbl.change_order_effect ive_date) AS MaxOfchange_order_effective_date" _
FROM change_order_requestor_tbl INNER JOIN change_order_tbl ON change_order_requestor_tbl.change_order_id=change_ order_tbl.change_order_id
GROUP BY change_order_tbl.serial_num
HAVING (((change_order_tbl.serial_num)="abc"));"
Set rs = db.OpenRecordset(mySQL)
rs.MoveFirst
x = rs!countoffield
View 8 Replies
View Related
Mar 4, 2005
I have a table that shows all the company's PC's, and another table that shows all the software. I have a smart look up for a the PC's that when you click on it, it will show you all the software loaded to that machine. however, there is so much software loaded to these machines that when the look-up is clicked you can not read all of the software because it is listed horizontally. Is there any way that you can have the look-up view vertically. Any other ideas would be much appreciated.
View 3 Replies
View Related
Dec 20, 2005
I am running Access 2000. The control wizard is not available. It does not come up when I add a command button for example. How do I get it turned on?
View 6 Replies
View Related
Apr 11, 2007
HI, I am using Access 2003
I tried using the security wizard and I think I, I know I should have read up rather that trying to set it up. I printed the security report so I can get back in to the db but now all db's on this pc require me to log in now. How do I remove this security? Can I just delete the security db that was created by the wizard?
Thanks for your help.
View 3 Replies
View Related
Feb 21, 2005
Hi
I want to manipulate a few tables and make them into one table, but I don't want all of their fields. I heard that I could do it with "map table wizard" from the top of the menu. Where can I find it? Or, can anyone recommend me what I should do better?
I use Office 2002.
Thanx.
Gaufres
View 2 Replies
View Related
Mar 10, 2005
I have three fields that I would like to have access the same table using the Lookup Wizard. I am unable to get the query to work.
Example:
The Fruit table has 5 records, let's say: orange, apple, banana, kiwi, strawberry.
The first field -- Fruit1 -- would use the Data Type Lookup Wizard referencing the Fruit table.
The second field -- Fruit2 -- would also use the Data Type Lookup Wizard referencing the Fruit table.
The third field -- Fruit3 -- would also use the Data Type Lookup Wizard referencing the Fruit table.
The bottom line: a person will have a choice of 3 fruits.
Again, the problem is that I cannot get the query to work where I choose =banana for the criteria for all three fields. Banana might be person one's first choice, but it might be person two's second choice, etc. I'm looking for all the bananas no matter which choice it is.
Your assistance is appreciated.
View 1 Replies
View Related
Nov 4, 2005
Print Wizard Help (http://www.access-programmers.co.uk/forums/showthread.php?t=96689)
View 1 Replies
View Related
Nov 30, 2005
Hello,
I have just started on Access: creating 2 tables with primary keys and one-to-many relationships, and 2 simple queries. I want to create a form but can never complete the wizard or auto-form or else because it crashes with the pop-up message "object variable or with block variable not set" ? what does this mean?
thanks for your help.
View 1 Replies
View Related
Aug 25, 2006
I've been building a database with Access. When I added a combo box to a form, it used to pop up a wizard which would guide me through selecting the data the box displayed and what happened to the selection the user made.
It has now stopped displaying this wizard.
How can I turn it back on?
View 1 Replies
View Related
