Sorry Shie, but country is really not an issue.  In dealing with companies, their holidays are different between them even when they are in the same country.  If you want...

Once you change it to a float, you will need to load the data from Access again.

Actually, if you are willing to use a "Date Table," make it a date dimension table.  Do all of the date calculations that can be done to a date ahead...

Carriage Return CHAR(13) is actually a hold over from the old line printers.  In order to get a carriage return and a line feed, it takes 2 characters CHAR(13) +...

If you still need it, email me off the forum and I can send it to you.

rl_stewart@highstream.net

Another clean way of doing it would be to use a Base-36 number (zero to Z).  Use a function to create it and default the value of the column to the function.

10...

I was making an assumption that they did not install the MSDE on a server or that they ended up buying a server to put SQL Server on.

But, Don is...

Nora,

First, install the client tools so you have Enterprise Manager.

Simply detach the current database from SQL MSDE.

Install the new SQL Server version, and attach the database file (MDF).

Robert

In SQL Server, it is only "bi_logical" (Yes/no, 0/1).  Access allows a "tri_logic", yes, no, null or -1, 0, null.  By cleaning out the nuls, you have the bi-logic working...

The easiest way is to use PayPal for payment and leave it up to the user to choose how they pay.  PayPal will allow the use of funds from your...

Unless you are using international character sets, keep it to varchar, text and char.  Leave the N off of them.  I have linked properly to tables the the N based...

If you have a many-to-many, then your design is wrong.  Follow Kimball's design and you will not have a problem with the cube.

The current versions of Access will not work with the BETA versions of SQL server.  So the answer is, it is impossible to setup as an Access Project.

Generally, I do also.  But, there is an argument that is valid for keeping it simple with code tables.  The main argument for doing it with dumb primary keys falls...

An ADP is not for adhoc queries.  And, I stand by my assertion that no one should ever have direct access to the tables, period. 

Distributing the application to multiple...