System DSN's are stored in HKey_LocalMachine, User ones are stored in Hkey_CurrentUser, File DSN's are stored in the file system. You use a user DSN if you want the setting...

I've done it many times with no issues, no reason there should be even. The problem is that you have to stop the service on the source machine to make...

Probably worthwhile to run Profiler for a while, capture what's going on, may give you insight into what part of your app was running when the problem occurred.

Andy

The ADO stream object is probably the best. Check out this link:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q258038

Andy

Once you get beyond a few users you generally use SQL. Also I think that across a WAN you'll see better performance. You can still build front ends in Access...

Try MDAC 2.6. MDAC 2.5 doesn't support named instances directly, you have to configure an alias to get it to work. I've had no problems with 2.6.

Andy

Sometimes. Overall we've done pretty well, we always encourage posters to come back and let us know the resolution. Sucks to be trying to solve a problem and find the...

I only have two so I've had no need so far. Havent used it enough to know what issues might be involved if you have a problem with msdb on...

I don't have any experience running a huge enterprise but from what I've seen SQL and Win2K is pretty stable, just booted one of my boxes after 180 days -...

Just DMO won't be enough, servers don't have to publish themselves so you could have a hidden server running SQL. Haven't thought about a good way to find ALL of...

You might want to look at my article:

http://www.sqlservercentral.com/columnists/awarren/alterreplicatedtable.asp

Robert Marda had a post about altering the system tables to make it "not replicated" long enough to alter a constraint - take...

Freezes doing what? Most likely it is client code, not the server - far less likely to have locking issues with SQL compared to Access.

Andy

I think it might get used. My advice is to make it work first, then add bells and whistles!

Andy

Yes, there can be multiple rows in the inserted table. Triggers fire per transaction, not per row. ALL triggers should be coded assuming that multiple rows will be affected. The...

You could create an alert that would run the job again. Or just have a job that checks every hour or so to start any replication job that is not...