Access 2007 Package And Distribute Suggestions
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 Replies
ADVERTISEMENT
Sep 6, 2007
Hi,
I want to distribute an Access database to users, some of whom may not have Access installed on their computers.
The database has been developed using Access 2003 and I was wondering how I can distribute the database as a runtime version to my users.
Any help will be much appreciated.
Thanks,
Harmonic
View 9 Replies
View Related
Jan 12, 2008
Hi
Does anyone have a good easy sugestion on how to distribute a db with access runtime in a package to users without access 2003?
I have tried setup2go and it makes a fine .exe file.
But I can't make the package with access runtime.
Thanks
Mikael
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
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
Mar 21, 2008
On trying to import an Excel 2007 file into Access 2007 I get the following:
1) Choose "External Data," Import, Exce
2) Select small file in MS Excel 2007 format.
3) Click on Import the source data into a new table ...
4) Choose OK
Immediately get "Microsoft Office Access has stopped working. Windows is checking for a solution to the problem..." This message never resolves, so I have to click 'Cancel'.
Then I get "Microsoft Office Access is trying to recover your information..." I have to click "Cancel" here as well and then kill MS Access in Task Manager.
Event Viewer gives following message, which is of no help:
"ID: 2, Application Name: Microsoft Office Access, Application Version: 12.0.6211.1000, Microsoft Office Version: 12.0.6215.1000. This session lasted 710 seconds with 120 seconds of active time. This session ended with a crash."
Trying to import a small Excel 2003 file leads the same result. The same happens with a CSV file.
I have uninstalled and reinstalled Office 2007 as well. I am using Vista Ultimate.
I have turned off DEP.
How can I get MS Access 2007 to import Excel?
Thanks
Ken
View 6 Replies
View Related
Nov 26, 2007
I installed Office Enterprise 2007. Then I installed DEveloper Exrtensions, then Access Runtime 2007. All appear to have installed OK - they appear in Program and Features.
Instructions on runtime packaging tell me that a Developer option should appear in the resulting drop-down when I click the Office button (top-left round thing) when I have a d/b open in Access. It's not there! I have un-installed and re-installed the extensions and the runtime - still nothing!
Help!
I do have Runtime 2002 (XP) on the same PC, is that relevant?
View 10 Replies
View Related
Jul 7, 2005
I have developed a db (A2K) which will be distibuted through our companies franchising system to various licensees. These licensees generally operate in a single PC environment but occasionally they will be based on a server network. The single user is fine but I am stumped by the server situation as it impacts on the various links I have set up within the database to files etc that are part of the program but are external such as Excel, Word files. The current links are all set up as C:MainFolderNameFilename. Of course these all stop working when I place it on a server and link the users up via shortcuts. On our own installation I changed the links to the \MyServerMainFolderNameFilename format and everythings fine but due to the number of links this is a fairly lengthy process and I wouldn't want to have to repeat it at every clients installation.
Can any one please advise me if there is a way to set it up so that I could say enter the clients server name in a field. Then insert that field's contents into the pathway details for the links so that they all update automatically.
Your assistance would be greatly appreciated.
View 4 Replies
View Related
Jan 3, 2006
Hi, I have a large database containing information that people all over the country want to access. I've designed a main form that contains 3 subforms that queries information from raw data. Now that the database is complete, i'm looking for the best way to distribute it. I've tried to put it on the network drive, but it has been rediculoursly slow. Could somebody tell me what would be the best way to do this? Thanks!
View 1 Replies
View Related
May 26, 2006
I created the database on my computer. I added security and split the database to put the tables on the the server. Everything works just fine on my computer. However, when I try to copy the 3 files for the front end of the database to other computers on the network, it won't work.
Perhaps I'm confused as to what files need to be migrated to each additional computer or I don't have the security setup properly.
Right now, I move 3 files. The main database file with the front end. The shortcut file that is created when you add security and the security file that is created when you add security to the database.
I'm stumped.
View 4 Replies
View Related
Jun 18, 2012
I have a Query with many part numbers in column A and their inventory location(s) listed in column B. However, some part numbers are listed 2 or 3 times because the item is located in multiple inventory locations. How can I take these items and put list their inventory locations in multiple columns across one row?
What I have:
ITEM# Quantity INVENTORYLOCATION
A1 5 Warehouse 1
A2 3 Warehouse 1
A2 6 Warehouse 2
A3 2 Warehouse 1
What I want:
ITEM# INVENTORYLOCATION Quantity 1 INVENTORYLOCATION 2 Quantity 2
A1 Warehouse 1 5
A2 Warehouse 1 3 Warehouse 2 6
A3 Warehouse 1 2
View 3 Replies
View Related
May 20, 2005
I wonder if someone can give a suggestion on how to start this database. I am doing a material list database, but i've come across a situation where certain materials require a lot of text entry as opposed to some of the others where you simple enter data such as " density, grade, strength, etc" values. Because the layout/fields would be so different for the different materials (eg. plastics, metals, elastomer, etc.) it possibly might be a good idea to just separate them into different table groupings altogether? what do you think? Originally they were entered in Word and i was thinking of putting in access to standardize it. But what I'm trying to get at is the format in word was much like a one page report with headings and short paragraphs for this section of materials. Is it worth it and how should I go about having large text and heading entry, form use, report layout?
Thanks!
View 3 Replies
View Related
Jun 2, 2006
I am starting a new database today at work. I need some suggestions.
First of all, we will be having people enter data into many sections of the database at the same time...should I create seperate databases for these sections and link them together somehow so that it doesnt freak out with multiple users or being saved while open in different computer on the server?
Will it freak out anyways? What happens exactly if you open same database on two different computers.
Next, I would like to know if anyone has any further ideas about creating this database the right way in a server setting with multiple users!
Thanks.
View 5 Replies
View Related
Nov 8, 2004
Ok a bit of back ground. I'm building a access front end to a sql database. The end user will access the information in the database via asp pages on the Internet. They will only be viewing and not changing this information.
Now from the asp will be links to other pages within the same site. So they only have to be relative links eg .../folder/page.htm. But I want the person who inputs the information in the access front end to be able to test that the link works before saving the record.
I would prefer them to be able to press a button, then have access grab the link from the text box, add the relevant other bits eg http:// and load the page.
Any suggestions how I should go about it?
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
Jul 27, 2007
Hello,
I have finally completed my database project. It is a split database. Back End on a network server.
I want to distribute the front end to all users however I want to limit to the best I can what they can do to it. Can someone please advise me on the best way to wrap up and send out my front ends?
All security has been established. I am talking about the availability to see the tables, macros, control bars etc..
Any suggestions would be greatly appreciated.
Fen How
View 1 Replies
View Related
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
Jun 21, 2006
Hey all, I am currently looking to make a great database system for use within my community. What I currently have is a mdb with just 3 tbls but will be building from there. I have the normalization down thus far, but wanted to put things out there for any suggestions or ideas to make this a useful system. This is not a profit situation, and will generally be used only by myself or possibly one or two others.
What I have is a database that tracks the homeowners within our community (subdivision) and their properties. So far I have 3 tbls
tblOwners
- OPkey (autonumber)
- OFname
- OLName
- OStAddress
- OCity
- OState
- OZip
tblUnits
- UnitPKey
- StNum
- Street
- PIN
- Check2005
tblJct
- UnitPKey
- OPKey
Structurally this works great so far. I can easily relate properties to their owners and link multiple properties to those who own more than 1 (landlords). I structured it this way since the two tbls had many to many relationships, so the junction tbl made the most sense.
Now I am looking to add information from a tract search (mortgage holder information) which technically relates to both of these tbls (Unit & Owner) as well. I already know that most of the owners with multiple properties will most likely have the same mortgage holder, but that is not definitive. Since the same mortgage holder could easily be associated to multiple properties within the community, I know I have to have an independent tbl for that information as well.
What I would like to head for is something that will allow me to send notifications, letters, flyers and the likes to either the owners, residents, mortgage holders, or any combination of the three. I have attempted to create a few thus far but have issues with getting all of the required data output to Word, so I am thinking I may need to design these items in a Form instead.
Any thoughts or comments would be appreciated. I know I am heading in the right direction, but just putting it out here for the Access community to put in their 2 cents.
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
Jan 4, 2007
Hi, I'm afraid I am unable to be overly technical with my question as i've only really had a 2 day access course, sorry in advance!!!
Problem
I am trying to create a skills Matrix, it will need to include approximately 400 different skills which a staff member my or may not be trained on. I started by trying to do the lot on one table and an one input form but hit the 255 field limit. So now i'm messing around splitting it down into approx 7 sections. So, now i have 7 tables of skills and 7 input forms for the user to fill the table with, each table with a duplicated list of ID numbers for the staff. This seems really inefficient to me and i'm basically wondering if someone might give me a couple of tips structure wise. Also, could i just have one table for the staff ID's seperately? I tried to do this but cannot find a way of relating the skills input on the form to the specific ID if they are not on the same table. I know this is all probably really basic (and probably poorly explained and confusing too) but i've scoured the net as per usual and came up with nothing (i got some lovely code online which disabled the scroll button from moving records yey! :p ), so ive taken the brave step of joining a forum.
Thankyou for your time everyone.
View 9 Replies
View Related
Mar 10, 2008
I have a databse that i want to perform some analysis on to identify some trends. The database consists of album sales of a year. I have availble all details of orders, customers and albums. All tbales are joined with one to many relationships. Can anyone suggest some queries that i could do to perform some meaniful analysis to identify some trends in the data. :confused:
View 10 Replies
View Related
Mar 12, 2008
I am developing an app for a small medical office that requires a way of tracking periodic health testing for their patients. They are ultimately requesting a report that informs them of upcoming required tests for their patients.
Most periodic tests for a given patient will be manually assigned by the user in the frmPatient form via a combo box that lists available tests (for example, Mr. Smith is assigned a prostate exam with a frequency of every X months). However some tests need to be automatically assigned depending on the age of the patient (for example, when a male patient turns 50 years of age he needs to have a prostate exam every 12 months).
My Question:
What is the best approach to the automatic requirement of adding/flagging/indicating in a report that there are tests that are needed for patients that is determined solely by their age, eventhough this test has not been previously assigned manually?
View 3 Replies
View Related
Mar 2, 2005
Can anyone suggest a good form layout for my database below?
I have also included the database in access 2002 version!
tblEvent
EventID (int autonumber not null primary key)
RaceID (int foreign key to tblRace.RaceID)
EventName
EventTrack
EventDate
tblCar
CarID (int autonumber not null primary key)
CarName
tblCarSetup
CarSetupID (int autonumber not null primary key)
CarID (int foreign key to tblCars.CarID)
TyreType
TyreSize
GearBox
DiffRatio
tblDriver
DriverID (int autonumber not null primary key)
FirstName
LastName
tblEngine
EngineID (int autonumber not null primary key)
EngineMake
EngineModel
tblEngineSetup
EngineSetupID (int autonumber not null primary key)
EngineID (int foreign key to tblEngine.EngineID)
EngineCompression
Carburetor
FrontJets
RearJets
FuelPressure
BaseTiming
TotalAdvance
tblRaceVariables
RaceMasterID (int foreign key to tblRaceMaster.RaceMasterID)
RaceTime
TrackTemperature
RelativeAltitude
Milibars
Humidity
AirTemperature
TyrePressureHot
TyrePressureCold
StageRPM
ShiftRPM
Reaction
60ftTime
330ftTime
660ftTime
660ftMPH
1000ftTime
ElapsedTime
ElapsedMPH
Coments
tblRaceMaster
RaceMasterID (int autonumber not null primary key)
EventID (int foreign key to tblEvent.EventID)
CarID (int foreign key to tblCar.CarID)
EngineID (int foreign key to tblEngine.EngineID)
DriverID (int foreign key to tblDriver.DriverID)
All relationships will be RI Link with delete cascade.
Thanks,
Dean
View 2 Replies
View Related
Jan 29, 2007
Hello,
I have installed Microsoft Access 2003 and Microsoft Access 2003 Developer Extensions. I can create Access application by using the Package Wizard.
But after I upgrade from Microsoft Access 2003 to Microsoft Access 2007.
I can't use the Package Wizard.
How can I do to solve this?
Thanks.
View 1 Replies
View Related
