Zip File In Access

Feb 1, 2007

I need to copy a bunch of images to a directory then zip up that directory.

I don't seem to be having much luck finding info on how to get this done.

Any help?

iz

View Replies


ADVERTISEMENT

General :: Mail Merge Word File (using Data From Access File)

Mar 11, 2014

I often create contract using mail merge. I have an access file that I want to use as data source for word file. But it does not automatically.

Please download the attached file !

If there are 1 customer and 1 property, I do not need to do anything. Conversely, if there are many customers and many properties, I take time to manipulate.

Firstly, I open the word file. I have to copy and paste paragraphs that I want. Highlight of the original paragraphs is blue.

Secondly, I click 'Insert Word Field' -> select 'Next Record'.

In short, I wish to use VBA in access file to automatically perform the steps that I have outlined.

View 3 Replies View Related

Backup Current Access File Using Vba While The File Is Open

Jul 11, 2007

I have a button in the form of the current access file. What I want to do is when the user click on the button,
triggered the vba to backup current access file. But since the file is currently open, is this possible? If yes, may I know how to do it with vba?

I have tried two methods but failed:
1) Use copytofile method, but I get permission denied due to file open;
2) Use dbengine.compactdatabase method, but it also has problem if the file is open.

View 3 Replies View Related

Does File Server Hosting Back-end Mdb File Need To Have Access

Nov 15, 2013

I'm experimenting with MS Access, and I've successfully split an MDB someone created into two files. I can access the database from 2 computers at once using the front end file connecting to a file server which hosts the _be.mdb file.

Could the _be.mdb file theoretically be on a NAS without any computer attached, or is there some runtime or full version of Access that needs to run on the machine with the back end file?

View 2 Replies View Related

How To Make Setup File From Access File

Dec 7, 2006

i have develop an application in Ms Access, now i want to have setup file for that, how a setup file can be created.

View 3 Replies View Related

How To Convert .MDE File In To .MDB File In Access 97

Jul 18, 2007

Hi,

I want to make some changes in .MDB file and i do not have it. I have only .MDE file.. Could you please let me know how i can convert .MDE file into >MDB file so can change tabelsa nad reports...

Many Thanks

Nitesha

View 1 Replies View Related

Can Put Flash File Or Swf File In The MS Access

Nov 27, 2005

Hi,

In the Forms of the MS Access,

Can we add the flash file, or swf, other animation file on the form?

Thanks.

View 1 Replies View Related

Convert Access File To Exe File?

Dec 30, 2011

i want to convert accdb file to an exe file that not display any design view in other words i want the user watch only the forms and handle with the application as a program.

View 2 Replies View Related

Converting Access 2003 File To Access 2002

Nov 19, 2006

Hello,
I have created several files in Access 2003, and sent them to a collegue, but he is using Access 2002 and cannot open my files.

What do I need to do so he can access my files? My experience with Access is very limited.
Thank you in advance for your help.
Phil

View 3 Replies View Related

Program Working In Access 2007 Not Working In Access 2010 Due To Missing OCX File

Dec 27, 2014

I have a program that runs under access 2007 that I use at my work. We will soon be updating to MS office 2010 and the program will not work now because a calender file .ocx was removed from access 2010. Is there a way to get the 2007 .ocx file to work in access 2010?The program I am using is a relatively simple stand-alone and unsupported app that we use to request patient arrival and departure from various radiology tests inside a hospital. No reports are made from the app other than the number of patient transports for the day.

The app is placed on a common drive accessed from any pc in the hospital. No special permissions are required. But our app does use the calendar, time and date functions in access 2007. When I tried the app on a pc with access 2010, it basically says it (access) cannot open the app because a .ocx file is not present.Is there a way to make the access 2010 calendar file work in access 2007?

View 1 Replies View Related

How Can I Open A .mdf File In Access

Jul 16, 2005

Hi,

We have an old SQL server here which has died a horrible death and I need to get the data it contains out!

I have the .MDF files etc but I cannot seem to open them or import them in microsoft access.

I dont need to do anything flashy with it, just look at the tables!

Can anyone help?

Thanks

:)

View 14 Replies View Related

Fixing Access File?

Aug 10, 2005

i've got a 200mb mdb file and i can't
open it with ms access.

any idea how to fix this file?

ThanX
Yigal

View 9 Replies View Related

Open Old Access File

Oct 6, 2005

I am not an experienced Access developer.

I have a .mdb file that was created with Access 2000. Before I upgraded to 2003, I opened the file source by holding down 'shift' and double clicking the file. Now when I do that, it runs the application. How can I open the source file again.

Thanks

Anthony

View 1 Replies View Related

Access File Shared

Nov 9, 2005

Can an Access being shared and by multiple users concurrently?

View 1 Replies View Related

Opening PDF File From Access Is This Possible

Nov 24, 2005

Hi All

I'm not sure if this is even possible but I have a table which has a list of Categories(text) and another field named filepath(also text) which contains a file path which points to specific pdfs. So my question is Can I create a report which then prints the categories with a button next to them which if clicked on opens the coresponding pdf ?

Any help will really be apreciated I am a database novice but am really good at following instructions and copying code :)

Thanks in advance
Mel

View 3 Replies View Related

Access 2003 File

Dec 27, 2005

I am wondering if someone could save the attached access 2003 file as an access 2000 file so I will be able to open it. Thank You

Jeffsal

View 2 Replies View Related

My Access File Just Became Huge

Mar 7, 2006

I just recently noticed that the database that I have been working on has changed from around 60 mb to 430 mb. I added a few queries and forms. But could that really add to the size that much?

View 9 Replies View Related

Compile Access File

Nov 28, 2006

hello to the experts
is there any way or method to compile an access .mdb file to .exe
and don't be the need to open it with the access programm?
(eg. to a computer wirh no access installed)

View 2 Replies View Related

Access File Problem... Help!!!

Nov 19, 2007

an access file shows that can't find (as it says) the object database!!!! & don't opens...
the file is 3.5 mb and was working till yesterday just fine
but today without no reason doesn't open...!!!

i'm using access 2002

any ideas???


Thanks in advance!!!

View 4 Replies View Related

Import A .sql File In Access

Dec 11, 2007

Hello All

Hopefully someone can help me here.

I have been given a .sql file which I want to upload into an access database.

When I open the file this is the heading in notepad (which I hope helps)

SQLyog Community Edition- MySQL GUI v6.05
Host - 5.0.37-community-nt : Database - sft_provisiontool
************************************************** *******************

I am not sure now though how to import this into access.

Can anyone help?

Thanks

Mav

View 1 Replies View Related

ACCESS File Is Overwriting While It Is In Use

Feb 12, 2008

I created one MS access database and I added some table in that and I have other access mdb file with same name so when I open the first one file and I copied the second one file in same location it asked me to overwrite but I have using that file my issue is that while using access file if I am overwriting it wont allow me to overwrite it has to stop doing. Is their any solution for this.

View 3 Replies View Related

Access File Cant Be Opened

Mar 9, 2008

I have Access 2000 at home, and 2003 at work.

I can still open my file at work, but the same file at home cant be opened. It keeps giving "microsoft access has encountered an error" etc.. send error report..

Any suggesstions?

Thanks!

View 7 Replies View Related

Reading A .txt File Using Access

Nov 16, 2004

Here's my situation. I have a .txt file that I need to bring into Access. This .txt file is set up with records that are separated by semicolons.

I need to pull this information into Access and separate the data by the semicolons. I can open the file in Excel and separate the information by using Data --> Text to Columns --> semicolon (as the separator).

Does anyone have an idea how I can do this into Access.

View 2 Replies View Related

Link To Pdf File Within Access

Jul 21, 2006

Hello..

Here is what I would like to do. I have a folder say with 100 pdf's. What I would like to do is from an access folder be able to point to the specific pdf and have it create a link within the access form to the pdf they point to... Does this make sense?

Is there a way from within an access form that you can have a button that lets the end user look in a folder and select the pdf... and then create and store the link in an access form???

Thanks
R~

View 10 Replies View Related

Multiple File Access

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

Help! Access DB File Locked!

Jul 26, 2005

Hi All

I am using OLEDB to connect to an Access DB and it does use the "admin" account as the default user to connect from within Access i.e. this is not a Windows account.

I have an ASP.NET web page that is trying to do a compact and repair using a jet/MDAC object called JRO (Jet Replication Object).

The problem is whenever I call the JRO object I get this error:

"You attempted to open a database that is already opened exclusively by user 'admin' on machine..."

If I try and delete the .ldb file it is ofcourse locked. I found that if I do a CTRL-ALT-DEL and end the aspnet_wp process I am then able to delete the .ldb file and then successfully execute the compact and repair from the ASP.NET web page.

The aspnet_wp process when ended simply restarts itself (a new instance no doubt) and in doing so cannot remember it had a lock on the access db.

My conclusion is that the aspnet_wp process locks the access db file for or on behalf of the "admin" user in the access db.

Even if all connections have been closed the aspnet_wp process has a lock on the database file!

I am still searching for a way to tell the aspnet_wp to let go of the access db file!

I did use getprocessbyname() from the ASP.NET page to try and kill the instance of aspnet_wp programmatically and try and force it to forget by starting a new instance of itself, but ofcourse IIS gets really upset and won't let me kill this process from an ASP.NET page because I figure that in this case its suicide and aspnet/IIS won't "kill" itself but would be happy to "kill" other processes.

Anyway, I would have been content with the "kill the aspnet_wp process instance" approach except it won't suicide.

Does anyone have any idea how I might tell the aspnet_wp process to let go of the acccess db file?

By the way, I found the only account you need in a dev environment is the ASPNET account with read/write access and also your own account if you want to browse the folder yourself. No other accounts needed.

Any ideas appreciated.

I think this one has me beaten

from howartthou
Windows XP Prof.
VS.NET 2003
IIS 5.1

View 5 Replies View Related







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