My current work suffered some kind of internal error and two imported objects, a form file and a module, became logical orphans. No code is visible, and I get a message whenever transiting to VBA: "Error accessing file. Network connection may have been lost." Needless to say (but I will anyway) I am not on a network.
I was able to purge the objects from the 'database' dialog but NOT from the project explorer in Basic. Will anything short of dynamite do the trick?
Alexander
Access 2000
This works: open a blank database then get external data from the broken .MDB. The orphans get left behind. There's got to be a better way?!
We have split a database and have about 6 users connected to a gigabit switch. There is a noticeable delay of about 5 to 15 seconds when we search by an account name. We are working with a split form, where it has the database records listed at the bottom half of the screen.
Is there a way to improve the performance? I tried a persistent connection, but it didn't seem to work and would occasionally get an error message.
There are hyperlinks throughout the database as well as a few lines of code that reference network locations that could change 1-2 years down the line. What I need to do is build a "housekeeping" form that is password protected where users can edit those hyperlinks via text-boxes. My problem is I'm not sure where to store the the data from the text-boxes to make it persistent. Making a table for the hyperlinks seems to be the wrong approach but I could be wrong.
I read a lot about Access database bloat when using temporary tables that reside in the front end, which was where I created and used temporary tables before reading about bloat.I therefore wrote a routine on startup that creates a temporary database and then copies the structure of the temporary tables into that temporary database using the DoCmd.TransferDatabase command. It kills the DB on exiting the application.I also read about keeping a persistent connection (handle) open to a linked DB as long as the main application is active, and this for efficiency reasons. I got this to work as well.
Being a self-taught Access programmer I have two questions:
1.Is the use of docmd.Transferdatabase a good way to work and does it reduce bloat by transferring the structure of the temp files to the temporary database? 2.If I want to work with the tables in my temporary database I use the following code for example: Dim dbTemp As Database temporary database Set dbTemp = DBEngine.Workspaces(0).OpenDatabase(strDBTemp) Set rstRpt = dbTemp.OpenRecordset("tblRptPU001", dbOpenDynaset) .. My question is this: if, at the end of the procedure, I write dbTemp.close set dbTemp = Nothing
does this leave the persistent connection open? The reason for the question is that I intend to split the database and soon go multi user, which is when efficiency is even more important than when working on a temporary database.
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
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?
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 ?
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.
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.
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?
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?
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.
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?
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??
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!
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:
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.
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.
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.
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,
