Search results

  1. G

    Turn of warnings on DB startup - Is this possible?

    Keith, Did you solve your problem? I have the same issue. The Access Project front ends are used by multiple users across the network in a number of remote locations. I can't dictate which Access version or service pack they have installed. Some are only using Access run time. So I want some...
  2. G

    "dbo." Table qualifier in Access Project on sql backend

    Fixed The issue related to users who where also members of the Database role DB_Owner. I removed them from this role and all is well. Thanks.
  3. G

    Sql equilivant to Val() Access function??

    Does anyone know of a function to return the numeric value of a string that contains some numeric and some non numeric chars. I need to replace some Val() Access functions with a sql equilivant. e.g. return 123 from the statement: SELECT Val(123mls) return 4.56 from the statement: SELECT...
  4. G

    "dbo." Table qualifier in Access Project on sql backend

    Can anyone help please? I have Access Projects on SQL 2005 backends. Some users are on Access2000, some are on Access2003 and some use Access2003 RunTime only. I have no problems with the Access 2003 full versions or runtimes. But with Access 2000 users, some can't use any forms or reports...
  5. G

    Linking Access table to SQL Server

    This works for me EXEC sp_addlinkedserver @server = 'ACCESS_TRAINING_DB', @provider = 'Microsoft.Jet.OLEDB.4.0', @srvproduct = 'OLE DB Providr for Jet', @datasrc = '\\argon\data\training\training.mdb' To query use the complete 4 part definition i.e. Server.Database.schema.table This...
  6. G

    Upsizing Issues, Access to SQL Server

    I am upsizing a number of Access 2003 databases to SQL Server 2005 with Access Project front ends. My Access Tables all upsize OK, Some of the Queries upsize to SQL Views OK, Some Queries upsize to SQL Functions (WHY) and some get skipped completely. I have fixed up data type issues with...
Top Bottom