Search results

Anyone know if I can share my media on my Win 7 PC to my Logitech Revue?

SQL server 2008, ODBC connection. Both DEV. and PROD same. DEV. can update a view via open it (forms based off the view) and update in form, etc. PROD, won't allow updates either in the form or opening the view directly. View permissions are the same on SQL both DEV and PROD. Delinked and...

2003 MDB working in 2007. So I removed the ODBC linked table from Access. I dropped the table on the SQL server. I use VBA code to refresh the links. I get an error that says the table does not exist (DAH). I'm using DAO and it errors on the RefreshLink command as it is doing a FOR EACH through...

Anyone know how to make s Access DB single use? i mean only allow a single users at a time, without changing each persons Access to Exclusive from Shared? So exclusive at the DB level?

Is there a way to dump all the objects (forms, queries, reports) that contain each table? I.E. MainTable is used in; Query1 Query2 Form1 Form2 Report1 Report2 Report3 ETC.

OK, So a Linked SQL table, has a varchar field that contains a URL. In my access app. I want them to select (via a description) the proper row, and when a button is clicked, run that URL (browser I guess). it is a SQL Report the URL is pointing to if that matters for any reason. So how does one...

Can I run a SQL Report from Access?

What would cause Linked Table manager to relink table fine (except read only for some reason) but if I check the always prompt for new location, then it gives me an "ODBC -- call failed" error. I wanted to specify a different DSN, but won't let me get that far. Access 2007 Sql Server 2008...

So using migration assistant, I migrated an (2002 format) data tables to SQL Server 2008. Had to relink the tables using the proper ID. When a macro opens an update query, I get an ODBC error. Yet i can run the query by itself with no problems. All table open just fine. Security on the SQL side...

Trying to create a dynamic passthrough query using ADO. So one of the parameters is the query name. cat is an ADOX catalog cmd is the ADO command cat.ActiveConnection = CurrentProject.Connection on error resume next cat.Views.Delete SPTQueryName on error goto errortrap...

I need a form with about 8 comboboxs of which 4 or 5 will be multiselection. I then need to base a main query off this form to return the selected data based on the selections. Not having had to deal with multi-selection and filters, what would be the best way to base a filter of a...

Having trouble finding a new seat for my 2001 Moto Guzzi Jackal (in the USA). Do you have any places that make replacement seats (poofier) seats for the Guzzi's over there? Can you give me a URL if you know of one?

man, I have been searching, and have tried different code snippets (you should see my registry and .INI files) here is what I need. VBA code for Access 2003 using Acrobat Standard version 7.x. I need to run a report, and have it create a specified PDF file name. Will be running in a VBA loop...

Had person in Aberdeen ask me how to do something, so I sent a screen shot back with a big arrow pointing to the link (this just happened to be a web page) on the web page. One of those should have seen it, but didn't look kind of things. They sent me back this response. nil points to me for...

In the event log on one server we are getting this: Now anything I can find on this says it has to do with MSDE. Yet it is Standard edition, SP4 running on WIN 2000 server. Any ideas any one?

The Democrats now promise "A New Direction for America" The stock market is at a new all-time high and America's 401K's are back. A new direction from there means, what? Unemployment is at 25 year lows. A new direction from there means, what? Oil prices are down sharply. A new...

OK, we have account were ages ago they were using one nameing convention, and changed to another. recently they brought the SamAccountName in line with the UPN (Active directory lingo here). BUT in Sql Server their old SamAccountName was used for access. So as an example: Domain\OldSamAccount is...

Way around this? DECLARE @sVar Char(500) SET @sVar space(500) SET @sVar = STUFF(@sVar,250,16,'ABCDEFGHIJKLMNOP') PRINT @sVar Shows a bunch a spaces with the ABC... in 250 through 266 INSERT INTO Table (My500Col) values(@sVar) The data in the My500Col is truncated at 255 (I.E. shows ABCDEF...

For a SQL 2000 DB: I would like a batch file I can schedule; To disconnect any connection/s (or put it in single user mode, or whatever). Dettached the DB copy the DB and LOG files to a new drive attached the DB from the new drive verify it is back up Anyone know how to do that? I'll manually...

OK, HIGH FRUCTOSE CORN SUGAR, bad for you, yet it is in many, many products. What if instead of this bad for you thing, these products were changed to use say a regular sugar, stuff like that which would make them not as bad for you? Then the current HIGH FRUCTOSE CORN SUGAR plants changed to...