Sometimes when I open the .ldb index files in Notepad I can see a list of users who have the back end open. Other times it is garbage - little squares and...

Excessive crossposts have been trimmed. The code I use in my sample only checks to see that the 2 versions are different. It doesn't care what the difference...

We are running an Access 2000 MDB with a SQL 7 back end. Our network guy is upgrading to Windows Server 2003 and wants to upgrade Office and SQL Server at the...

Hi I'm creating a series of forms, each with with around 15-20 text boxes. The text boxes will show data from tables, but are unbound to make them more...

Hi , I am creating form from code using 'CreateForm' and 'CreateControl' functions. Everything works fine, as we plan to deploy MDE version soon, question is...

This question is intended for MVP's, consultants, etc., who develop and deploy Access projects in larger/multiuser environments (at least 5 users and...

We are having problems with databases becomming corrupt and the Compact and Repair Database feature not helping at all. It seems to coincide with our...

For years my office has been exporting data from a SQL BE via Access to a spreadsheet. It takes 1 person 10 hours to change the data based on a bunch of...

Hi, I've successfully made an Add-In for Access 97, but in order to make it work for later versions I need to study the code in the Access wizards. I used...

Hi What future does access have after the release of vs 2005/sql 2005? MS doesn't seem to have done anything major with access lately and presumably hoping...

If you are looking for opinon on what's useful in Access 2007, there's a new article at: http://allenbrowne.com/Access2007.html Covers what's good...

Have an Access MDB (2002/3 format) running against a SQL Server back end, using ODBC linked tables. Recently upgraded from SQL 7 to SQL 2005. With the bit...

I think the main forum in Microsoft is to racist as even if I asking question in English I get no help. Many people are ask question in english but not...

Any idea why I can no longer select the the reference "Microsoft ADO Ext. 2.8 for DDL and Security?" It's not in the list anymore?

Hi, I am unable to create or access any reports from my access database. I have tryed re-installing access and this has not made any difference. Thanks

I have split databases before and I have put passwords on them. I have never applied user-level security though. At the moment I have a project that will...

I have a form, frmMain that uses a query as its underlying datasource. The query sorts the records in a certain way. How come the records aren't sorted the...

I have an address query which ouputs a single field to text strings for Google Earth .kml file format parameters. The problem is that the .kml file requires...

Is it possible for a record (row) to be deleted from an Access table without any prompting or input from the user. This is the scenario: I have a user who...

All my Dates in my friends access db are erroring now that my friend has windows 7 Installed, Has anyone heard about this??? -- Thanks in advance for any...