Just open up the relationship window, select the relationship - delete it then you can delete the table.

I have never been able to get the Linked Table manager to work with ODBC linked tables as it always halys with an error message.

If you try and open the Access Database and are prompted for the UserID and Password ie there is an associated .mdw file (a Workgroup file) then the person who...

Try this site http://www.vbcity.com/default.asp

You only need a PK on an SQL table if you want to update or delete from Access. If you only read the tables then when you first link the...

I normally use a temp table to store the results of the query then use the table in the transfertext method.

Forms Usually only show the first 10000 records by default. If you show the navagation bar and click end you will get a slider to increase the number of records....

Try renaming your macro to autoexec - this should then run automatically. If you want to run some code then use the runcode action in a macro or create a...