Search results

I have one Access 2000 database front-end that is used to automate many tasks. This database is supposed to stay running all the time, and only a single instance of it should ever be running at one time. It's been running, fairly successfully, for quite a few years. However, I have several...

Oh, never mind. I forgot that you have to include the application path in the shorcut in order for the /excl to take effect. In other words the path in the shortcut needs to be: "C:\Program Files\Microsoft Office\Office10\MSACCESS.EXE" c:\mydb.mdb /excl Not just c:\mydb.mdb /excl Thanks anyway.

Hi, I have a db front end in which I've set the (tools-options-advanced) default open mode to exclusive. This works fine on the PC on which I set this mode. If I try to open a 2nd copy on that PC, I don't get an error message or anything, it just takes me back to my original instance. Still, I...

On one of my PC's, every time I open a report which contains a graph, I get the "installing: microsoft graph" message and then have to wait while it goes through it's install thing. I have many different db's, they all do the same thing. Doesn't matter who's logged in, the same thing happens...

Hi, In MS Access I can use a calculated column name in a later calculation, as I am using "MyValue1" here: When I try to do this in SQL server the 2*[myvalue1] part fails because it does not recognized MyValue1 as a column name. Is there a way to make this work? Of course I know in this...

Hi, I've used the import wizard in SQL server to import a table, and I've saved the package to a file. Now, how do I get the package to run again????? My stuff is on a shared server, so IT department I guess has disabled the "jobs" stuff for me. At least I can't find anything like that when I...

Thanks. I tried this and got no zeroes. HOwever,I did figure out the source of the problem: I did find that I have a few numbers that exceed the integer data type I have set. (at least in Access, isnumeric will return true for any number, not just integer) When importing into a native Access...

How do I search for an exact phrase in this forum??? If I try to search for "property not found" (including the quote marks or not), it automatically gets changed to search for property, -found! Not what I want!!!! :mad:And I don't see any way to set the matching options even under "advanced...

This works fine, where rawDemandHistory is an Access table. (demandhistorydata is a variable containing the path to the text data being imported) I used SSMS to migrate rawDemandHistory to SQL server, renamed it RawDemandHistory1, and linked it to my Access front end Now, if I try to run I...

Hi, I'm very new to stored procedures so please excuse my ignorance. I would like to create a stored procedure to duplicate the action performed by this MS Access code snippet, which just creates a backup copy of the DemandHistory table before I am about to refresh it. But I can't figure out...

I know this is old, but I am having a very similar problem, but it seems to be intermittent. (see my post "change to dsn-less tables"). So... did you ever get an answer to this?

HI, I have a function (included below) whose purpose is to change all of the odbc-linked tables in a database to "dsn-less" links, as is explained in MS KB article 892490: http://support.microsoft.com/kb/892490 The idea here is to code the SQL Server user name and password into each table's...

My IT department is refusing to give me the permissions I need to view Activity Monitor on our "production server". Their reasoning is that there are other production db's running on it besides just mine. They say that they can only give me those permissions on our "test server". THis sounds to...

I don't seem to have permission to view the Activity Monitor (SQLServer 2005). I've now asked IT to give me permissionl We'll see. MEanwhile, I've not had a recurrence of this problem, so who knows??? Today I've implemented the SQL Server world for all my users, so if it's going to be a problem...

Any answers to this question? I am having the same problem. My DSN file contains the SQL Server user ID and password, but users are still getting asked for this when they login into the Access frontend. HOw to I make this stop? ONe thing I noticed, although the uid and pwd show up in the DSN...

Roughly 700 rows. If I can increase the timeout, I don't know how. Can you clue me in? Yes, all of my tables have primary keys. And...sometimes they timeout, sometimes they don't.

HI, I am just starting to transfer stuff from Access 2002 to SQL server 2005. Initially I am just changing my backend (tables) to SQL server and leaving everything else in an Access .mdb frontend. The following query simply uses two tables that now reside in SQL server. When I run the query...

ByteMizer, you may be right. Maybe we're both right, as it looks as if MS has changed the behaviour somewhere along the way. I started in Access 2.0 and this code has been around for about that long. The other wrinkle is that I did not realize the behaviour is different depending on whether you...

ByteMizer, You may be right. But maybe we're both right, as it looks like MS did change the behavior at some point. I started in Access 2.0 and this code has been around for about that long. Another thing I didn't realize is that this stuff is handled differently if you actually create and store

OK, I've solved the problem. The problem has nothing to do with the [serial] & '3' thing or dates. That works fine. [serial] is a text field. The problem is that when the query tries to change the value 1 to value 13, it fails becuase value 13 is already there in a later record. Even though by...