LDB Files

Nov 29, 2007

I have a locking file that I can't seem to remove. No one is in the database that's associated with the file but it tells me there's been a sharing violation. Can anyone tell me how to remove those files?

View Replies


ADVERTISEMENT

Modules & VBA :: Loop Through Files And Then Compare With Files In Database Table

Nov 11, 2013

I have to write a code for my database,i have folder with files "pending Review" and a table with column "tblExcelLocation". when i run my database all the files from pending review folder goes to "tblExcelLocation" on a click of button.But,if the files already exists it should not insert those files and insert the rest.For this i tried to write a code but i think i m unable to do that .

Code:
Loop through files in folder
folderspec = "O:QA FilesQC ReportingPending Review"
Set fs = CreateObject("Scripting.FileSystemObject")
Set f = fs.GetFolder(folderspec)
Set fc = f.files

[code]...

View 7 Replies View Related

Using MDB Files Which Are Backed Up Hourly Into Zip Files

May 2, 2012

Every hour a zip file is created in an FTP folder. The zip file contains an .mdb access database file with any changes to the data since the last hours file.

What is the best method to get access to connect to the content of the zip files and pick up the changes to the data?

View 3 Replies View Related

MDE Files

Jun 20, 2005

Hi guys.

Just a quick one, I couldn`t find anything on this or in any books I have.

I`m assuming I need to create an MDE file befire I can distribute my database for other people to use ?

Anyway, that I have done, but the question is, I`ve done this and have a select number of ppl using my database, entering LIVE data etc.

Once This has been done can I open this back up in access and make changes to the database, eg forms, reports etc etc ?
If not, is there anyway, I can pull the data out of this and import it into my origanal file, which can then be remade into an MDE ?

I hope I have made myself clear.

Thanks in advance for any help!!

Max

View 9 Replies View Related

Mde And Mdb Files

Jun 21, 2005

Hello,
Once I split up database into mde and mdb files is there a way to put them back togethere ? How can I turned linked table into table?

I would greatly appreciate your reply.

Debbie

View 2 Replies View Related

Files Name

Oct 4, 2005

HI I hope that someone can help me, I know it's not that hard, but I have never done it. Actually, I have a folder that has like 340 excel files. Is there a way I can write a vba code in either excel or access to get the file names in like a table or so, it's gonna take for ever to type them in manually. I only need to get the file name and they are all excel files. Please Help If You Can. Thanks.

View 6 Replies View Related

ADP Files

Nov 2, 2005

i wanted to convert my MDB file to ADP.
the convertion went well except from on important issue, it didnt convert all mu queries to the new file, i tried another way but nothing.
please help.

all the forms and tables an d everythoing else are in the new file, although, the forms are based on all teh queries.

View 1 Replies View Related

Help Files

Oct 24, 2007

Is there any way to embed html type help file in an .mdb/.mde file? I have created an html type file, MS Word saves it as an .mht (Whayever that is?). Is my only option going to be to distribute this .mht with the .mde? How do you access the help file from with in Access?

What are some other relatively easy user help authoring options?

Thanks,
Ken

View 8 Replies View Related

MDE Files

Jul 8, 2006

I'm having trouble converting my DB to an MDE file.

I'm programming in access 2003 and saving as a 2000 file format.

I opened a new DB and imported all objects etc... the saved as a 2003 format. Still won't save an MDE file.

Any suggrestions are appreciated

Damon

View 4 Replies View Related

Log Files

May 22, 2007

I was wondering if access has a log system that can log when a user connects to the database and would give date, time and username? My database is setup for multiple users.

View 2 Replies View Related

Storing Files

May 8, 2005

I am doing my comptuer science coursework and one thing I need to include is "how does access stored files" and the basic description of file organisation. After some googlging around though I have found nothing, can anyone hlep me out on this?

Thanks
Chris

View 3 Replies View Related

Importing Csv Files

May 25, 2005

Hi

I am having much trouble importing csv file into access 2003

My freewebs site have a registration form
The forms are then downloaded into my pc as csv files

According to freewebs, the csv file is access friendly and can be imported into access

so I tried for about a million time and still no luck

where did i go wrong?

this is what i did

help !

regards
frontpageplanners

View 14 Replies View Related

Creating Help Files

Jul 15, 2005

I wondered if some can advise me as to how to make help files and linking them in to the dabase. i.e. if someone clicked on a certain section for help then it would go to the help for that section. Is there an easy program to help write the files??

View 3 Replies View Related

Working With Files

Oct 18, 2005

Dear friends,

I'm working on a dbase now that categories files used for sales. The dbase has 2 functions: searching the texts and saving/editing the texts. I'm not a (Hollywood) star in VBA and a need to build in the search function an option where the user can search in the found documents :( . In the save/edit option the user has to copy/paste the text in access and save the text with his attributes. The texts are saved outside the dbase in the same folder, but when the text is saved i'd like the filepath as an attribute-value. Pls help me!

View 1 Replies View Related

Audio Files Db

Apr 26, 2006

Apologies to all who have been trying to help me with this db design challenge. It appears my explanations of what it’s for and what it’s supposed to do is confusing.

I think I should explain again, simplifying as far as I can for clarity.

It’s as if I had a number - let’s say 10 - standard letters (that I’m henceforth referring to as ‘styles’) that I wanted to personalise and to be able to send to any name on a list except:

•It’s in audio format meaning I can not do a ‘mail-merge’ equivalent.
• Each name has to be recorded and manually ‘mixed’ into each style* so where my set’s complete for one name I have 10 different sound files with the same file name, each kept in a folder named according to style.
•The primary purpose of the database is to let me enter a name and a style and it will tell me if there’s a file ready with that combination.

There are some things that complicate this:
•There are many ways of spelling some names (e.g. abi, abby, abbey, abbie). Looked at another way, there are many names that when pronounced, sound the same as each other! Each of these needs to refer to the same filename (which could be available in any or all styles). This means I need to associate all the spellings of one name to the one file name.
•Also, there are some names that are spelled the same but pronounced differently (e.g. jean – which can be a male’s name which sounds very different from the female’s name with which English speakers are more familiar).

There will always be unusual names that come up which will need to be recorded and mixed for one particular style, used then disposed of. However, the aim is to have 1500 odd files with the most popular names pre-prepared for each (and yes, I am aware of the scale of the project and no, there isn’t another way!) so they can automatically be dispatched as required. I’m guessing linking different spellings will increase the number of names – available in every style – to around 4000.

I hope it’s appropriate that I’ve explained this in detail here. I think it’s required because this db design is such an unusual one that when I'm asking specific things regarding tables, queries etc. I can refer to this for the context.

I’m not asking anyone to do this for me. I want to have done it myself but I need to be borrowing your expertise.

Also, this posting is not a request for any specific help about the project though, of course, any comment is welcome.

The thread which is currently addressing the data structure and table relationship issue is:

http://www.access-programmers.co.uk/forums/showthread.php?t=106356

I will edit this to link to threads looking ad different aspects as I go along (providing this approach is acceptable with the forum community).


Cheers :)

*This is what’s taking most of my time at the moment (there's a good few thousand already recorded since the project was started).

View 1 Replies View Related

Access DLL Files

Jun 13, 2006

Does anyone know that path to the folder that the dll files are stored in that Access uses?

View 3 Replies View Related

Why Am I Getting Backup Files?

Nov 20, 2006

hi,

every time i look in or shared area i see a new backup file of one of my mde's...

junior school pastoral log_backup

it seems every time i delete one a new on is there next time...

what's causing this? is a user not logging out of the software properly or what?

cheers

greg

View 6 Replies View Related

Using Different DBs With Differnt MWD Files

Jan 31, 2007

Hi all:

Using Access 2000. I have about 5 databases but only one needs to be secured so I created a system.mdw for it. After doing that the secured db works but all other db's ask for authentication also but since there are no users or groups in the other db's, the authentication fails and I can't use the db's. If I put the original system.mdw back the other db's work but the one that needs to be secured it wide open.

Is there a way to do this??????

thanks :confused: :eek:

View 2 Replies View Related

MDE Files - Locked?

Mar 12, 2007

Are all mde files locked so that you cannot edit or see design view for forms etc?

Are there any tools out there that can unlock an mde database?

Thanks,

Dave

View 1 Replies View Related

Need To Delete Some Files

May 17, 2007

Before I spend a load of time on this, thought I'd check to see if it's even possible.

Thanks to some help from folks here, I have some code that allows me to output some reports to a folder and then email those reports as attachments, all from inside my db.

Now I'd also like to delete those files after the email is sent, before the module ends.

Anyone know if this is doable? If so, I'll get started working on the code.

Thanks
BeckieO

View 4 Replies View Related

New Files Being Created

Nov 27, 2007

I have created an Access 2007 database on a network drive. I notice that as the database is being used, other files are being created sequencially such as, "database1", "database2", "database3", etc. What are these files. They are quite large and I am wondering if they are necessary.
If anyone has any information, I would appreciate it.

thanks,

View 5 Replies View Related

Zero Size Mdb Files

Mar 11, 2008

Hi, I am new ( as of today) to this forum. I have been using Access for a few years following on from using Q&A. I manage a database for membership for a club and more recently designed my own database for another personal application. Last weekend I did a full backup on a new laptop I have that has both Access 2003 and 2007 on it ( I don't use the 2007 version at the moment) and following that most of the databases, including backups have gone to zero kb in file size. I tried a system restore to no avail. I can see the files but they are 0kb in size and won't open. Does anyone have any idea why this should happen and more importantly how (if) I can resolve it ?. The laptop has Vista as the O/S.

Kind Regards & greetings from a wet and windy Dublin,

Ian

View 4 Replies View Related

1 Table In 2 Files

Feb 25, 2005

Hi, [access 2000 or 2003]

Is there a way i can use one table shared & updated in 2 access files? if yes what are the conditions please

thank you

View 1 Replies View Related

Text Files

Sep 23, 2005

I have I table which is linked to a tex file. I created a code in which it will programatically refresh the linked, however, after the refreshed process is done, it always put the first record as a Field Header.

Can somebody help me what is needed inorder not to Access automatically use the first Record of the text file as a Field Header ?

Thanks :(

View 2 Replies View Related

Attaching Files

May 23, 2006

This might be impossible, but I was wondering if there was a way to attach files to records on a form. I work for a marketing company and I have built a contact management database and I need to attach files such as letters and emails to records on a form. I also would like a list of files attached to that record to display also. I don't know if this makes sense or if it is possible. Any help would be greatly appreciated.

Nick

View 2 Replies View Related

Files Not Found?

Sep 27, 2004

I have copied a copy of my system onto a user's computer to start using the system. However, when the user tries to open the system, all of my forms that use Date() come up with some error. Then it goes on to show me an error message saying "VeenLR3.hlp can't be found". That's actually a help file. I have copied all the files in this drive, "C:Program FilesCommon FilesMicrosoft SharedVBA" from my computer onto hers but the error still shows up.

Does anyone know what this error is all about?

View 2 Replies View Related







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