Search results

A guy I do MS Access work for has a copy of 2010 and I took a look at it last year and didn't recognize it at all. He would like to eventually change over to 2010 but I'm sure his 2000 DB will have its share of crashes in the process, and it would seem I need to learn the new format so I know...

I design/maintain an Access database for a friend's business using my home computer. The printer he uses allows for much smaller margins than mine does, so anytime I edit a specific report that uses very small margins, my computer automatically increases them to the minimum margins my printer...

Yes, using MS Access front end

At the risk of sounding dumb, what is FE? Everything having to do with exporting from SQL server goes to the same wizard and there are options such as "Microsoft Access Treiber" but that is requiring a DSN and I have no idea where to go from there, or what a treiber is.

OK, it is using SQL server authentication. This is what I found out. There are 3 users under this database. The "dbo" owner with the "sa" login is the one that fails. I was able to connect to the "scottb" user and I even changed permissions for a few of the tables... But when I...

The only connection that was set up had a user name of "sa" and no password. I think that's a default login isn't it? Being that I have never used this software I will have to try to figure out now to create a new user and see if I can connect that way. There is only one user besides myself...

There are about 50 tables in SQL server. Would exporting to CSV create a separate file for each table? Outdated version of SQL server, outdated Win 2000 OS on that computer, can't afford to upgrade and having major connection issues...

I had asked a previous question about a SQL server issue and worst case scenario, if the problem can't be fixed by a tech without spending a lot of money, I may have to go to using a regular MS Access back end. If this is the case, is there a way to extract all of the table data stored in SQL...

OK I did check permissions for the users within Enterprise Manager and they all set to be set normally. Because time is of the essence here I did have to reach out to a computer tech company to see if they can find the problem. This seems to be way over my head at this point. Thanks for all...

OK I will check into that tomorrow when I am at work. As for Windows authentication or SQL Server authentication, I didn't set this up so I have no idea. How would I find this out? Thanks

By server do you mean the PC containing SQL server? That computer can be successfully accessed through the network by all other computers. The computer that contains the data and SQL server can't even connect to SQL server through MC Access.

I will have to check into this tomorrow when I am back at work. I will let you know what I find out. Thanks

SQL Server 2000, Windows 2000, like I said, installed many years ago. No updates done to anything. It worked at closing time yesterday and this morning it did not and nobody else could have been here. The computer with SQL server has been logged off all week. Nobody uses that actual computer...

I have my share of experience with MS Access but I know almost nothing about SQL server. As of this morning, at my office Access cannot connect to SQL server. Everything was fine with it for the last 12 years with no signs of trouble. At first I thought it was a network problem but even on...

I needed a new CD burner drive for my computer, which only has PATA connections for the CD drives, so I purchased a SATA hard drive along with a Molex to SATA adapter. The motherboard does have a secondary SATA data jack so I was able to connect the CD drive directly to that and use the adapter...

The field is a text data type. It would make the most sense to be a date type but on occasion that field will contain non-date data but I use IsDate to filter those out when sorting in a query.

No I did not know that Format$ converted a date into text. DateValue did the trick. Thanks much!

This is one of the ways I tried it and the result. Notice the 2012's mixed in there? I also tried flipping Format$ and CDate in the other order and the results were even worse.

Hello all, I have a text field that contains a date in this format 3/11/2011 11:32:17 AM I want to be able to keep just the date, not the time, and sort it. I thought I knew how to do this but apparently not. I have tried every combination of CDate, DateValue, and Format$ and I am not...

Another thing to mention, the windows firewall cannot be started. It says "windows cannot start the windows firewall/internet connection sharing ics service". I read that this could be a result of a virus corrupting the firewall files. Could the corrupted firewall be what is blocking the FTP?