SQL Designer 1

[cancer2006]

I am using CRW8.5 and access97
Can you write DROP, CREATE, UPDATE, SELECT INTO statements from SQL Designer tool.

I am getting the following error

ODBC Error: [Microsoft][ODBC Microsoft Access Driver]Cannot modify the design of table 'eaccr'. It is in a read-only database.

I have full access to the database.

 

[synapsevampire]

SQL Designer was a bad idea all along, and is no longer available nor supported in Crystal.

The notion of using a report writer to modify data is off course for the products intent anyway, especially since you are using Access and can create queries within for such things.

I wouldn't use Excel or Word as a database, though theoretically I could, much as I wouldn't use Crystal to modify data.

-k

 

[ninjak]

Thanks for the help, that worked perfectly. I didn't know you could Sum() formulas. What are the exact rules as to what you can Sum() and what you cannot?

 

[ninjak]

Sorry about the previous message, I posted it to the wrong thread.