Importing *.csv Into Access97

Feb 27, 2006

Hi! I've got a problem with a csv file from our MRP system. It always contains spaces BEFORE the data in the fields and I need to ignore them when I group the data. The crosstab report works absolutely fine but I don't get the right output because of those darned spaces!!:mad:

HELP!!:confused:

View Replies


ADVERTISEMENT

Access97 SQL Syntax

Jul 25, 2005

I'm familiar with SQL but not with Access97 - some wierd syntax here!

I'm creating a Query that is to Delete records from a table depending on a non-key field in a second table.

I first tried an INNER JOIN


DELETE Activity_Preferences.*
FROM Activity_Preferences INNER JOIN Activity_Key
Activity_Preferences.Activity_Key=Activity_Key.Act ivity_Key AND Activity_Key.Complete=1;


which was initially accepted but then complained about the INNER JOIN after I went in a second time to 'fix' the error.

I've finally got the following syntax accepted:-


DELETE Activity_Preferences.*
FROM Activity_Preferences, Activity_Key
WHERE Activity_Preferences.Activity_Key=Activity_Key.Act ivity_Key AND Activity_Key.Complete=1;


But when executed still gets the following error (same as for the INNER JOIN):-

'Operation must use an updatable query'.

What else is needed?

J.
:confused:

View 4 Replies View Related

Access97 Problem

Nov 7, 2005

I have a multi user 97 DB which also has a 2000 front end with tables linked to the 97 version. The 97 version won't open on 97 machines, 'unknown database format'......at first I thought someone had converted it but it doesn't look like that has been done. When I open on a 2000 machine there is no option to 'convert to a previous version'.

I have run compact and repair on both DB's.

Any ideas what the problem could be.
Thanks
RussG

View 2 Replies View Related

Using ACCESS97 On WindowsXP Pro OS

Dec 14, 2005

I am a long time user of ACCESS but use ACCESS97 for specific reasons. Have ACCESS97 operating on a PC with Win2000 and WinXP Home. Recently had to buy a new PC with WinXP Professional. Cannot seem to install the software. In the process get some error messages. First,

"An error has occurred at changing workgroup data base"

I click OK then get,

couldn't create SYSTEM.MDW file; after setup completes, reboot and run Workgroup Administrator before you run this application

I don't know what to do next. Do not know what the Workgroup Administator is. Two questions:

1. Is it possible to run ACCESS97 on this OS?
2. If so, can you advise on how to do the installation successfully?

I appreciate any help that anyone can provide. Cheers!

View 1 Replies View Related

Open Access97 MDE With Access2000

Aug 4, 2005

...not too much in the archives on this one, so any help appreciated...

We have an Access97 MDE with a split backend that is shared over a network.

Most of our users have WinNT installed and the Access application works fine. We have a user who has Win2K and Office2k and every time this person tried to launch the Access97 app, he receives the following error:

The database that you are trying to open or convert is currently in use, or you do not have permission to open it exclusively.

I have checked the Security Permissions for that user and he actually has full rights (Admin) for the Network folder.

Anyone else experienced this ?

View 2 Replies View Related

How To Connect Access97 With ExcelXP??

Nov 28, 2005

Hi All,

I've been working on many other domains but very new to Access world. Anyway,coming to the point.I have a database built on Access and the reporting is being done on Excel.Till now,there is no connection between both.Users are doing copy/paste procedure for reporting in excel.i tried to connect both and get the data directly in to excel with out copy/paste procedure(i.e., just by refreshing the excel sheet would do). But when i create an ODBC connection between them, it says that the required permissions are not given to you by the administrator.I'm trying to create a file DSN.so,can anyone tell me what exactly i need for this?is it the admin rights of access database (or) the admin rights of the folder where the mdb file is located?little confused on this.I already have the admin rights on the folder where the mdb file is located but still getting the error.admin rights of the datasbe cannot be given because no one knows the password of administrator ID of Access database(little funny but it is the fact!)

can anyone please let me know how can i get through this problem as this would be the crucial thing for this project.

Regards,
Ravindra

View 1 Replies View Related

Access97 Permission Problem

Dec 19, 2007

I bought a database about 10 years ago and still uses it. Since then we changed our address and need to update all the forms as the address is hard coded into the forms. When I tried to modify any thing it tells me I don't have the Permission. I tried to contact the programmer, but he's been out of business years ago and was unable to contact him.

How do I reset the permission on MDB? I tried Tools->Security->User/GroupPremissions and it only shows Admin user with "Read Design" checked on all object names. And if I check on any other permission it says I need administer permission.

I tried upvmsa2k.zip "Users' passwords viewer v3.2" and it shows admin user with garbled up password. Also tried MDWRecovery, but it says there's no user or password.

Your help would be greatly appreciated.

View 3 Replies View Related

Security Problem In Access97

Mar 12, 2008

PLZ direct me about this security problem in Access 97.

I heve a serious problem with security of MDB files in ACCESS 97.

I heve a MDB database file in my company and shered it on my system so every other user have remote access to MDB file. then I created a workgroup file (.MDW) and enabled multiuser security For the shared MDB file but when each user dejoin from administrative workgroup file (.mdw), He/she can access to all table without any user/pass control.

How can I do with this problem, is there any reliable solution for multiuser security in Access 97 database files.

View 2 Replies View Related

Cannot Import From Excel To Access97

Oct 5, 2004

I noticed that I did not put a question mark next to this the first time I posted it, so maybe it was not clear that I was hoping for a response. Here I go again. We are trying to reinstall Access97 (the OS is Office XP) and having problems getting all of the drivers to install. Using the "Add or Remove Programs" in the Control Panel to make sure that all drivers have been installed, it says that the Excel drivers are installed, though it is grey, which I take to mean that it is not completely installed. On the computer in question, it says that the database drivers take up 1329k and the excel drivers are" installed" (no size listed). On my computer, on which the excel drivers are available, it lists the database drivers as 2009k and the excel drivers 258k (it does not say "installed"). Anybody have any ideas?

View 1 Replies View Related

Converting VBA For Access97 To Access2000

Nov 13, 2003

My organization recently upgraded from Office97 to Office2000. A database that we had on 97 is giving us errors when we try to run it under 2000. I have been able to fix some of the errors. This one has me stumped.

I'm getting an error 13; type mismatch and it is calling out this line:

Set Mydb = DBEngine.Workspaces(0).Databases(0)

Any help is greatly appreciated. This is the complete function:

Function RegistrationData(Reqinfo As String) As String
On Error GoTo error_registrationdata:


Dim Mydb As DAO.Database
Dim MyRS As DAO.Recordset


Set Mydb = DBEngine.Workspaces(0).Databases(0)
Set MyRS = Mydb.OpenRecordset("REGISTRATION")

Select Case Reqinfo

Case "CommandName"
RegistrationData = MyRS.COMMAND

Case "CommandCode"
RegistrationData = MyRS.COM_CODE

Case "CommandAddress"
RegistrationData = MyRS.COM_ADDRESS

Case "CommandManager"
RegistrationData = MyRS.COM_MANAGER

Case "CommandPOC"
RegistrationData = MyRS.COM_POC

Case "CommandPhone"
RegistrationData = MyRS.COM_PHONE

Case "CommandFax"
RegistrationData = MyRS.COM_FAX

Case "ClinicName"
RegistrationData = MyRS.CLINIC

Case "ClinicCode"
RegistrationData = MyRS.CLI_CODE

Case "ClinicAddress"
RegistrationData = MyRS.CLI_ADDRESS

Case "ClinicManager"
RegistrationData = MyRS.CLI_MANAGER

Case "ClinicPOC"
RegistrationData = MyRS.CLI_POC

Case "ClinicPhone"
RegistrationData = MyRS.CLI_PHONE

Case "ClinicFax"
RegistrationData = MyRS.CLI_FAX

Case "MailDir"
RegistrationData = MyRS.MAILDIR

Case "HROFile"
If Not IsNull(MyRS.HROFile) Then
RegistrationData = MyRS.HROFile
Else
RegistrationData = "error"
End If

Case "AboutYN"
RegistrationData = MyRS.ABOUTYN

Case "ActivityName"
RegistrationData = MyRS.ActivityName

Case Else
RegistrationData = "error"

End Select

end_registrationdata:
Exit Function

error_registrationdata:
MsgBox "There was an error retrieving data from the Registration Table. Please ensure all data is filled in correctly."
RegistrationData = "x"
Resume end_registrationdata:

End Function

View 6 Replies View Related

Runtime Access97 On Thumb Drive?

Dec 2, 2005

does anyone know if it's possible to "install" the runtime version of access 97 (we do have developer's edition, so can distribute the run-time version) to a thumb drive so that it would run without having to install it on each computer that one was going to use the thumb drive on - is there any add'l software that would make this possible/ - the application is for figure skating clubs - with distribution of up to 1000 copies - the idea is to distribute them to member clubs and various officers could use the application and exchange up-to-date data by passing on the thumb drive - this also would hpefully avoid all installation problems with pc's having various versions of access already installed, etc. - thanks for any suggestions- jim

View 6 Replies View Related

Control.caption Access97 To A2000

Jan 4, 2006

I am converitng a database with quite a bit of associated code from A97 to A2000. The following fails:

Dim ctlSample As Control

Set ctlSample = CreateControl(frm.Name, acLabel, acDetail, "", _
, sngLeft, sngTop, conWidthLabel, conHeight)

'set properties of the sample label

With ctlSample
.Caption = rst!SampAbrv


Is there a new syntax for ctl.caption in 2000? I've tried help and a web search but no joy.

Thanks,

Tiffany

View 11 Replies View Related

Import Text File Into Access97 Without Index

Sep 15, 2004

I am importing a text file into Access97 using fixed width with import specifications that specify NO to indexing. However, when I run the Macro, it automatically indexes the first field (which is a long integer).

Why? How do I import the text file without having the index automatically added?

View 2 Replies View Related

Db Importing

May 12, 2005

A common tip on this forum to reduce a db FE is to create a new db and import in from the original. Easy. Now I have done this and on navigating through the new db have no trouble when new. I then put in the start up form and close it. On start up again I get the following message. "Error accessing file. Network connection may have been lost". When trying to view any VBA coding the same message appears.
All tips or directions to other treads welcome.

Thanks

View 2 Replies View Related

Importing

May 11, 2006

I imported a database designed several years ago into Access 2003, but all that I got was the tables. Is there a way to get the reports, queries, forms, etc? Thank for all the help.

View 2 Replies View Related

Importing Xml

Feb 14, 2008

I have an xml from the powers that be in IT: can post it here if anyone wants, but it's quite big. Tried to import it into Access 2003, no joy. Than I realised that it it's almost certainly attribute-centric.

http://support.microsoft.com/kb/285329

And so I need to create a template to make it look normal. although they give an example on the microsoft page, it's bespoke to the xml they create from Northwind and i'm struggling to write a template from scratch.

The xml appears to have tables embedded and all sorts, it's not just a flat file structure....

can that be reversed out with a template?

View 4 Replies View Related

Importing Xml To .mdb - Help!

Nov 27, 2004

Hi, I want to automatically import an .xml file into a table that i have in my .mdb. Is this possible and if so, how do I do it?
If you could point me in the right direction that would also be great.

Thanx in advance...

View 3 Replies View Related

Importing

Apr 3, 2006

I am trying to import into a table a very large text file that has information dumped into it every morning from a daily import.

I am building a database that is also using the same information but on a stand alone database and was curious to know if there is a way to link the txt file to a table so every morning that the new info is imported it will just automatically dump into the table.

I have filling this is not since it is a txt file and I will need to just setup a custom menu button that when pressed does the import into the table, but I was hoping it would be as simple as a link.

Thanks ahead of time.

View 2 Replies View Related

Importing

Jun 9, 2007

I am importing from a spreadsheet. The column is formated as text.
In the design view of the Access table for the associated field it is showing text.

When it encounters a record that is all numbers and no letters it imports it as an exponent

i.e. 32986698 is imported as 3.29867e+007

What can I do to correct this?

Thanks
Bill

View 1 Replies View Related

Importing

Aug 3, 2005

When importing excel spreadsheets to access, I am getting the message subscript it out of range. What do I need to do in order for the spreadsheet to be imported?

View 2 Replies View Related

Importing Csv Files

May 25, 2005

Hi

I am having much trouble importing csv file into access 2003

My freewebs site have a registration form
The forms are then downloaded into my pc as csv files

According to freewebs, the csv file is access friendly and can be imported into access

so I tried for about a million time and still no luck

where did i go wrong?

this is what i did

help !

regards
frontpageplanners

View 14 Replies View Related

Importing Photos

Jun 10, 2005

Have can I apply individual photo's to members records.
One photo for the one person in each record.

Foxy

View 4 Replies View Related

Importing With Validation

Jun 15, 2005

Hi all,

My boss and I were trying to import some data from a .txt file there is a deliberate mistake and we were trying to get a input mask/validation rule to stop that particular record

thanks,

Dellero

View 2 Replies View Related

Can't See All Forms When Importing To DB

Aug 30, 2005

I'm having trouble with a DB that I've been using for four years in a multi-user environment. (Windows XP; Access 2000; Novell Network) Started with one user as she got a new WinXP PC (had Win2K - not totally convinced that she didn't have the problem before the new PC); she wasn't able to do a keyword search - it would bring up every record, but other users were fine. Then, it started to do it on my PC as well (WinXP - even though I had my XP for a year longer), but other users are still fine. My code still looks fine, and apparently works for others.
So, thinking there may be some corruption going on, I decided to create a new DB and import in tables, queries, forms, reports, and modules. Only three of 20 forms show up as options to import and only a portion of the reports show up. All the tables and queries appear. When I go back to the "faulty" database, the forms are there and do work from my "menu form".
Then, I tried compacting the "faulty" database, but I don't get the message in the lower left saying it is compacting; the hourglass comes up, then the DB opens - the size stays the same. So, I don't think it is compacting.

Any ideas ????

Thanks - and I do appreciate this forum - has saved me alot of time over the years.

View 1 Replies View Related

Importing Table

Jan 17, 2006

I have a linked csv table into access, and have a make table query which runs off this. When i first build and run the query it runs fine, but when i run it again I get the following problem "numeric field overflow" I have checked all the data types, they match fine.....

The thing that i cannot understand is when I rebuild the query from scratch, it works fine for the first couple of times, then stops.

View 5 Replies View Related

Importing Data

Jun 6, 2006

I'm using a combo box control for searching employees. Which the empID is the unique key, the form is scrolling each record, do not want it to do that. When i click on an ID, it only changes ID's but not the information thats tied to that ID. How can I fix that? any valuable information is well appreciated. Thank you

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved