When you open the Access database with Administrator account, are you opening it on the server or on a workstation?

If on a workstation: Are the workstation and the SQL server...

It worked for me that way. You just have to make sure you use the same collation when installing the SQL Server 2000. Then you have less problems with the...

You might find the following article interesting:

http://support.microsoft.com/directory/article.asp?ID=KB;EN-US;Q308744&

Cheers, hot2use

__________________________________

Searching the KB articles is like

picking your nose. You never know

what you'll find.

I found out that the error number is 146 and severity is 15.

Will continue to search for solution.

__________________________________

Searching the KB articles is like

picking your nose. You never know

what you'll...

quote:

---

I get an ODBC error.

---

What does the error message display?

__________________________________

Searching the KB articles is like...

Sometimes it is even easier than re-arranging the joins.

We had a query that should have returned one result. The query contained one single inner right join.

Using the Query...

We use both at our company. About half a year ago we had a situation, where a user couldn't connect to a remote system (running SQL Server) within his Enterprise...

Now that's when the real fun things happened. I could connect to the database with QA using the DCRM user or the sa user. No problems at all. The objects...

Ok guys. Here some feedback from my side.

It's a known issue with IE. The euro glyph/sign is only supported during input. It can't display the euro glyph when reading it...

Hi steven_white40

Yeah, I can see the euro sign when I query with QA. So it seems like I've got a Merant JDBC problem of sorts? Or could it be just...

Well, what should I say?

It worked just fine. Thank you Antares686, for pointing in the right direction.

__________________________________

Searching the KB articles is like

picking your nose. You never...

Thanks a lot for the tip with the sp_attach_db and sp_detach_db sprocs. I was looking at them before I posted, but was not quite sure what to do with them.

The...