Search results

Thanks, yes, there are many places I use transactions. But unless I am truly losing my mind (which is certainly possible) action queries have always AUTOMATICALLY run as transactions in the past. I've been programming Access for 10+ years and this is the first I've EVER seen an action query run...

Hi, I have been using the following query, literally for years, without any changes. I run it from code using db.execute, and I do use the dbfailonerror option. One of the things it does is to add a '3' to the end of the [serial]. [serial] is the primary key in the TST3 table. You might think...

Yes. Access 2002, each user has their own copy of the FE, backend resides on server.

Hi, After years of things running OK, I am now having almost daily db corruption. I believe it's due to some sort of write-delay issues on our network, over which I have no control. For example,here's a code snippet that sometimes works and sometimes doesn't. The queries re-fill the tables...

Hi, WHen I used Windows task scheduler to start my application, and then close the application normally, the application closes but Access is left running, still visible in the task bar. The only way I can get it to close is by using task manager to kill it. I found an old KB article ( #...

Hi, I want to be able to search public modules in databases outside of the one that I'm in. For the current project, this works fine: But I want my application to be able to search in modules in other db's, too. I've tried setting references to the other db's. I can then manually open their...

I have been experiencing some very strange symptoms over the past week or so, and am looking for ideas. I have a number of different frontends that link to one or more shared backends. A week or so ago, all the frontends were reporting that one of the backends, PCAMaster_be, was corrupt (ie...

OK, now I'm trying to repair my mdw file.... but how? My mdw file is still in Access 97 format, and when I try to open it, it says I don't have permission to convert it. I don't really use the Access security in any meaningful way and have been meaning to un-secure my db's for a long time...

Hi, I have two possibly related things that have recently begun happening in nearly all of my databases. (Access 2002, Windows XP) 1. For years I have been using shortcut command lines like the following to open my databases: All of my databases use the same mdw file. Up until recently this...

Thanks, that works. And, now, suddenly, the beep function starts working too. It does use windows "default beep" setting. The only thing I can figure out is maybe I didn't click "apply" in "sounds and audio devices".

Yeah, I have that on my desktop PC. But not on my laptop.

I don't have any external speakers. If what you mean by external speakers is separate pieces of hardware that plug into my laptop. All I have is the laptop itself. And as I said, it is audible when i go to "sounds and audio devices". I can't find any such thing as "volume control" setting on...

Hi, When I use the Beep function in Access, I get no sound. Why? I can go to Control Panel "Sounds and Audio devices" and play sounds and hear them fine. So I assume that the particular sound that Access wants to use must be turned off?? I thought it would be "default beep" but that's turned...

I have loads of experience with Access but very little with SQL server, so please bear with me.... I am using SQL Server 2005 and Access 2002. Using mdb, NOT adp. I have created a paramaterized table-value function in SQL server, named fnTrainingSummary3 The function based on a View named...

Hi, I'm working on migrating Access 2002 db's to SQL Server 2005. I am using the "SQL Server Migration Assistant for Access" (SSMA), which seems like a good tool. In the help file for it there is a tantalizing paragraph: But, no information on how to actually DO this. When I do the migration...

Ok, I figured out the DSN stuff and how to link my tables. Also figured out, I think, that they didn't automatically link because I still had some Access security in place. When I got rid of that and re-ran the upsizing tool, they linked automatically. However, I am still confused about the...

Yes, the wizard is creating the db on the server, but I only know this because I can see the tables from a tool that the IT person has on her desktop, which I do NOT have. I have no way that I know of, currently, to see anything within SQL server, from my PC... so .... This "SQL Server...

Upsizing from Access 2002 to SQL 2005. I tried re-doing the upsize several times. No difference. I'm keeping the project as an mdb. Understand I have a lot of Access experience but NONE with SQL server. After literally YEARS of delays, I've finally gotten our IT department to give me a SQL...

Hi, i am trying to get started upsizing my db to SQL server. I run the upsizing wizard with choice "Link SQL Sever tables to existing application". It seems to run fine, and I get no errors. The tables are visible in SQL server. BUt I do NOT get any linked tables in my existing application. The...

Thanks, that helps!