General :: Distributing MS Access Database File With Creating Application Shortcut

Nov 4, 2014

I read in the book (Access 2013 inside out), one of the way to distributing access database is creating an application shortcut.

Now i have an Access 2013 file on my computer (with office 2013 and windows 7) other users have office 2007 and windows (XP) on their computers. now i want to give a copy of this file to other users without save as that to 2007.

I would like to know how i can do that with creating an application shortcut , if it is possible because in the book I could not find the way if there is?

View Replies


ADVERTISEMENT

General :: Access Database To Application (EXE File) To CD?

Nov 24, 2012

Okay so I created a database inventory. I know I can turn it into a "application" making it a EXE file. I was wondering after that being done could I burn that into a CD? So it would boot from the CD. Pretty make it work like a program application as in word, excel, etc..

View 1 Replies View Related

Distributing An Access Application On CD

Feb 24, 2006

Hi

I have created a website that includes an Access database providing a directory of manufacturers and suppliers to complement a magazine version.

The requirement now is to distribute the catalog on CD as well and the challenge is how to supply a query function?

I created a cd version of the website and it works fine - except if the user does not have Access installed the queries dont work.

I know the MS Developer Edition is the preferred route but it is very expensive for a simple application like this - does anyone know of an alternative approach?

Regards

Tony Randell

View 1 Replies View Related

Distributing My Application

Dec 2, 2007

Hello everyone,

I just developed an application and now I want to distibute it.
I want to work with licenties and I also want to make shure the software can only be installed according to the number of licences.

How do I solve this problem?

View 4 Replies View Related

General :: Convert Web Access File To A Desktop Application?

Oct 21, 2013

How can I convert a web Access file to desktop aplication? I've created it from a model from Office.com, but I need create code in vba and it don't permit.

The use of file is only in desktop.

View 3 Replies View Related

General :: Create A Front End Application For Access Database

Apr 10, 2013

I was looking to see if there was an easy way to create a user front end desktop application for a small access database.I have three users on different computers i would like them to input or amend data within one table of the access database.

View 2 Replies View Related

Error Using Shortcut To Open A Database - Can't Find File

Nov 5, 2013

We have a new user who is unable to get into a database. Another user in the same office had no problems.

The other user is using:

"C:Program Files (x86)Microsoft OfficeOffice14MSACCESS.EXE" /wrkgrp"ServerNameShareNameSFTPSFTPWorkgroup.mdw" "C:SFTP Database V2.1 FESFTP Database V2.1 FE.mdb

The new user was not able to access the share at all using ServerNameShareNameSFTP until he changed the path to:

"C:Program Files (x86)Microsoft OfficeOffice14MSACCESS.EXE" /wrkgrp"ServerName.ACCT05.us.companyabbreviation.comSha reNameSFTPSFTPWorkgroup.mdw" "C:SFTP Database V2.1 FESFTP Database V2.1 FE.mdb"

Now he can get into the SFTP folder, but when he uses the shortcut, he gets an error stating Microsoft Access couldn't find the file ServerName.ACCT05.us.companyabbreviation.comSha reNameSFTPSFTPWorkgroup.mdw 1" "C:SFTP Database V2.1 FESFTP Database V2.1 FE.mdb" (Note the space and 1)

I created a new shortcut, and I was able to open the db using his target line, even though I can use the shorter one. For the new user, this still generates an error.

View 4 Replies View Related

Rates For Creating An Application In Access

Feb 22, 2005

Hello all

I got a chance to make some extra money outside of my usual job.

I am creating a billing system for a plumbing business. It's pretty easy and shouldn't take me long to do. The only thing is I'm not sure what to charge.

Anybody have any idea?

Thanks in advance

View 3 Replies View Related

General :: Access (2010) - Database Creating Backup By Itself

Jun 13, 2013

Why Access (2010) database is creating backup copy by itself?

View 2 Replies View Related

General :: Lock Down Application By Saving As ACCDE File

Sep 29, 2012

Trying to lock down an application by saving as ACCDE file. Saves OK but when you load application none of the controls work. I.e. button clicks do not launch "Open Form" or " Print Report" commands.But in ACCDB format application works flawlessly.

When I tried on a different machine I get an error message that says too many Table IDs. Odd since I only have 3 forms, 3 tables and 3 reports. Lots of DoCmd's and switching between the 3 forms but not sure why this would create "too many Table IDs"?

View 2 Replies View Related

General :: Program That Can Be Used To Create EXE Type File For Application?

Dec 12, 2012

I have been reading a lot about Access Runtime and the problems that occur when a runtime application is installed on a machine that already has a full version of Access. Any program that can be used to create an .EXE type file for an access application that will eliminate all of these problems? The cost of the compiler program is not a major concern if it works!!!

View 12 Replies View Related

Adding A Help (.chm) File To Access Application

Sep 6, 2005

Please I have designed an access application and also created a compiled file. But I cannot attach it within code to work from my application.

I need urgent help to achieve that.

Thanks

Peter Chogudo

View 14 Replies View Related

Run The Mde File Without Installing MS Access Application

Dec 22, 2006

Hi,

I have a question.

I want to know that how to run mde file without installing MS Access.

Can anybody suggest which application can run the mde file?

Thanks.l

View 3 Replies View Related

General :: Opening Access Database From Batch File Or VBS

Dec 20, 2012

Is there a way to open an Access Database from a batch file or VBS file wait for 20 seconds and then close the Access file. Preferably I would like the Access file to run in either invisible or minimized mode. I would like the Access Database to close again after the 20 seconds has elapsed.

(The reason for this is so that the Database can refresh itself from Sharepoint on another users machine so that the excel reports on his machine are up to date).

View 3 Replies View Related

General :: Importing TXT File Into Database - Access 2010

Apr 3, 2014

I am having difficulty importing a large txt file into my database, due to the first column containing a * prefix. normally i would just go through the document and delete it, but this file is quite large at over 100k records.

Is there anyway of importing this file in access 2010 and telling access to ignore the first column?

View 3 Replies View Related

General :: Increasing File Sizes In Access Database?

May 1, 2013

I have an Access Database of around 8MB. However, after a day's use, this file size increases to around 110MB. If I run a Compact and Repair, the file returns to it's usual size. The first time I noticed this, the file had reached a size of 2GB which is a bit alarming. The file does get used but only appending around 50 records a day and making some amendments. What could be causing this increase?

View 3 Replies View Related

Distributing A Database

Mar 16, 2006

So I have nearly finished my database and I want to give it to people so they can start entering data into it via the form.

Is there a way to make it so when someone double clicks on the file in Win Explorer it only opens the form for data entry - no access to the tables etc.

Can this be done ussing Access 2000?

Thanks.

View 2 Replies View Related

General :: Import Or Link Excel File On Access Database

Sep 17, 2013

I'd like to import an excel file but the data begin from cell "A10", above there is a "privacy text".Is it possibile import or link the excel data in an access table directly from the cell A10?

View 1 Replies View Related

Create A Shortcut To Open An Access Database Object For 2007

Dec 17, 2007

Running 2007. In 2003, to make a shortcut for an object, all I had to do is right click and place the short cut where i wanted.

I can't seem to find anyway to do it in 2007

Anybody have any clues?

View 3 Replies View Related

Distributing A Database Across A Network

Aug 2, 2005

I have a database built in Office 2000.

The client wants it across a network but insists they do not want it split! They want it in a shared drive which everyone has access to via a shortcut.

The database is secured so I presume the Workgroup file will have to be on each PC and a shortcut to the one database on the server which is in a shared mode. Would the security I have implemented still work or would I have to de-secure so everyone has the same level of access.

They do not have Access on all PC's. IFor this to work I presume Access is needed both on the server and PC's

I understand if I purchase Microsoft Access Developers 2000 it has a feature where I can distribute a database to users without Access? However, am I right in assuming this needs the database to be split.

In the UK are there any suggestions on where I can buy Microsoft Access Developers 2000 ?

Many thanks.

View 4 Replies View Related

General :: How To Edit Access 2010 Default Shortcut Menu

Dec 10, 2014

I am building a db and i want to disable the Shortcut Menu (pull down menu at form's title bar) to prevent the users from closing the main form.

There is a Disable Shortcut menu setting in the File/Options menu but the whole db gets the setting.

I simply want to deny the users from accessing the Shortcut Menu when on the Main Menu (or a particular form) but allow it on other forms where Printing is required via the Shortcut Menu.

Im looking at 2 options; edit the shortcut menu or force a form to disable that w/o affecting other forms.

View 3 Replies View Related

General :: Network Based Access 2000 DB Won't Open Via Shortcut

May 20, 2013

We have an old Access 2000 db that is used by most of the company. I also have users who use it via a windows 2003 terminal server. I just created a new win 2008 remote desktop server and installed Access 2000 (What a pain that was).

Now from access, if I go to fileopen, navigate to the DB server and open the DB, it works fine. If I create a shortcut to the database on the desktop of the remote server, nothing happens. No error, no warning, no nothing. It's weird.

If I place a copy of the db locally, it opens just fine.I also tried mapping a drive to the db server and then made another shortcut and still nothing. I also created a shortcut and entered the path like this:

"C:Program Files (x86)Microsoft OfficeOfficeMSACCESS.EXE" J:QS XYZ.mdb

But that throws an error that it can't see the database.

View 1 Replies View Related

General :: Microsoft Access Database Engine Cannot Open Or Write To The File

Jul 2, 2013

I am currently using Access 2010, and have successfully split a database, using the Access wizard.However, whenever a second or third user opens the database - with their front-end database file - they encounter the following message;The Microsoft Access Database engine cannot open or write to the file ". It is already opened exclusively by another user, or you need permission to view and write its data.

I have researched the internet and see that it has something to do with network permissions. I have worked with my IT department and this appears to be resolved!

Is there a setting I need to check in the front-end and/or back-end copies of the databases?Why is there no file name in the error message?

View 6 Replies View Related

General :: Create Database In Access That Links To Contacts In Outlook Pst File

Nov 21, 2013

I have limited programming skills but a basic understanding of databases.I want to create a database in Access that links to contacts in an Outlook pst file, and in the Access database I want to create a series of date dependant tasks or processes that I can apply to the relevant contact.The object being to to save that collection of tasks to apply to different contacts within Access.

View 2 Replies View Related

General :: Automatic Backup Of Access Database With Date Added To End Of File Path

Jul 28, 2014

Just wanted to confirm which is the best way to create an automatic back up of a access DB. (Split DB, backing up the BE - Access2010)

Firstly I was thinking of just creating a batch file to copy the file to a new source directly with a task scheduler set up.

Ideally I'd like it to run daily and have the date of the back up added to the end of the filepath.

View 5 Replies View Related

General :: Programmatically Importing Flat File Comma Delimited To Access Database

Feb 4, 2013

I have one Access Database and i want to import the flat file coming from Cisco Phone Logs, its a comma delimited that contains the column names in the first row, and in the second row, its the data type, then the succeeding rows contains the data of the logs which are in Comma separated values, I want to put it to my created table programmatically,I used Docmd.TransferText but this will not let me define the row which i wanted to start at row 3.

DoCmd.TransferText acImportDelim, , "tblImportTextFiles", Me.txt_SelectedDirectory & "/" & Me.lst_FilesInDirectory, -1

Attached is the text file i received from Cisco Call Log Applications.

View 3 Replies View Related







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