Sorry, SA can pretty much touch any SQL file that is accessible on the server and he gets full rights. Don't know if Microsoft has any plans to change, but...

Yes Jet 4 had a lot of improvement over Jet 3. Access XP also made some improvements on the use of Jet 4 from what was going on in 2000...

Access is ok for most small apps and when the only one user is using it locally. MSDE is sturdier and more scalable since you can move up to a...

I am with Steve, SA has ultimate rights and there is no way to prevent this as that was what it is for.

"Don't roll your eyes at me. I will...

So you get this on your DSN connection. Try from the machine you are having troubles with and pining the SQL Server. Also are you using named connections or ip...

1) Yes, but you should also have other knowledge in programming so that you understand what people are doing to your database and OS to understand how your files and...

Or maybe you need a compound unique index if the nulls will have to exist.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

No but I have been tempted. I have an inconsitant rule not to use the expected punishment (varies push up, restriction, or something else).

"Don't roll your eyes at me. I...

If worst come to worse you could write an external app that can run in the user environment that can see the mapped drive to kick off the DTS package....

Can you post an example of what you did, it will make it easier to understand what is happening.

"Don't roll your eyes at me. I will tape them in place."...

The only thing that may make this any better would be to make sure that t1.idnr +1 does = t2.idnr would be to do a subquery something like (SELECT TOP...

Hey who needs security, there is always some bug to exploit and get around it anyway. HaHahahahahahahahah But anyway, if you are using NTFS (which I hope)...

Duplicate post to other thread.

I have never used but this may help http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/vfpodbcsqldriverconnect.asp , the article is with Microsoft and from I can understand you have to look at SQLBrowseConnect...

I have never used but this may help http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/vfpodbcsqldriverconnect.asp , the article is with Microsoft and from I can understand you have to look at SQLBrowseConnect for some detail. If...

Try this (you will need to do this when the system can have some downtime).

First script all the database objects and permissions as you will need.

Now rename the...