Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Access Table Change
Name: killerace101 Date: July 11, 2005 at 11:47:42 Pacific OS: Win XP CPU/Ram: 2.0Ghz/1Gig Ram
Comment:
Hi, i have an Access database that is located on a network drive which is mapped to my computer.
The problem seems to be that my tables change types out of the blue. One day i have memo fields and the next day they are in text. This therefore cuts my fields to 255 characters. Also i have numeric fields that change to text. This has happened in only on etable for now. Would anyone know about this problem!
Name: Jennifer SUMN Date: July 11, 2005 at 12:44:52 Pacific
Reply:
Does anyone else have access to the Database?
Soylent Green is PEOPLE!!!
0
Response Number 2
Name: killerace101 Date: July 13, 2005 at 11:55:41 Pacific
Reply:
Nope i am the only one with access to the database. Again this morning the problem occured! The database has mysteriously changed two columns, hence changing the data!
Jonathan
0
Response Number 3
Name: smithdk Date: July 13, 2005 at 14:41:23 Pacific
Reply:
Make note of the date and time of the database file when you exit it. The next time you need to go into it, look at the date and time again before you open it up to see if it has changed.
0
Response Number 4
Name: Jennifer SUMN Date: July 14, 2005 at 04:22:20 Pacific
Reply:
The filed types can't just change by themselves. I recommend passwording the mdb file. That way, you'll be the ONLY one who can open it.
Summary: I have an Access table with 1600 records in it. What I want to do is be able to count how many records there are of a certain type. For example I have 6 different entries in a genre field. Rock, Co...
Summary: A field can't be both. It must be one format or the other. What type of data is being imported to the Access Table? What happens when you attempt to change the field type? ...
Summary: U mean u want to use the file coming from access to an other table? May be u can link ur txt file with excel , an then link ur access table to excel file...? ...
0 
