Search results for query: *

tried it, bought it, didnt work.

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...

Thanks. Do you mean that I can issue SQL Queries using ADO - even to a local MDB - just that I can't use bound controls and the like? (My objective is to speed up a legacy Access database. The Access database is now being used as a front end to SQL Server, but keeps some temporary data in...

Yeah, I tried it, doesn't work. I think that trick is only for MDB back ends, not SQL Server back ends.

Right, but my question is: Using the ODBC Adminsitrator, you can choose a default database for the Data Source that you are creating. I'd like the default database to be a databse in the linked server - but the ODBC Administrator won't allow this.

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!!!

I'd really appreciate it if someone could help me get started with this. If my post is unclear or you need more info, just let me know!

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 know that ODBC supports connection pooling. Couldn't I use this to keep the connection alive?

I think .ldb's are only relevant to Jet BackEnd's - not SQL Server backends, no?

Thanks for the tip. I actually didn't develop this project - just brought in to speed it up. I see from the SQL Profiler that the main problem is that Access keeps on reconnecting - so I'd like to address that first.

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...

How can I tell if the triggers are still there? Also, the rowguid columns are indexed. Should I remove this, as the index will slow down writes? Or just leave it?

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.