Viewing 12 posts - 1 through 12 (of 12 total)
anything in your error logs similar to?
2008-10-10 08:49:14.66 Server * BEGIN STACK DUMP:
2008-10-10 08:49:14.66 Server * 10/10/08 08:49:14...
January 27, 2010 at 1:05 pm
Sounds like you may have some runaway tasks. Check sys.dm_os_schedulers for cpu_id 7 and the current_tasks_count and sys.dm_os_tasks for task_state, sys.dm_os_waiting_tasks for blocking_session_id etc
January 27, 2010 at 10:25 am
try this, substituting where specific
CREATE TABLE PDFImageTest (account_num integer,image_data VARBINARY(MAX));
DECLARE @AccountNum integer
SET @AccountNum = 2456789
INSERT INTO PDFImageTest (account_num,image_data)
SELECT @accountNum,image_data
FROM OPENROWSET(BULK N'C:\Backup\Disk Usage by Top Tables - 6262008 441...
October 31, 2008 at 1:03 pm
However, you could create an empty database on the 2000 box, script all your objects in the 2005 database and apply against the 2000 database, then copy the data using...
October 17, 2008 at 8:41 am
Your form can have a recordsource which could be anything from a table, view or a procedure. On this form you may have multiple subforms, combo boxes, list boxes etc....
September 12, 2008 at 2:07 pm
You can use ADO in much the same way you would coding a VB front end. A good reference is http://msdn.microsoft.com/en-us/library/ms675104(VS.85).aspx and also
http://msdn.microsoft.com/en-us/library/aa189885(office.10).aspx although it is...
September 12, 2008 at 1:17 pm
I would suggest the fastest and most useful way to learn how to use an adp project would be to create a project from scratch, connect it to an existing...
September 12, 2008 at 12:26 pm
I guess it depends upon how hacked the code in the Access database is whether it would be complex to migrate to an adp. I too have worked in Access...
September 12, 2008 at 11:54 am
Steve
Of course a .NET application may be the ultimate goal but there is no reason any Access.mdb database could not be migrated to an adp with minimal effort. The adp...
September 12, 2008 at 10:00 am
You are absolutely correct. Write module level code using ADO and use an Access .adp Project, NOT linked tables or .mdb file. Use Access only for you forms and reports....
September 12, 2008 at 9:34 am
Viewing 12 posts - 1 through 12 (of 12 total)