Talk:Connecting to Microsoft Access

I have got only a German version of WinXP Home. Therefore I don't know the English terms. I have add (German) at those places and hope, that someone with an English Windows system can exchange the terms with the correct English terms.

I'm no native English and my English is not very good. Therefore don't hesitate to correct all the errors.

There remain many questions and problems. If you know solutions please add them:

• What about the Share items in the ADO connection string? Do they work as described in MSDN?

• Can you copy the workgroup information file to another computer? http://support.microsoft.com/?scid=kb%3Ben-us%3B305542&x=12&y=13 might answer it. I have not tested it.

• To what consequences lead the settings in ADO and ODBC connection?

• In which situation are the user authentication necessary in an ADO connection? User name and password are in the connection string already.

• Can you alter the structure of tables with direct SQL commands?

• Can you use the user administration of MDB databases with direct SQL commands?

• What are the differences between ADO and ODBC connection concerning the possible SQL commands?

• What about performance when using large tables?

• Are the relationships between tables handled correctly?

• Can the index which is generated in MS Access be used in OOo?

• Is it possible to access the attachments of an ACCDB file, with macros for example?

• Are there known problems concerning field formats?