Search results for query: *

Ok heres my situation. I was planning on reinstalling windows on my box, so i got out my cd and booted it up. As i hurried through the process, i came to the partitoning screen and accidentally deleted my Media partition on my external usb harddisk. Now i know the files are still there. I tried...

Where did Microsoft stash the DAO Object Model documentation? I can't find the reference which lists the DAO Object Model, objects, methods, properties, parameters, etc.? I know MS wants us to move on - but I need to support some old Access code - and I can't find where the docs have gone!!!

ODBC supports connection pooling. Is there anyway to tell Access to use ODBC connection pooling for linked tables?

I'd like to set up an ODBC DSN to a table in a linked SQL Server, via my local SQL Server. I'm having a few problems: 1. When I use Enterprise Manager to link the remote SQL Server, it doesn't allow me to select the database in the remote server. It only shows one database. 2. When I use the...

I have an Access DB using bound controls to linked tables on a SQL Server. The SQL Server profiler shows that Access is consistently logging in and logging out, each time a form is loaded, or a control changes (and a corresponding control needs to be refereshed)! How can I tell Access to keep...

Is there anyway I can convert my MDB to an Access Project, but still reference some tables stored locally, in MDB's? Also, what is the command to convert an MDB into an Access Project?

I have an Access MDB that I'd like to connect to SQL Server. For performance, I don't want to use ODBC, but rather OLE DB - Data Link Properties. Is there anyway I can do this? (I can't convert to an Access Project, since I need to use some local tables, and besides, I didn't write the code -...

I'm working on an Access front end, connected to a SQL Server back end (as linked tables). Over the LAN, it's fine, but over a WAN (ping <50ms), it's slow as molasses. I ran the SQL Profiler, and it shows a separate Audit Login and Augit Logout for each query. It seems like Access is logging...

I'm working on an Access front end, connected to a SQL Server back end (as linked tables). Over the LAN, it's fine, but over a WAN (ping <50ms), it's slow as molasses. I ran the SQL Profiler, and it shows a separate Audit Login and Augit Logout for each query. It seems like Access is logging...

I'm working on a database in which someone tried setting up replication and aborted it. I'm trying to undo the effects. 1) rowguid cols, and indexes for them, where added to all of the tables. Will these affect performance? Is it okay for me to delete them? (Again, at the end, we do NOT...

How do I use the SQL Profiler to see a trace of all SQL against the db? I'm able to run the SQL Profiler, but I can't figure out how to use it to a log of all the SQL statements ran.

I'm showing a bunch of "magic queries" with names like: ~sq_cfrmSetGraphicReport~sq_clstLocations ~sq_cfrmSetGraphicReport~sq_clstMaps ~sq_dADTReport~sq_dADTSubReportAM ~sq_dADTReport~sq_dADTSubReportPM I can view them using the QueryDefs collection. And sometimes I get error messages from...

Is there any way I can dump all of the VB source code - for all the forms and modules - into a text file?

I'm trying to analyze an Access MDB file which my client says is going very slowly. How can I: 1) Open the DB without running the AutoExec macro 2) Cause the menu bar (the one that lets me see the tables, forms, reports, etc.) to show, when it is normally hidden? 3) Dump the source code for all...

Is there anyway I can open an Access 2003 file on a machine with only Access 2000? At the very least, just to dump the VBA code out of it?

Is there anyway I can see a log of which queries ran, and how long they took, or at least the slow ones? Preferabbly, I'd like to do this remotely via the command line.

Hi. I've been asked to do some work on a SQL Server, remotely via a VPN. I'd like to be able to issue basic SQL commands to it via some type of command shell. Things like CREATE DATABASE etc. I don't need any GUI's, just a way to issue commands to the server remotely, preferrably from a...

How can I get Precision 450 (DELL) to boot a logical array configured on a HP SmartArray 6400 SCSI controller? I have a MegaRAID 500 and the system BIOS detects it and allows the system to boot to it. However, the BIOS cannot detect the SmartArray. Also, when I boot into Windows from an IDE...

How can I get Dell Precision 450 to boot a logical array configured on a HP SmartArray 6400 SCSI controller? I have a MegaRAID 500 and the system BIOS detects it and allows the system to boot to it. However, the BIOS cannot detect the SmartArray. Also, when I boot into Windows from an IDE...

How can I get Dell Precision 450 to boot a logical array configured on a HP SmartArray 6400 SCSI controller? I have a MegaRAID 500 and the system BIOS detects it and allows the system to boot to it. However, the BIOS cannot detect the SmartArray. Also, when I boot into Windows from an IDE...