That is a really bad idea.

First of all, only the sysadmin should have sa access.

Second, most accounting systems are very complex behind the scenes, and technical documentation is usually sparse....

You can install SQL 2000 Dev Edition on Vista Business RTM; I did it. No tricks or tweaks, except for being logged in with an Administrator account and with UAC...

As Andy said, ethics has a lot of gray areas. If you look at the American Medical Association's code of ethics, there are 200 opinions attached that relate to specific...

You can install it, but the Sync Center will make you nervous

http://www.sqlservercentral.com/Forums/Topic367417-5-1.aspx

As Brad said "it really is down to SQLServerCentral.Com to take the lead, and create a code of ethics using the input of the largest DBA community on Earth"

I had used SSMA to convert my database, and the Memo fields were converted as nvarchar(max) & the full data was moved over, but Access could only see the last...

In my experience, the SQL Native Client performs much faster than the old provider. I would recommend having the admins install the Native Client on your user PC's.

gabe,

By default Access runs queries in a transaction, so it uses 2x the space that you would expect it to.

First, try setting your query property UseTransaction = No

If that doesn't...

Take a look at this article, it shows how to invoke the Windows screen saver with the password prompt:

Starting a Screen saver using VB6 code - Visual Basic - Source...

Pedro,

You can use this in your query to convert each month / year to the 1st day of the month / year:

DateSerial([YearField],[MonthField],1)

That function returns a date, so you could use

WHERE...

Charles, I also looked at my old versions & my skill set included WordPerfect and Quattro Pro. I forgot what those are 🙂

Congratulations to Steve & the SSC team!

This is a great place to give & get advice and exchange ideas.

That is your safety net. SSMA renames the original tables, so if anything in the conversion fails then you have the option of deleting the links & renaming the tables...

Hyperlinks get converted to text, so you have to go into the Access app & change the controls back to hyperlinks.

Memo fields are converted to nvarchar(max) and all the data...

We are wrapping up a project converting an Access 2003 db to SQL Server 2005, and the SSMA does a great job with a few minor exceptions.

The key to a...