 -boRg- wrote:
The simplest way I have found, but requires MS SQL Server and Access installed on your local machine and a second SQL Server at your web host, is:-
1. Create the database a blank SQL Server database at your web host
2. Run the 'msSQL_server_setup.asp' file to create the database tables, Stored Procedure's etc. on your SQL Server database at your web host
3. Use Enterprise Manager to delete ALL the newly created tables on the SQL Server database created at your web host, just leaving the Stored Procedures.
4. Now on your local machine open your original Access database in Access
1. From the Tools menu in Access, select the 'Upsize Wizard'
2. Choose the Upsize option to 'Create a new database'
3. Choose 'local as your SQL Server and 'Use Trusted Connection'
4. Next select ALL the tables to upsize
5. Leave all other options as default
5. Once your database tables have been upsized using this method, use the 'Export Tool' in Enterprise Manager to upload the tables to the SQL Server database at your web host which you created the Stored Procedures in earlier
6. That should be it
|
It's works perfectly on my local server, the forum run as well, so i use the 'Export Tool' in Enterprise Manager to upload the tables to the SQL Server database at my web host but if i want do something i get this error message:
Server Error in Forum Application
An error has occured while writing to the database.
Please contact the forum administrator.
Support Error Code:- err_SQLServer_save_new_post_data
File Name:- new_post.asp
Error details:-
ADODB.Recordset
The set of recordings according to does not take charges the update of it. It is perhaps about a limitation of the supplier or type of selected bolt. |
what does it occur ?
|