Recent content by ladyfrankie

Good Afternoon, Having upgraded my Access front end to .accdb format, I discovered that Microsoft have dropped the function Workgroup Administrator and from what I have read it wasn't really a good solution to keeping a database secure. The database I look after, has an SQL backend with a user...

Hello There, I have attempted to create a test environment, by creating a blank database in SQL and restoring a backup of the live environment over the blank database (now called test db). I then took a copy of the Access MDB file,and renamed this to testMDB. I then created a new ODBC link to...

Hello, I have been recently tasked with migrating the front end of an Access database to Access 2010. This is something I have never done before. The database tables sit in SQL server 2005. As part of the migration I will need to upgrate to SQL Server 2012. I am aware that a convertion...

Good Afternoon, In the existing database that I maintain, there are a few lines of code that dictate what application is used to open a file type with a specific file extension when a user doubleclicks a field containing a path to a specific file. I have attached the code. (Code 1.txt) The...

Hello there, I hope I describe this well the issue I am facing. Here goes! I am a relevatively new Access Developer, so please bare with me. I hope I have posted this in the correct place. The Database that I am currently working on is currently in SQL but as an Access 2003 front end. I have...

Hello Out there! I have an application support background, but have recently started a job that requires me to solely perform Access Development - VBA. Very interesting and is stretching me greatly. Joined the forum today because I know I will be needing help. :)