Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.10 seconds.
Search: Posts Made By: Alc
Forum: General 11-22-2019, 09:45 AM
Replies: 37
Views: 837
Posted By Alc
Re: What determines if someone has exclusive access to a database?

Thanks, will do.


If so, it would have been many years back. I started using an alias after I got some abusive private messages.


I'll take you up on this, I think. I need to keep on it, but...
Forum: General 11-21-2019, 09:46 AM
Replies: 37
Views: 837
Posted By Alc
Re: What determines if someone has exclusive access to a database?

Yes. The problem is reproducable in the standalone version I uploaded. It's on my C drive. No other users or databases are involved.

No connections are involved. In the live version, there is a...
Forum: General 11-21-2019, 09:27 AM
Replies: 37
Views: 837
Posted By Alc
Re: What determines if someone has exclusive access to a database?

The reason for the multiple 'set' locations was for testing, by my predecessor. If he wanted to only open a particular form and test it, thereby bypassing ModelWarranty, the variable db wouldn't get...
Forum: General 11-21-2019, 08:46 AM
Replies: 37
Views: 837
Posted By Alc
Re: What determines if someone has exclusive access to a database?

Please don't spend any more time on this.

Db is declared as a global variable in module 'modPubRoutines' and was initially set to CurrentDb when in the FormOpen event of ModelWarranty. When I...
Forum: General 11-21-2019, 04:25 AM
Replies: 37
Views: 837
Posted By Alc
Re: What determines if someone has exclusive access to a database?

Okay, not trying to be difficult but it seems I have been. I genuinely appreciate the help certain people have offered.

New version of the db attached. Timer disabled, all menus and close button...
Forum: General 11-20-2019, 10:16 AM
Replies: 37
Views: 837
Posted By Alc
Re: What determines if someone has exclusive access to a database?

Sorry, I'm not sure where the confusion is coming in?
Ignore the tab controls. The tab controls aren't relevant, just use the buttons named.
I've attached a document with pictures of each stage up...
Forum: General 11-20-2019, 09:05 AM
Replies: 37
Views: 837
Posted By Alc
Re: What determines if someone has exclusive access to a database?

Thanks for the comments. I don't expect you to waste any time on this.

I converted all tables to local versions but forgot to remove the call to connect to them. Now done.

I didn't disable the...
Forum: General 11-20-2019, 04:31 AM
Replies: 37
Views: 837
Posted By Alc
Forum: General 11-19-2019, 10:32 AM
Replies: 37
Views: 837
Posted By Alc
Re: What determines if someone has exclusive access to a database?

Okay, I created a very cut down version with gibberish data, so I could upload it. Ignore any errors outside those generated by the following steps.

The steps to recreate the problem:
1. I open...
Forum: General 11-19-2019, 10:09 AM
Replies: 37
Views: 837
Posted By Alc
Re: What determines if someone has exclusive access to a database?

Just tried it, same result for that user.
Forum: General 11-18-2019, 11:56 AM
Replies: 14
Views: 248
Posted By Alc
Re: Odd New Error

Was halfway through typing the same thing. :)
Forum: General 11-18-2019, 08:50 AM
Replies: 37
Views: 837
Posted By Alc
Unhappy Re: What determines if someone has exclusive access to a database?

Nice idea, but the company replaces our laptops every year, so the one I'm using now is different from the one the db was built on and the one where I found the initial problem.:(
Hopefully, once...
Forum: General 11-18-2019, 08:42 AM
Replies: 14
Views: 248
Posted By Alc
Re: Odd New Error

If it's any use, I use this on close in multiple databases, to back up the various back ends. No problems, thus far.


Function Backup_Backend()
Dim strPath As String
Dim strFile As...
Forum: General 11-18-2019, 08:31 AM
Replies: 37
Views: 837
Posted By Alc
Re: What determines if someone has exclusive access to a database?

I'll get on that now (before I get pulled onto something else).
Many thanks.
Forum: General 11-18-2019, 08:23 AM
Replies: 37
Views: 837
Posted By Alc
Re: What determines if someone has exclusive access to a database?

I would assume so, yes.
Looking at the db now, I think I may be able to recreate it with a very stripped down version and some nonsense data.
What form is preferred for uploading? Zip files?
Forum: General 11-18-2019, 08:17 AM
Replies: 37
Views: 837
Posted By Alc
Re: What determines if someone has exclusive access to a database?

Thanks for the response.
In order:
Yes, it's survived that long. As I say, from the users' perspective nothing is wrong. It's only when changes need to be made. Any on the last few years have been...
Forum: General 11-18-2019, 07:57 AM
Replies: 14
Views: 248
Posted By Alc
Re: Odd New Error

Have you tried importing everything into a new, blank db?
Takes longer than the compact and repair, but it's helped me in the past.
Forum: General 11-18-2019, 07:41 AM
Replies: 14
Views: 248
Posted By Alc
Re: Odd New Error

I had a similar problem, some time back.
In my case, the db had also increased in size by a fair amount. Running a compact and repair fixed the problem.
It turned out that one user didn't like the...
Forum: General 11-18-2019, 07:26 AM
Replies: 37
Views: 837
Posted By Alc
Re: What determines if someone has exclusive access to a database?

Much to my shame, I was pulled onto other tasks after posting this question and was never able to devote time to get to the bottom of it. Now, however, I'm back working in the same db and would like...
Forum: General 11-06-2019, 07:00 AM
Replies: 25
Views: 382
Posted By Alc
Re: Access not detecting correct version of Outlook

Okay, so the following works for what we need. It's a simplified version of what I was originally asked for, but it's going to do the trick.

Background
1. Someone is sent an email with a link to...
Forum: General 10-24-2019, 03:53 AM
Replies: 25
Views: 382
Posted By Alc
Re: Access not detecting correct version of Outlook

Thanks a lot. That's exactly the situation we're in.

I'll have to set aside a bit of time and work through that.
Forum: General 10-24-2019, 03:32 AM
Replies: 25
Views: 382
Posted By Alc
Re: Access not detecting correct version of Outlook

Thanks for asking. I don't have any experience of doing that, but I'm open to any method that may work.
Forum: General 10-24-2019, 03:27 AM
Replies: 25
Views: 382
Posted By Alc
Re: Access not detecting correct version of Outlook

I get the distinct impression that I'm expected to try to find a solution that won't involve SharePoint at all. The manager's a little disenchanted with it at present, so I need to start in that...
Forum: General 10-23-2019, 10:01 AM
Replies: 25
Views: 382
Posted By Alc
Re: Access not detecting correct version of Outlook

Funny how often that seems to be true - one hand giveth....

I had a feeling that was going to be the case. In your opinion, would it be advisable to sort out code to 'pull' the data into Access...
Forum: General 10-23-2019, 09:51 AM
Replies: 25
Views: 382
Posted By Alc
Re: Access not detecting correct version of Outlook

We're not just using Access because some of the users, although within the same company, don't have access to the database.

The Sharepoint option isn't working. I have no idea why, I've never used...
Showing results 1 to 25 of 500

 
Forum Jump



All times are GMT -8. The time now is 10:06 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World