Search results for query: *

I'm looping through TDFs as a part of an object inventory I run on my database and I keep getting a table called f_58E353365D1F420E91DF0D95DECDD042_Data. It is a local table, yet when I set the navigation options to show hidden tables and system tables, I still can't see it. Does anyone know why...

I have an unbound form that on open I store the field values in the .tag of the field. On close of the form I run a module to compare and then record any edits. I am having issues with users closing the database with the form open and the edit checking isn't firing, hence the edits aren't...

I have a gif image that I am trying to make appear behind all of the objects on my form. It works for objects that have a solid back style but not if the object has a transparent back style. Is there a way to prioritize which transparent object takes precedence? For example, labels on my text...

Checking OldValue of bound comboboxes on multiple forms. Some are throwing error 3251 (Operation is not supported for this type of object). I can't find any consistency for this but it just started happening. It is an Access 2003 database and we have been using it for years without problem. I...

I am writing code to delete links to my SQL Server tables and when I run the function, it doesn't delete all the tables. I have a total of 89 linked SQL tables and I have to run the function 5 times to delete all the tables. Here's the code I'm running: Function DeleteSQLTableLinks() 'On...

I'm creating a file DSN to store on a network location for use with an Access 2003 mdb that has linked tables that are connected to a SQL Server 2005 database. (There are also local mdb tables which is why it's still an mdb.) Considering that I am having Access 2003 connect to SQL Server 2005...

I need to use ADOX to refresh links to my SQL Server tables as I am using a DSN-less connection. When the user logs on, I want to refresh the links to the SQL Server as well as when I open forms that have queries as the rowsource for objects like comboboxes, etc. just in case the connection to...

Converting a database backend to SQL Server. Still have a bunch of local tables that won't be converted (they act as temp tables) so I have local and SQL Server linked tables I am contending with. This seems like a basic question, but I have a DSN-less connection programmed in a global...

I have the daunting task of converting a 12 year old Access 2003 database (which was originally built in 2000) to work with a SQL 2012 backend. (Once that's done, I will begin rebuilding the forms and reports in ASP.NET). I tried using the existing DAO code but there were error tables that were...

Newbie question: I have a production server that has SQL Server 2008 Express on it and I want to copy the database to a dev server. First, the two servers cannot see each other, how do I do it if they are on separate networks? Second, if I do a database copy, will all the users and logins...

This is a total newbie question, but I'm trying to set up a dev environment so I can take over developing an existing app that is in production. What is the typical set up for deploying changes to an app when my production server is in a DMZ and secured? Since my dev server is on the LAN I can...

I've created the ASP.NET Membership tables for my database on my dev server. I have two questions: 1. I am sending some of the ASP.NET development work to an outside consultant. I need to send him the complete database so he can create the web forms I need. Since the Membership setup creates...

I have been given the task of converting several Access databases to SQL Server 2005- I'm doing it in stages so I have the need to import Access data into the SQL Server hourly for the users that will consume it read-only for now. What is the best process for doing the hourly import: 1...

I'm using code I got at a conference to generate a table to log all DDL events in my databases, then I have code to create a trigger on all my databases to add a record to the table upon any DDL event. Being the newbie that I am, I ran the trigger and it created in the first database on my...

I have a Clients table and a Vendors table, both of which I need to connect to an Addresses table through an associate table for a many to many relationship. So, rather than having to create two associate tables (t_Clients_Addresses & t_Vendors_Addresses) I would like to create...

I have a need to store certain non-English characters from Spanish, French or German infrequently. They will either be in client names or client project names, but it's not like it's a multilingual database. I've read that it shouldn't be a problem with varchar since it's based on ASCII and...

I'm using SQL Server 2005 and I have an Exchange 2003 server on my network that I administer as well. In setting up the DB Mail I noted the options for the smtp account authentication are "Windows authentication using database engine service credentials", "Basic Authentication" or "Anonymous...

I haven't found anything in the FAQ's or in this forum about this subject but I've got to believe there are a lot of people needing this feature, so here goes: I have a table of team members that are assigned to a client. My users want to be able to sort the team members in the client's record...

I'm trying to build a stored procedure that I can reuse when I'm building and testing databases. Often I want to drop all tables in a database that I specify but I'm not sure of the syntax. Here's my current proc: set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO CREATE PROCEDURE...

I'm sure I'm not the only one who has to do this, but I'm not sure the best approach and can't find anything specific about this, so here's my quandary: I have projects that are assigned a completion date that may or may not be specific. If we know the completion date because the contract is...