ACCESS FEED: RE: [MS_AccessPros] Re: system resource exceeded on ddl

Senin, 28 Maret 2016

RE: [MS_AccessPros] Re: system resource exceeded on ddl

Follow up – before I did anything, I did actually change the name of the index and it ran without error.

Oopsies.

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Monday, March 28, 2016 9:41 AM
To: 'MS_Access_Professionals@yahoogroups.com'
Subject: RE: [MS_AccessPros] Re: system resource exceeded on ddl

Friends. Thanks John, Bill, and A.

I like the idea of copying just the data and they re-indexing from there.

Same name – I forget sometimes that VBA is not case sensitive like C#.

StartDate is a date, but I am honing in on data that matches employee hours by date from separate tables.

Our company has plenty of sql servers, but since I am shadow IT I had to go a different route. There is a CER but I don't know the status as my boss has been away. There is no way that doing the company workstation, sql express, etc. would work as we have citrix and an intranet. There would be no way to do that.

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Saturday, March 26, 2016 2:15 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: system resource exceeded on ddl

Hi Liz,

the first thing I would do is try to stop calling objects by the same name ;-)

Have you tried:

CREATE INDEX xStartDate on MainFull (StartDate)

Secondly, you are going to link to another table on a field called "StartDate", what field type is this?

As for SQL Server, surely a company like yours has the resourc! es to supply SQL Server on a shared resource basis? That is to say, you either get just a database in a SQL Server where others have their Databases, or an Instance on a server where others have their Instances.

If getting a resource in a shared environment is not the real problem but the price is... just between you, me and the internet, I know some projects that get an old workplace machine and temporary Administrative Access for the machine, long enough to install SQL Server Express (including tools). In an environment which has heavy regulatory requirements this could be a sacking offence but some people find it easier to ask for forgiveness than permission. 0:-)

Yrs, A

This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.