Search results

Actually I want to move tables and some codes to SQL Server and to use mdb only as a front end ... But the "size" phenomenon (some swear words) ...

I forgot to mention that the size froze after the database was corrupted and restored from the nightly share drive backup ... is it possible that the "corruption" did something with the database ability to "report" on its size?

C&R does not change anything ...

I checked the database tables: the number of records grow ... I thought may be this is something wrong with win explorer and checked properties of the copies - no, that's right, all copies have the same Size and Size on the disk ... and I would add to your pizza bet a case of beer that it's not...

Just one Access mdb file. Several users may use it simultaneously. Note: the file is used about 10 years without serious problems. Just lately the corporate laptops (~1600) were upgraded from Win 7 to Win 10, and Office 10 to Office 365.

No.

I save copies of my .mdb file daily for a month in a special folder. Database is actively used. Users add new records, queries. However the size of the database in Windows Explorer remains the same. Compact/repair does not change the size. I attach a snapshot of the folder ... Never heard of...

How can I view VBA code of macros? It was easy in Access 2003 but not in 2010. Thanks

I would Debug.Print SQL, copy it from the immediate window and paste it to the query window - it will show you the error (if any)

Thanks. I'll check it out. Again, I will follow Dr Doc advice - good idea.

Well, may be I cannot explain well. When I created an mdb database in 2012 it was in Access 2003. I set something (sorry do not remember how) that, when users open the database and the first form is on, right click does not bring up the popup menu, from which Design Mode can be selected. Now I...

I would run these queries using ADO command. Linking tables is not good, slows down and prone to inadvertent record changes by user

Extension is mdb, but I cannot "unlock" it neither in Office 2007 nor 2010 Access. mde is irrelevant in this case. Thanks Val

Are front end apps have LINKED tables or you are sending the query over ADO?

I created Access database some time ago (Access 2003) and disabled design mode for users. Now IT installed Office 2007 to all laptops in the system. I want to " unlock" this "no design mode" state but do not know how to do this (Google does not help much). Please, help. Thanks Val

Ok, let me try it. Thank you Ranman256 Val (007 ;-)

is "path to the signature" - hyperlink (text)? OLE field - is it type of container? Thanks

I need to insert department manager signature (we have 12 departments) into report. Depending on the department the signature would be different. I have scanned images of all signatures in the folder located at a remote network drive. How to place an appropriate signature? Can I use a hyperlink...

Thanks everybody!

I hope they do not plan to switch from VBA to something like .NET? BTW, is there an option to use VB.NET within next generations of MS Access?