Tag Info

New answers tagged

0

The problem came from an insufficient privileges on the server where the Access file is stored. Here's how you should configure your server depending of the login type that you are using: If you are using SQL Server login: Give to the SQL Server Database Engine service account permissions to read and write (depending if you want to make CRUD on that file) ...


1

As Max says it sounds similar to a problem we had under a similar situation, especially for those working remote to the main comapny network. Ensure that under the Access databse Options Advanced tab that the OLE/DDE timeout that the figure is set to something like 300 and not the default of 30. Also in any VBA requests to the database adjust the ADODB ...


1

It sounds like your categories are a case of the subtypes pattern. Accordingly, I've added the tag subtypes to your question. There are two design patterns that you may want to look into. The first one is called "Single Table Inheritance". This design involves collecting all the subtypes (or, if you prefer, subclasses) into one table, and leaving ...



Top 50 recent answers are included