Search results for query: *

Hi, I am having a bug w/ Access 2003 Package Wizard. It creates the setup.exe file fine, but when I run the setup.exe on another computer (Windows 2000), it does not run. I know why: I create the setup.exe in Windows XP and my target computer is Windows 2000. So, the shortcut name is...

Hi, This group seems pretty knowledgeable.... do you know how to make the runtime the default? I've used Access Package Wizard and it does not work for me. I'm creating the setup.exe on Windows XP, and my target app is Windwos 2000, and it creates the setup.exe fine, but when I run the...

ESquared, How do you create a self-extracting zip file? any knowledge-base articles on this? I too am ready to pull my hair out. Access Package Wizard is very buggy, I have Windows XP and it doesn't work when I install my app on windows 2000. I've thought about using SageKey, their package...

Hi, InstallShield 4.0 Express asks me to include my Access "redistributable disk image", provided w/ Access 2003 Developer Extensions I guess. Does anyone know exactly what they mean by the "redistributable disk image"??? Is this one file? several files? is it the ACCESSRT.MSI Windows...

all, thanks for the responses... yes I was trying to get away from the recordset method because it's more time costly. I guess stored procedures is the way to go because SQL server will then have to do the # crunching. Thanks, Christy.

Hi, I wanted to know, if I write a VB Public Function, say "Public Function GETNUMBERS(street as string) as string", the function will get the numbers from a street address. I built this function already, but what I want to know is - can I APPLY this function within a SELECT statement in VB...

I had the same problem; when you choose "english", then you have to browse for the Access SETUP.exe file - so go to where you have Access installed, click on the setup.exe file, then click on "Cache", and it should work OK. I think you have to look for the access 2003 setup.exe file, not the...

Hi, I ran the 2003 Access Package Wizard and it created the setup.exe file fine. But, when I copied the setup.exe to a CD and tried to run the setup.exe on another computer that does not have Access, I received the following error msg: "settings file d:/files/setup/setup.ini is missing or...

I do plan on having them run the Access DB and SQL Server on the same machine..... so all I would have to do is specify "Data Source=Local" in my connection string? Thanks, Christy.

MoLaker, Having an Access back-end is not an option for larger clientelle.

Hi, I want to replicate my Access front-end, SQL-server back-end application, so that I can distribute to other locations. The app is stand-alone for each user; different data. Right now my Access app works with SQL server DEVELOPER edition, and my question is, how do I configure my Access...

Hi, would I use this function: bfGetODBCConnect() if I want to replicate my Access/SQL-server app STRUCTURE, not data, in other locations? I need to connect to the person's server w/o hard-coding the connection string. thanks! christy.

Hi, I want to replicate my Access front-end, SQL-server back-end application, so that I can distribute to other locations. The app is stand-alone for each user; different data. Right now my Access app works with SQL server DEVELOPER edition, and my question is, how do I configure my Access...

Hi, I want to create an Access front-end w/ SQL server back-end. Right now I have SQL server Development version and have set up my server name as "cwsqlserver". My question is: if I were to try to replicate this system on another machine, with a real version of SQL Server 7.0, how would the...

Hi, I created this code to take out leading zero's and alpha's and other noise characters out of numeric codes like invoice #s, tax #s, etc. Enjoy! cwarner. Public Function filtercode(code As String) As String Dim i As Integer Dim firstrealnum As Integer Dim tempstr As String tempstr = "...

I did the same thing and created a variable on my form that contained the actual filename; I had users select a file to be read in, so it also changed all the time. so my transfertext statement looks like this: If Me!fileformat = "Comma-delimited (.csv)" Then DoCmd.TransferText acImportDelim...

Hi, I'm not sure if an import spec is the way to go, because I need to be very flexible in the files I am reading in. The end-user may have 5 fields or 10 fields, it just depends. And the columns can be named very differently and in different order. So I think I may try to find a way around...

Hi, I am using TransferText to read in a .csv file, but it's not reading in the invoice # when it's a combination of text and numeric, i.e. "VA12245", it just brings in a blank field. It reads in the all-number invoice #s fine. Any ideas as to what's happening? I'm not using an import spec...

Hi, A related question: what is the maximum size a recordset can get? Is it limited by Access2000's 2GB limitation? Are recordsets stored permanently or in a buffer? I am wanting to know this because I'm switching to an Access front-end w/ SQL Server back-end and don't want to limited in...

Hi again, Same question posed a different way.... I don't want to store any data permanently in my Access front-end (SQL Server back-end). I want to be able to open SQL server tables into Recordsets - but are Access recordsets somehow limited by the 2GB db limitation? Or are they stored in a...